Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts,
What is the difference b/w the dimension and add calculation dimension? explain
You are probably refering to the dimension tab of a chart?
In general, a dimension is used to group by your record set to calculate the aggregates.
As dimension, you can use any field that exist in your data model.
That's where you can click on a field name and 'Add' to the list of dimensions on dimension tab.
But you can also do a transformation of a field, a so called calculated dimension.
For example, your data model only contains dates, but you want to group by Year:
=Year(DATEFIELD)
could be used as calculated dimension then. There are more complex calculated dimensions, but in principle, there are all similar in providing something 1-dimensional (like an array of values) to group your record set.