Explore topic-wise InterviewSolutions in .

STAT 1 through STAT N.

STAT 1 through STAT n.

MIN 1 through MIN N and MAX 1 through MAX n.

MIN 1 through MIN n and MAX 1 through MAX n.

a. Number of records. 
B. SUMMARIZATION ration (compression) .
c. LAST used DATE — remember if you don’t see any recent activity then this aggregate is not used.

a. Number of records. 
b. Summarization ration (compression) .
c. Last used date — remember if you don’t see any recent activity then this aggregate is not used.

AGGREGATES that are BUILT on other aggregates; the hierarchy is done automatically; it is recommended that you CREATE a few base large HIERARCHIES and small aggregates can be built from hierarchy.

Aggregates that are built on other aggregates; the hierarchy is done automatically; it is recommended that you create a few base large hierarchies and small aggregates can be built from hierarchy.

The CHARACTERISTICS in this area are not DISPLAYED in the initial VIEW of the query but you can drill down and filter once you execute the query.

The characteristics in this area are not displayed in the initial view of the query but you can drill down and filter once you execute the query.

The CHARACTERISTICS in this AREA are RESTRICTED and cannot be FILTERED or DRILLED down further.

The characteristics in this area are restricted and cannot be filtered or drilled down further.

For ODS and infosets, the QUERY DESIGNER AUTOMATICALLY adds this key figure “number of RECORDS” to COUNT the records.

For ODS and infosets, the query designer automatically adds this key figure “number of records” to count the records.

These are key FIGURES “RESTRICTED” by ONE or more characteristics; for example when you want to compare the sales of product “A” between different FISCAL year periods, you will create a restricted key figure with “Sales QTY” as key figure and restricted by OMATERIAL of value “A”.

These are key figures “restricted” by one or more characteristics; for example when you want to compare the sales of product “A” between different fiscal year periods, you will create a restricted key figure with “Sales qty” as key figure and restricted by OMATERIAL of value “A”.

This features allows you to mark a selection in the query designer as “Constant”; navigation and FILTERING has no effect on this selection during RUN time; for example if you want to report a PRODUCT’s sale in reference to a product group rather than all the products, you make the product group as the constant selection; any drill down, navigation, filtering will always give the sales QUANTITY of the product group.

This features allows you to mark a selection in the query designer as “Constant”; navigation and filtering has no effect on this selection during run time; for example if you want to report a product’s sale in reference to a product group rather than all the products, you make the product group as the constant selection; any drill down, navigation, filtering will always give the sales quantity of the product group.

1MG -> ACTIVATE PERSONALIZATION for HEX.

1MG -> Activate personalization for hex.

To do complicated CALCULATIONS on key figures such as mathematical FUNCTIONS, percentage functions and total functions, etc.

To do complicated calculations on key figures such as mathematical functions, percentage functions and total functions, etc.

This is defined as parameter1 % pararneter2; EXAMPLE ACTUAL EXPENSES EXCEEDS the % budgeted expenses.

This is defined as parameter1 % pararneter2; example actual expenses exceeds the % budgeted expenses.

It is DEFINED as parameter 1%A parameter 2; GIVES the percentage SHARE of parameter 1 of parameter2.

It is defined as parameter 1%A parameter 2; gives the percentage share of parameter 1 of parameter2.

DEFINED as %CT parameterl; GIVES the RESULT in percentage with respect to result.

defined as %CT parameterl; gives the result in percentage with respect to result.

Defined as %GT parameter 1; similar to PREVIOUS but the PERCENTAGE is share of OVERALL results.

Defined as %GT parameter 1; similar to previous but the percentage is share of overall results.

Count (PARAMETER) RETURNS VALUE I if parameter is not zero ELSE zero.

Count (parameter) returns value I if parameter is not zero else zero.

ndiv0(PARAMETER) RETURNS 0 if the parameter returns DIVISION by 0.

ndiv0(parameter) returns 0 if the parameter returns division by 0.

SUMCT(PARAMETER) RESULT of parameter in all ROWS and COLUMNS.

sumct(parameter) result of parameter in all rows and columns.

OVERALL RESULT.

Overall result.

REPORT RESULT.

Report result.

MAX, MI ABSOLUTE, SMALLEST, DIVISION.

Max, Mi Absolute, smallest, division.

1 or 0.

1 or 0.

RIGHT click on the LOCAL structure, SELECT SAVE as, enter technical name and description.

Right click on the local structure, select save as, enter technical name and description.

COMBINATION of CHARACTERISTICS and KEY FIGURES.

Combination of characteristics and key figures.

These are QUERY LEVEL STRUCTURES which can be USED in any QUERIES.

These are query level structures which can be used in any queries.

GIVES definition of specific cells in QUERIES (INTERSECTION of TWO structures one characteristics STRUCTURE and one key figure structure).

Gives definition of specific cells in queries (intersection of two structures one characteristics structure and one key figure structure).

CELL specific DEFINITION allows you to define explicit formulas to override implicitly created cell values; this allows you to design much more DETAILED QUERIES use the icon to create exception cells.

Cell specific definition allows you to define explicit formulas to override implicitly created cell values; this allows you to design much more detailed queries use the icon to create exception cells.

