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.
Requires Free Membership to View
When you register, you will start receiving targeted emails from my award-winning team of editorial writers. Our goal is to keep you informed on the hottest topics and biggest challenges faced by SAP professionals today.
Hannah Smalltree, Editorial Director
Go back to the BI/BW quiz answer sheet
This was first published in September 2006