Skip to Content

How to add enhanced master data attribute to the cube ?

Hello Gurus,

I have an enhancement requirement where I need to add a new field in the report, which is a master data attribute of 0MATERIAL. We are doing inventory scenario and in order to get this enhanced field to the cube, I believe we should enable this field as the navigational attribute to the cube. So, my doubt is that can I just add this new field as navigational attribute to the cube without dropping any data from cube or without remodeling? Kindly help..

Thanks

Rakesh

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    Posted on Jan 28, 2014 at 09:02 AM

    Hi Rakesh,

    1.first select switch in the Navigational attr under 0MATERAIL info object which ever you required.

    2. after that select the info cube level under navigational attr folder -> expand the navigational attr -> select navigational attr you required.

    3. finally select the multi proivder level which ever you selected in info cube level -> select navigational attr -> right click-> select assign(identify)

    4.same navigational attr select in bex query designer level.

    5. imp of navigational attr it will improve the performance and we can perform drill down, drill accords.

    hope it will help.

    Thanks,

    Phani.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2014 at 09:14 AM

    we can select navigation attributes without deleting data in cube, go to edit mode of cube and select the navigation attribute and activate the cube, if any other targets like multiprovider is created on top of the cube it will be in inactive state so activate it and also check navigation attribute in multiprovider.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 28, 2014 at 08:57 AM

    Hi,

    Yes, you can select navigational option at cube level. To enable navigation attribute at cube level data deletion was not needed.

    Attributes are loaded thru master data loads. But cube activation may take hours as per the data volume at cube level.

    Do at dev system and check it. later you can move changes thru transport to prod.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2014 at 08:58 AM

    hi Rakesh,

    1) make sure the attribute is navigation on your infoboject (or add it/make it avialable in RSD1)

    2) go to your cube -> EDIT

    3) Go to Navigation Attributes,tick the attribute that you want to make available

    4) activate

    5) Go to your MulitProvider -> EDIT

    6) Go to Navigation Attributes,tick the attribute that you want to make available

    7) right click on your navigation object -> ASSIGN

    8) Assign it to you navigational object in your cube

    9) Activate.

    Cheers,

    Mathijs

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2014 at 11:24 AM

    Hi Rakesh,

    You can do that. No checking navigational attribute no need to delete the data from target. After checking the navigational attribute in cube and multiprovider just transport the required objects including your query changes. It will work.

    Thanks,

    Kamal

    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.