Skip to Content

Creating Navigational Attributes

Creating Navigational Attributes

Applies to:

SAP BI/BW 7.0 and above. For more information visit the Enterprise Data Warehousing

Summary

This document provides an overview of the use of navigational attributes in the SAP Business Information Warehouse. The document gives an overview of the navigational attribute features and a detailed step-by-step solution to create navigational attribute.

Author: Deepa C George

Created on: 28th Nov 2012

Author Bio

Deepa was working as a SAP BI/ BW Consultant in SAP Labs India Pvt Ltd and has techno-functional experience of over 3 years in SAP BW/BI.

 

Table of contents

Overview

Navigational attributes

Use

Example

Performance

 

Overview

Navigational attributes are attributes which can be used like any other characteristic. Display attributes can only be used for display purpose, that is, it will only act as a detail of the characteristic. But if we declare an attribute of a characteristic as navigational attribute, we can do functions like drilldown, filter etc on this attribute like we do on any other characteristic.

   

Creating Navigational attributes

First go to the infoobject and its attribute which needs to be declared as navigational attribute.

Here I have taken the infoobject 'Customer ID' (Z00CUSTID) and chose its attribute 'State' (Z00CSTATE) to be defined as a navigational attribute.

Go to edit mode of the infoobject -> Attributes.

Here you can see the 'Nav attr' On/Off button. Switch it on.

You can also give a description to the nav attr. I have named as 'State nav. attr.'

Once you switch on the nav attr the type will change as 'NAV' from 'DIS' which is 'Display attribute'.


The technical name of the attribute is 'Z00CUSTID__Z00CSTATE'.

Infoprovider

Now go to the infoprovider definition (Z00IC3). Go to Edit mode and switch on the nav attr button here also. Put a 'tick' mark there.

Now you can go to the query designer to create a query based on this infoprovider. You can see the new nav attr created under the 'Customer' infoobject. You can add it to rows or columns just like any other characteristic. You can give restrictions also to it.

How to use it - Query designer


Now execute the query, you can see that the navigational attribute appears in the query result just like any other characteristic like 'Customer'. You can remove drilldown on it, add it to columns, filter on it etc etc..


I have added the filters 'MD' and 'GA' to it and now the result is filtered based on this.


This is how you can create and use a navigational attribute.

           


Related Content

Performance of Navigation Attributes in Queries and Input Help

Enterprise Data Warehousing

Tags:
Former Member