How to add enhanced master data attribute to the cube ?

[Former Member]

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

[KodandaPani_KV · Accepted solution]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

hi,

you need to reload your data to generate the required SIDs for your new navigational attributes so a reload would be required.

Rgrds,

Mathijs

[Former Member]

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

😎 Assign it to you navigational object in your cube

9) Activate.

Cheers,

Mathijs

[RamanKorrapati]

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