Valid RANGE is 1 to 1 billion; if you set a scaling factor of 1000, then the VALUE 3000 is displayed as 3.

Valid range is 1 to 1 billion; if you set a scaling factor of 1000, then the value 3000 is displayed as 3.

This defines how the KEY figure is aggregated in relation to exception characteristics usually a TIME characteristics; for EXAMPLE when you report number of employees by cost CENTER, you would CREATE a exception aggregation on “Last Value”.

This defines how the key figure is aggregated in relation to exception characteristics usually a time characteristics; for example when you report number of employees by cost center, you would create a exception aggregation on “Last Value”.

STRUCTURE of characteristics to view DATA in DIFFERENT ways.

Structure of characteristics to view data in different ways.

NODES are like branches in trees; the uppermost is ROOT node and a hierarchy can have MULTIPLE ROOTS.

Nodes are like branches in trees; the uppermost is root node and a hierarchy can have multiple roots.

All NODES in the same LEVEL are in the same level.

All nodes in the same level are in the same level.

This is to group LEAVES TOGETHER AUTOMATICALLY; so when a NEW value is added to a characteristics it is added to the proper interval automatically.

This is to group leaves together automatically; so when a new value is added to a characteristics it is added to the proper interval automatically.

This NODE is used to INCLUDE a SUB tree in a hierarchy more than once.

This node is used to include a sub tree in a hierarchy more than once.

RSR00001.

RSR00001.

EX1T_SAPLRRSO_0O 1.

EX1T_SAPLRRSO_0O 1.

ZXRSRUO 1.

ZXRSRUO 1.

a. 1_VARTYP - variable TYPE 1 — CHARACTERISTIC, 2- hierarchy node , 3-text, 4- FORMULA, 5-hierarchy.
b. I_IOBJNM - name of the info object.

a. 1_VARTYP - variable type 1 — characteristic, 2- hierarchy node , 3-text, 4- formula, 5-hierarchy.
b. I_IOBJNM - name of the info object.

This is the structure to POPULATE E_T_RANGE; LOW - low end VALUE; HIGH - high end value; SIGN — ‘I’ to include, etc; OPT — GIVES the OPTIONS like ‘BT’ for between, EQ’ for equal, etc.

This is the structure to populate E_T_RANGE; LOW - low end value; HIGH - high end value; SIGN — ‘I’ to include, etc; OPT — gives the options like ‘BT’ for between, EQ’ for equal, etc.

This is the internal table POPULATED with variable VALUES in CUSTOMER exit.

This is the internal table populated with variable values in customer exit.

It is the variable containing variable name within ABAP; you should do a CASE statement on this to GET the variable you are working.

It is the variable containing variable name within ABAP; you should do a CASE statement on this to get the variable you are working.

These are QUERY input, replaced at RUN time by BEX QUERIES.

These are query input, replaced at run time by bex queries.

Characteristics, HIERARCHIES, HIERARCHY NODES, texts and FORMULA elements.

Characteristics, hierarchies, hierarchy nodes, texts and formula elements.

VARIABLES are defined for info OBJECTS; so they are AVAILABLE ACROSS info providers.

Variables are defined for info objects; so they are available across info providers.

CHARACTERISTICS, HIERARCHY NODE, TEXT and hierarchy VARIABLES.

Characteristics, hierarchy node, text and hierarchy variables.

You can select dynamic INPUT for characteristics using this; for example if you are developing a SALES report for a given PRODUCT, you will DEFINE a variable for OMATERIAL.

You can select dynamic input for characteristics using this; for example if you are developing a sales report for a given product, you will define a variable for OMATERIAL.

These are USED to display dynamic texts for a given characteristics; for example take the SALES report for a given product for the last 3 months; the inputs prompted are product and fiscal year period; on the column level you have drilled down by fiscal year period; since the fiscal year period is dynamic (DEPENDING on the user input), you want to display the correct descriptions for the 3 months displayed; so in this CASE create a text VARIABLE for the fiscal year period and use it in the text of properties; these are defined as &text_variable_name&.

These are used to display dynamic texts for a given characteristics; for example take the sales report for a given product for the last 3 months; the inputs prompted are product and fiscal year period; on the column level you have drilled down by fiscal year period; since the fiscal year period is dynamic (depending on the user input), you want to display the correct descriptions for the 3 months displayed; so in this case create a text variable for the fiscal year period and use it in the text of properties; these are defined as &text_variable_name&.

These are variables USED in CALCULATIONS in the query; for example TAKE a customer discount report where each customer is given a different percentage discount; you create a formula variable for the discount percentage and use it in the calculated key figure.

These are variables used in calculations in the query; for example take a customer discount report where each customer is given a different percentage discount; you create a formula variable for the discount percentage and use it in the calculated key figure.

a) FIXED HIERARCHY and VARIABLE hierarchy node where only the node is selected at run time B) variable hierarchy and variable node where both hierarchy and nodes are selected at run time.

a) fixed hierarchy and variable hierarchy node where only the node is selected at run time b) variable hierarchy and variable node where both hierarchy and nodes are selected at run time.

User entry, REPLACEMENT path, authorization, CUSTOMER EXIT and SAP exit.

User entry, replacement path, authorization, customer exit and sap exit.