Navigational attributes appear as characteristics in query designer. Sap bw data modeling guidepart 2 sap bwsap bobjsap. You determine whether or not the characteristic can have attributes or texts. The business explorer bex is a component of sap bi that provides. This document provides an overview of the use of navigational attributes in the sap business information warehouse. Otherwise the navigation attributes can be set for a particular characteristic, on the output tab. For the superior composite provider, only those navigation attributes can be activated, which already activated in. How to create an infoobject with characteristics in sap bibw. Infosets which use navigational attributes from an infocube in combination with a.
Open hub destination make use of navigational attributes. Infoobject in sap bw before a simple report could be created. Difference between navigational and display attribute in sap bi duration. Attributes can be marked as navigational or display attribute by clicking on navigational attribute onoff button. Difference between display and navigational attribute. Variant configuration with sap schweitzer fachinformationen. For more information on f4 help behaviour in bw75 and bw4. A navigational attribute of a navigational attributes is called transitive attribute. Attributes are nothing but the fields or properties of master data, there are different types of attributes like display attributes, navigational attributes, executive attributes, compound attributes and so on. Bi query queries users guide oregon state university. Administration and performance optimization amazon s3. Values of navigational attributes will store in x and y tables.
In this case, a new edgedimension is added to the infocube. The values for display attributes are derivedby this class from the year of the data record. In the backend, the relationship between tables are totally different. The document gives an overview of the navigational attribute features and a detailed stepbystep solution to create navigational attribute. Navigational attribute vs characteristic in a dimension sap. For more information visit the enterprise data warehousing summary. Navigation attributes sap netweaver business warehouse. They can be selected in the query in exactly the same way as the characteristics for an infocube. Beside the simplification list in pdf format this document, the simplification list is.
If a navigational attribute has the further more navigational attributes as its attributes in it those are called transitive attributes. As we all know drill down in report is possible if the characteristic is navigational attribute and is not if it is display attribute. In sap bw systems, the ewa provides a section that analyzes the design. From the file menu, click save to save your mapping. Types of attributes in sap bw explore to sap business. For dimension characteristics, dim table links all sid table directly and in navigation attribute, the navigation attribute is link to chars sid table not dimension table. As 0calweek does not contain any navigational attributes, there wont be. For 0calyear the system is not delivered empty in bw4 system. For more information visit the enterprise data warehousing summary this paper tells about usage of open hub destination in downloading the data to application layer considering navigational attributes. This source group represents the source dataset made up of sap bw data target. Open hub destination make use of navigational attributes applies to. Characteristic attributes can be converted into navigation attributes.