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

Performance problem with the use of Nav Attr

Friends,

I have turn on the Nav Attr of the MultiProvider. I built the report from this MultiProvider, and use this Nav Attr

as part of my selection key. I noticed that if we use the Nav Attr as selection key, it will slow down the performance in

general. It take some 30 sec to display a single record.

Is there any where and anything we can do to improve the performance in this case?

Please advise, thank you.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 23, 2008 at 05:31 AM

    Hi

    Queries using navigational attributes will be slower since additional tables have to be joined with the Fact tables to get the desired results. If there are changes to the values of navigational attributes, the aggregates using these will have to be readjusted, which is done by a change run. Navigational attributes can be made to display only without removing the data from the cube.

    Possible workaround for this situation could be, manually creating indexes on the master date table to improve query performance which uses navigational attribute.

    Regards

    Shilpa

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 23, 2008 at 05:40 AM

    Hi,

    Which kind of objects are included in the multiprovider ?

    Also it seems that system is reading entire data in the data target involved in multiprovider , thats why its taking long time .

    I think you should create index upon it and then see the performance .

    In case infocube is present in multiprovider, aggregate may help.

    Hope that helps.

    Regards

    Mr Kapadia

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Shilpa, Mr Kapadia,

      Thanks for you advise, can you please explain the steps on how the Index should be created?

      I have InfoObject Master Data 0PM_ORDER used in the MultiProvider. This Master Data has Nav Attribute 0COMP_CODE. I turn ON this Nav Attr in the MultiProvider which I need it to be part of my selection key.

      How should I do the indexing?

      Please advice, thank you.

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.