cancel
Showing results for 
Search instead for 
Did you mean: 

Hierarchy variables losing reference in BO Reports

Former Member
0 Kudos

Hi All,

I have build a webi report based on BexQuery.In the BexQuery we have a mandatory hierarchy variable.

For example Organization hierarchy and it should refer to current sales structure.

But when i created universe this variable is not coming under current sales structure class it is losing reference and when i run the report its throwing error instead of showing Lovs.

I tried adding Current sales structure characteristic to Free characteristic,but no luck.

Can any when explain me why this is happening.

Thanks

Arun

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

To enable hierarchy varaibles for external access eg. to MDX, we have to maintain an entry in RSADMIN table (check note 1007048), I believe, the same kind of action is required to access hierarchy variables through WebI, please check service market place, you will get full details.

Regards

Charan.

0 Kudos

Did you refresh your universe after the change in the BEx query? In the Universe designer import your Universe from the BO repository and select View->Refresh structure. After the universe is refreshed save it back to your BOBJ repository.

Regards,

Stratos

Former Member
0 Kudos

Yes,Every thing is done,still the problem there

0 Kudos

What's the exact error you see?

Regards,

Stratos