Variable on Navigational Attributes in ODS

[Former Member]

BW Experts,

I have a Navigational Attribute in my ODS. In my query design, I do not get an option to build a variable for selection on this Navigational attribute. Is it a fact with ODS that Variable cannot be built on Nav Attributes?

Thanks

Ashwin

[edwin_harpino]

hi Ashwin,

we have to logout and login again bex analyzer to reflect any changes on infoprovider, i guess you were opening bex and turn on ods navigation attribute and couldn't find it in bex query, then you logoff and login again and see the navigation attribute, you can have a try

hope this helps.

[edwin_harpino]

hi Ashwin,

we can have variable on navigational attribute,

not sure can create from navigational attribute (no access to system to check),

but you can create from the basic infoobject itself first, then after drag the navigational attribute to query, right click it and 'restrict', and choose variable.

hope this helps.

[Former Member]

Yes u r right AHP. It worked. I dunno why it did not work the first time I was trying!!