TBW 20

In Query designer, what are different types of Exceptions. Status Exception. Data Exception.

What types of variables are possible while declaring threshold values. Formula. Text. Hierachy.

Exceptions created in Query designer can be changed in Web analyzer? T/F. True. False.

Exception can be applied on a specific key figure. True. False.

Exception can be applied on a specific characteristic. True. False.

Several exceptions are possible in one query. True. False.

The color of alert level can be applied to key figure and characteristic values. True. False.

Minimum two key figures are required to define Trend exception. True. False.

FORMULA COLLISION FUNCTION ONLY DISPLAYS IN THE PROPERTIES DIALOG BOX IF TWO STRUCTURES ARE USED IN THE QUERY DEFINATION. TRUE. False.

A QUERY CAN HAVE A MAXIMUM OF TWO STRUCTURES, THERE IS NO RESTRICTIONS AS TO WHERE THESE STRUCTURES APPEAR IN THE LAYOUT, I.E YOU COULD PUT BOTH STRUCTURES IN THE COLOUMNS. True. False.

CELL EDITOR IS A FUNCTION OF THE BEX QUEY DESIGNER, YOU CAN SELECT THE EDITOR ONLY IF THE QUERY DEFINATION CONTAINS TWO STRUCTURES. True. False.

Which table contains business rules for performing the elimination on the special key figures. RSDICE. RSDIOBTCMP. Both. None.

Which type of elimination is performed for eliminating revenue between a country & partner country that are assigned to the same node of the country hierarchy. ICE_REV1. ICE_REV2. ICE_REV3. ICE_REV4.

In query Designer, “No of Records” generated key figure appears for. ODS. InfoObject with Master Data. Infocube.

Valid Time Interval is. A generated key field. A generated dimension. Valid for Infoset. Valid for DS Objects.

Multiprovider always has “No of records” generated key figure. True. False.

For an Info Set done on an DSO and a characteristic, how many dimensions are displayed in Query Designer. 1. 2. 3. 4.

“Infoprovider” generated characteristic forms part of which of Dimension. Unit. Datapackage. Time.

A restricted key figure can be characteristic independent. True. False.

CKFs can be built on. CKFs. RKFs. Basic KF. Hierarchy nodes.

A restricted key figure can be created while defining a calculated key figure. True. False.

The Description of a Key Figure can be. Between 59-80 chars including Line Break. Maximum 60 including line break. Maximum 59 including line break. Can be anything.

Which of the following is True. Formula collision occurs when two structures are present and any one contains a formula. Formula collision occurs when one structure is present and contains two formulas. Formula collision occurs when two structures are present and both contain formulas.

Using which of the following settings can the user be allowed to enter data in cells. Local Calculations. Highlight. Constant Selection. Change Data. None of the above.

Which of the following is true. A query can have maximum two structures. Rows can have maximum two structures. Columns can have maximum two structures. A structure can have a mix of characteristics and key figures. None of the above.

What is the prerequisite for using cell editor?. The query should have two structures with formulas. The query should have two structures.

What are the options for reporting relevant hierarchy settings in the hierarchy maintenance. Level Maintenence. Heirarchy Attributes.

Variables act as placeholders for. Charecteristic values. Hierarchies. Hierarchy nodes. Texts. Formula Elements.

What are the Variable Processing Types. User Entry/Default Value. Replacment path. Autherization. Customer exit. SAP Exit.

If you choose the ‘Authorization’ processing type when you create a variable, the variable fills automatically with the values in the user’s authorization. True. False.

Which processing type is used in variables that are delivered with the SAP BW Business Content. SAP Exit. Customer Exit.

What do we use to analyze the key figures that have a fixed time-relationship to one another. Variable offset. Customer exit.

In Conditions general tab if you do not set the Condition status as “Active” can the condition be activated in the report itself?. True. False.

.While defining a Condition in Condition Parameter Box of query designer one of the fields is “Values” which are the other fields. Key Figure. Operator. Condition Level. Variable.

A condition row consists of. Char. KF. Variable. Operator. Value for the operator.

For Conditions in query definition containing 2 structures there is an additional field for defining a. Variable. Fixed Value. Structural Component. Condition Level.

Which of the following operators can be used for threshold value conditions. =. <. <>. Bottom sum.

Which of the following operator are for ranked list functions in Conditions. Top %. Bottom %. Bottom Sum. Top Sum. All Above.

While executing a report with an active condition you see the unconditional query result in the. Overall result row(Overall result without filter). Cannot be seen.

To see the filtered (conditional) query result in the Bex Analyzer you can choose. Properties  Calculations  Calculate Result As  Summation. Properties  Filters  Conditions  Summation. Properties  Conditions  Filter by  Summation.

To see the filtered (conditional) query result in the web browser you can choose. Attributes  Data Cell Result Calculations Sum. Attributes  Conditions Result Calculations Sum. Attributes Data Cell Conditions Sum.

What are the 2 tabs seen while defining a condition. General Tab & Characteristics Assignment Tab. Property Tab & Characteristics Assignment Tab. Property Tab & Value Assignment Tab.

Conditions in conjunction with characteristics in your query can be applicable for. All characteristics in the drill down independently. Most detailed characteristics along the row. Most detailed characteristics along the column. Individual Characteristics & Characteristics combination. All of the above.

During Conditions conflict the following status descriptions can appear in the display. invalid. variant. Not used. none of the above.

While defining Conditions using Web Analyser the following condition types are available. Ranked List. Threshold Value. Mixed Condition. Range Parameters. All of the above.

Which is the correct sequence of defining conditions using web analyzer. Set Condition Type  Set Condition Parameter  Define Attributes Set Characteristics assignment. Set Condition Type  Set Condition Parameter  Set Characteristics assignment.--> Define Attributes.