It’s time to put what you’ve learned to the test, get 6 questions right to pass this unit.
Q1.
How can you restrict a characteristic with an external hierarchy in a query?
There are 3 correct answers.
A
Use one or multiple hierarchy nodes.
B
Use one or multiple characteristic values (leaves of the hierarchy).
C
Use combinations of hierarchy nodes and characteristic values.
D
Use either hierarchy nodes or characteristic values.
Q2.
Which of the following statements regarding row and column hierarchies are correct?
There are 3 correct answers.
A
Display attributes can be included in the hierarchical display.
B
Characteristics and navigation attributes can be included in the hierarchical display.
C
Structures can be included in the hierarchical display.
D
Characteristics with an assigned external hierarchy can be included in the hierarchical display.
E
Hierarchical display can be chosen either for the rows or for the columns.
Q3.
Which two steps are required to enable an attribute as a navigation attribute in a query?
There are 2 correct answers.
A
Activate the navigation attribute in the characteristic properties in BW Query Designer.
B
Add the display attribute to the Free section of the BW Query Designer.
C
Activate the navigation attribute in the SAP BW data flow transformation.
D
Change the attribute type from Display to Navigation in the InfoObject maintenance.
E
Activate the navigation attribute in the respective InfoProvider.
Q4.
You can sort the members of an external hierarchy in ascending or descending order.
Choose the correct answer.
A
True
B
False
Q5.
Which one of the following statements regarding external hierarchies is correct?
There are 3 correct answers.
A
An external hierarchy belongs to exactly one characteristic.
B
A characteristic can only possess one external hierarchy.
C
An external hierarchy cannot be created and maintained in BW.
D
An external hierarchy represents master data which is not part of the InfoProvider on which the query is based.
E
External hierarchies can be loaded from source systems.
Q6.
Which of the following statements regarding hierarchical structure display are correct?
There are 2 correct answers.
A
In a structure, drag the structure members that you want to display as subitems directly over the structure member that you want to display as the parent node for the subitems.
B
The hierarchical structure display only works for structures with key figures.
C
The number of levels for a hierarchical structure display is limited to 2.
D
You can use the node status to determine whether the node displays collapsed or expanded in the report.
Q7.
You need to create a report that shows non-selling materials. With which option in BW Query Designer can you choose to display characteristic values that do not have transaction data?
Choose the correct answer.
A
Change the access type for Result Values to Posted Values.
B
Change the access type for Result Values to Master Data.
C
Choose Always for the setting Show Result Rows.
D
Set the document link for master data in the query properties.
E
Choose Values in Master Data Table for the Filter Value Selection.