on 07-22-2014 12:19 PM
Hi to a,,
Just want to know why we have Data Category to Cube or Dimension in Calculation view ?.
I tried to search the lot, but did not get correct explanation.
please can any one explain in simple example.
Regards
Pavneet Rana
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The "benefit" is that the calc. views marked as dimension can be used as dimensions in calc. views with star joins. Also, dimension views don't come with default aggregation unlike fact-views.
Semantically this is the very same as attribute views and doesn't promise any performance improvement (or degration).
At this point this is more about being able to develop your whole information model as a set of calc. views and still having clear semantics defined for those.
- Lars
Just so happens I was doing some research on this same topic - glad to have found you guys
Lars - in fact, you can have a calculation view defined as data category '' (blank) and you are still able to use it in a star join. So for me, I am trying to understand the difference between BLANK and DIMENSION. From what I see - no measures are possible with a DIMENSION, but you may have them available in BLANK, ie all are attributes. Otherwise, seems to be no difference - they both terminate with a Projection node.
Anything else pop in your mind?
Regards,
Justin
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.