All,
Can I know where the table calculation is used which can't be achieved through LOD?
Which one will consume more memory? i.e LOD or Table Calculation for 5000000 records.
assume it is a simple {Fixed Category : Sum(Sales)} and the same can be achieved in table calculation.
Assume only Category filter is there in the pane. No other dimensions are added in the row. we have only Category in the row.
2 answers
I think not much difference when you are having only 1 dimension on Rows, but LOD would be better in other cases, It is my view, might be wrong. Remember, FIXED LOD is evaluated before Table Calculations, so has its own benefits,plus you can use it as Dimension, besides many other benefits.
Thanks
Deepak
