cancel
Showing results for 
Search instead for 
Did you mean: 

New master loaded. Nav attr not visible in Bex

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

Did u include ztestattr under navigational attributes while modelling ODS.

Just check it. some times we may miss it.

shylaja.

former_member378832
Participant
0 Kudos

Hi,

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

Hope this help

Supriatna

former_member188975
Active Contributor
0 Kudos

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
0 Kudos

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

former_member188975
Active Contributor
0 Kudos

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

0 Kudos

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.