How to use Navigational attributes in BEx

[Former Member]

Hi experts,

I have searched many threads regarding navigational attributes in BEX.

But unable to find any info.

How the navigational attributes are used in BEx query designer.

What is the difference between characteristics and Nav attr in Query designer.

Every one n saying Nav attr are used for drill down purpose.

What exactly is this drill down .

Please send me any related documents also.

Please answer me.

Thanks in advance

Sundar

[former_member222556 · Accepted solution]

Hi,

What is the difference between characteristics and Nav attr in Query designer.

Normal Char. & Nav. Attr. will provide same functionality in report

Diff is only between Display attr & Nav. Attr.

What exactly is this drill down .

you can seperatly put the NAv. Attr. in rows

whereas Display attribute can't be in rown seperatly

eg

Material is main master data ,

having Mat_Typ as Navi. Attr. & Mat_Grp as Display Attr.

you can put MAt_typ with any combination of chars. (plant, Salesrg,...) without putting material in rows

but Mat_grp will alway be additional information of MAterial that you can put in row without material

Best Regards

Obaid

[Former Member]

Hi,

The belongs example should clearly your doubt:

"You use the attribute u2018Cost Center Manageru2019 for the characteristic u2018Cost Centeru2019. If you want to navigate in the query using the cost center manager, you have to create the attribute u2018Cost Center Manageru2019 as a navigation attribute, and flag it as a navigation characteristic in the InfoProvider"

You can make a characteristic as navigational attribute in RSD1 , by enabling the check Navigational attribute.

If you turn a characteristic attribute into a navigation attribute, you can assign a text to the navigation attribute so that it can tell it apart from a normal characteristic in reporting.

Regards,

Amit

[former_member188080]

Hi,

Navigational attribute will behave like any other charateristics. There are master data tables and nav attributes tables as well.

It can be used in query for drilldown purpose so data can be seen against those. So say Country is the master data and there is region as attribute.

Country_Region will be included in report and you can rename description as Region.

Only navigational attribute drilldown will not be as fast as charateristics due to additional join.

Pl note you need to tick /mark these nav attributes in Infoprovider and Multiprovider to make them available in the reports.

Thanks and regards

Kiran

[Former Member]

Hi

Thanku every one for immediate response.

I stii have some doubts.

What is the difference between a normal characteristic and a navigational attribute.

what we can do with navigational attribute that we can not do with characteristic.

Can we use the characteristic as a navigational attribute.\

Thanks in advance

Sundar

[Former Member]

Hi,

Characteristic attributes can be converted into navigation attributes. They can be selected in the query in exactly the same way as the characteristics for an InfoCube. In this case, a new edge/dimension is added to the InfoCube. During the data selection for the query, the data manager connects the InfoProvider and the master data table (u2018joinu2019) in order to fill the Query.

Navigational attribute is like any other master data attribute except that we can navigate (filter, drill down and selection) in reports on this characteristic.

Drilldown means after you executed the query , you want to see further detailed data with particular combination ,

in that case you navigate further or do restiction that is drilldown.

If you restict a navigational attribute in Query , then it behaves like a normal characteristic and not as a navigation attribute.

http://help.sap.com/saphelp_nw04/helpdata/en/80/1a63e7e07211d2acb80000e829fbfe/content.htm

Also check the link:

http://help.sap.com/saphelp_nw70/helpdata/en/43/f234619e3c4c5de10000000a155369/frameset.htm

Regards,

Amit