Get started Bring yourself up to speed with our introductory content.

13. Navigational attributes

13. Select the correct statements related to navigational attributes.

a. It is better to avoid using navigational attributes from a query performance point of view.
b.If a navigational attribute is used in an aggregate, the aggregate needs to be adjusted every time there is a change in the values of this attribute.
c. An attribute included as a characteristic in the InfoCube has the same effect as being used as a navigational attribute in the cube.
d. A navigational attribute can be made to display an attribute without removing data from the InfoCube.
e. None of the above.

ANSWERS: A, B, D

Queries using navigational attributes will be slower since additional tables have to be joined with the Fact tables to get the desired results. If there are changes to the values of navigational attributes, the aggregates using these will have to be readjusted, which is done by a change run. Navigational attributes can be made to display only without removing the data from the cube.

Go back to the BI/BW quiz answer sheet

This was last published in September 2006

Dig Deeper on SAP MDM software

PRO+

Content

Find more PRO+ content and other member only offers, here.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close