Hello Rana,
If the data category is set to dimension,
on the other hand if the data category is set to a cube,
It is mandatory to specify at least one column as measure; otherwise, the view activation fails. Also, if the value is set to cube, an additional column called aggregation is available to specify the aggregation type for measures.
Regards,
Krishna.
Adding to what already Krishna mentioned,
1) To make the calculation View which needs only joins and aggregations are not required.
2) These views ( Data category = Dimension ) in star join .
Regards,
Krishna Tangudu
Hi experts
Some more questions here :
- It's OK about the restrictions, but then...What are the benefits of using dimension calc views ? (especially as compared to attribute views).
- Do we ave any feed back on performances comparing the 2 of them ?
Regards
Add a comment