New master loaded. Nav attr not visible in Bex

[Former Member]

Hello BW Experts,

Scenario

Ztestjob has attribute ztestattr

New master data records added are :

Ztestval1 ztestattr1

Ztestval2 ztestattr2

Data is already loaded in the ODS. Loaded new master data for iob Ztestiob. It has nav attribute Ztestattr1. Now in the Bex I can see the new values ztestval1 and ztestval2 and I cannot see the nav attributes values ztestattr1 and ztestattr2.

Possible causes:

SID for the nav attributes do not exist

Solutions

1) reload the transaction data

2) RSRV > ODS > foreignkey relationship test and automatic repair.

Please let me know if the possible cause is correct. Are there any other causes to be considered. Are there any other solutions to be considered.

Suggestions appreciated.

Thanks,

BWer

[Former Member · Accepted solution]

Hi,

You have to run the report "rsr_gen_direct_all_queries" in SE38.

Then all your navigational attributes get added in BEx.

Hope this helps.

Venkat

[Former Member]

Hi,

Did u include ztestattr under navigational attributes while modelling ODS.

Just check it. some times we may miss it.

shylaja.

[former_member378832]

Hi,

Have you run apply Hierarchy/Attribute Change from RSA1- Menu Tools/apply Hierarchy/Attribute (Ctrl+F9)

Hope this help

Supriatna

[former_member188975]

Hi BWer,

No need to reload the transaction data. Check if the master data ia active. And log out and log back into Bex.

Hope this helps...

[Former Member]

master data is active and also the attribute change run done. please suggest...

[former_member188975]

And did you log out and log back in to BEx, after doing the master data activation..?

[edwin_harpino]

hi BWer,

as well as hier/attr, rsrv etc already run, and re-login, you should be able to see the nav attr.

other program deal with sid problem is RSDMD_CHECKPRG_ALL.

hope this helps.