Skip to Content
author's profile photo Pavneet Rana
1
Pavneet Rana

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

Posted on Jul 22, 2014 at 11:19 AM 3.5k Views

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

Assigned Tags

Related questions

3 Answers

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

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

    • Former Member Pavneet Rana
      Jul 22, 2014 at 02:31 PM

      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.

    Comment on This Answer
  • author's profile photo Krishna Tangudu
    Krishna Tangudu
    Posted on Jul 22, 2014 at 11:44 AM
    1

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

  • author's profile photo S. Marie
    S. Marie
    Posted on Aug 05, 2015 at 12:51 PM
    0

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

    Comment on This Answer

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.