Skip to Content

why we have Data Category to Cube or Dimension in Calculation view

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

Add comment
10|10000 characters needed characters exceeded

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 22, 2014 at 11:35 AM

    Hello Rana,

    If the data category is set to dimension,

    • The output node does not offer any measures (or hierarchies), only attributes, which can be numerical data types
    • The calculation view is not available for reporting.
    • The calculation view is only consumable via SQL.
    • The default node is projection.


    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Pavneet Rana

      Hello Rana,

      If you do not check the star join in sps07 when you select "CUBE" as your data category then the default node will be set to aggregation (for multidimensional reporting) instead of star join.


      Regards,

      Krishna.

  • Posted on Jul 22, 2014 at 11:44 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 05, 2015 at 12:51 PM

    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 comment
    10|10000 characters needed characters exceeded