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

Number maximum navigational attributes on InfoCube

Hi all,

Somebody knows, what is the maximum the navigational attributes that I can to have on InfoCube?

I´m doing a development where I have 250 navegational attributes on InfoCube, but I´ll need more navigational attributes so I want to know if is necessary create other infocube or I can continue using the same InfoCube.

Can somebody help me, please?

Regards!

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Sep 23, 2014 at 05:50 PM

    Hi
    250 navigational attributes seems to be too large.
    Having too many navigational attributes will affect your query badly.
    So, please take care of your design.
    If possible then bring down the no of Nav Attrib.
    Thank You

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 23, 2014 at 05:14 PM

    Hi,

    how many navigational attr maximum i am not sure.

    while defining the master data object you need to select the navigational attr form display attr.

    in reporting level use for navigational attr required.

    not required for the creating the another info cube and with same technical name system won't allow duplicate cube.

    each dimension we have in insert the maximum object 236 char like 13 dimensions.

    Thanks,

    Phani.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 23, 2014 at 05:50 PM

    Hi,

    Not sure about the maximum no. of navigation attributes..

    I would like to suggest you to revisit your design as having 250 navigation attributes and trying add more is definitely not a good design and will have performance issues while reporting..

    i think in your case you should model your design by adding characteristics and use read from master data or routines to populate data in cube instead of going for navigation attributes.

    have a look at this link for more details: Performance of Navigation Attributes in Queries and Value Help - Modeling - SAP Library

    Regards,

    Rk

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      Thanks for your answers, I forgot to say that the model is on BW HANA, the InfoCube is optimized and we have several querys where we select characteristics different for the each report. Actually the performance is good, we don´t have any problem, but I have this doubt.

      Thanks and Regards!

  • Posted on Sep 23, 2014 at 06:30 PM

    Hi Lilia

    An advice regarding design of infocube please consider the fact that the high number of Navigation attribute will certainly affect query performance and also will lead to high runtime of attribute change if the navigation attributes are used in aggregates.

    Thus regardless the number of allowed navigation attribute please give a thought if such high number of navigation attributes are really required in infocube.

    Regards

    Ashish

    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.