Filter by NAV Attrib in IProvider

[Former Member]

Hi all.

I have a navigational attribute in characteristic & enabled in a InfoCube. I want to filter by this NAV attrib. in BEx. How can I manage this? I mean I see the sort possibility, but don't have any ideas how to filter by navigational attribute.

thanx in advance

[Former Member · Accepted solution]

Hi,

You can use Nav attribute as a characteristic in the report...... It acts anyother characteristic.. U can restrict it and u can create any variables on it.. Just drag and drop the nav attribute into rows or columns according to ur requirement...

Khaja

[Former Member · Accepted solution]

Maybe I miss something. When I drag it into rows the characteristic to which attrib belongs to goes together. And when I go to Restrict command I see only CHARACTERISTIC (not attrib values)

[Former Member · Accepted solution]

Gediminas,

Here you should not pull the char for which you have a nav attribute, but the nav attribute directly. The nav attribute will be shown on the left side like any other infoobject. You can drag and then restrict.

[Former Member · Accepted solution]

Hi

Make sure that u have switched on the Nav attribute in the Infoobject -> attributes tab... and also in the cube........

Navigational wont be depend on the main charactristic..........

Khaja

[Former Member]

Hi,

You have the navigational attribute under the main infoobject with the next format. For example 0country attribute from soldto is:

SOLDTO_0COUNTRY.

And you can use as a regular infoobject in free characteristics, rows or columns.

Regards

[Former Member]

Gediminas,

The nav attribute works like any other infoobject in reporting. You can filter the vaules for that attribute by restriction.