|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
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.-->