Skip to Content
avatar image
Former Member

How to use Navigational attributes in BEx

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    Aug 24, 2011 at 08:13 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 24, 2011 at 07:26 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 24, 2011 at 08:32 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Aug 24, 2011 at 09:53 AM

    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

    Add comment
    10|10000 characters needed characters exceeded