Skip to Content
author's profile photo Former Member
Former Member

Performance

Hello all,

I have a report which is created on cube which is using nearly 15-20 attributes ( of different Characterstics )

My question is ....

which is the best way of showing data in report.

i.e keeping it as Display Attributes and populating it in cube update rules using Master data attribute option - with this there might be little space issue

or

making it as navigational attribute and using them in reports - with this there might be performance issue.

sugget me the best option.

According to me i will go with first option.

Regards

KK

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 18, 2007 at 02:18 PM

    Hi,

    Do the values of these atrribute change?

    And in the reports do you want to save the original value or do they have to change too.?

    In your first option, if an attribute value changes, the existing values in the dimension of the cube will not change.

    Just an other point of view.

    Udo

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 18, 2007 at 02:45 PM

    Hi..

    it depends upon your reporting requirment.... if client what to drill down the ???

    no doubt about performance issues are their ...

    but there r strong points regarding navi attr

    Deactivation of navigational attributes is not possible

    Reporting possibilities differ depending on whether you define a dependent attribute as a characteristic, a navigational attribute or a node of an external hierarchy, because the locations offer different time scenarios.

    Thus the reporting needs investigated during the blueprint phase of the project normally define the location of a dependent attribute.

    When designing the same parent attribute as a characteristic in a dimension table (such as historical truth) and as an navigational attribute in a master data table (all other scenarios) remember that in a BI data model the navigational attribute should have a different name from its name in the InfoObject definition to avoid misunderstandings. Otherwise the same name would be repeated twice in the BEx Query Designer.

    Add a comment
    10|10000 characters needed characters exceeded

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.