Explore topic-wise InterviewSolutions in .

This is entered by the user at the run time of the query; you can SPECIFY a default value for this; example is the PRODUCT SALES report where you ENTER a product at run time.

This is entered by the user at the run time of the query; you can specify a default value for this; example is the product sales report where you enter a product at run time.

It tells the system to replace the value of characteristics in a calculation/expression at run time; look at the example where the query DISPLAYS dynamic heading for the fiscal year period; the VARIABLE type is TEXT and processing type is REPLACEMENT PATH.

It tells the system to replace the value of characteristics in a calculation/expression at run time; look at the example where the query displays dynamic heading for the fiscal year period; the variable type is text and processing type is replacement path.

In this case the system LOOKS for authorized values for the characteristics for the user and replaces that; for example let us LOOK at a COST center reporting; each manager is assigned one or more cost centers and are RESTRICTED from seeing other cost centers; so in this case, create a characteristics variable for OCOSTCENTER with processing type authorization; on the back end you should create reporting authorization objects and assign FIXED cost centers to each manager.

In this case the system looks for authorized values for the characteristics for the user and replaces that; for example let us look at a cost center reporting; each manager is assigned one or more cost centers and are restricted from seeing other cost centers; so in this case, create a characteristics variable for OCOSTCENTER with processing type authorization; on the back end you should create reporting authorization objects and assign fixed cost centers to each manager.

In this case, you write ABAP program on the back end and fill up the variable values; for EXAMPLE TAKE the case of COST center report; instead of defining as AUTHORIZATION assume that you get manager/cost center data in a Z table from R/3; in this case you will write ABAP code to a) read the user who has logged b) read the Z table to get the cost centers and fill up the variables.

In this case, you write ABAP program on the back end and fill up the variable values; for example take the case of cost center report; instead of defining as authorization assume that you get manager/cost center data in a Z table from R/3; in this case you will write ABAP code to a) read the user who has logged b) read the Z table to get the cost centers and fill up the variables.

RSR00001.

RSR00001.

EXIT_SAPLRRSO_00 1.

EXIT_SAPLRRSO_00 1.

SAP Exit is for variables delivered by SAP; EXAMPLE the SAP exit variable OCMONTH returns the current calendar MONTH.

SAP Exit is for variables delivered by SAP; example the SAP exit variable OCMONTH returns the current calendar month.

When you enable this option, you can stop the query being refreshed automatically after either selecting filter value or change query or PROPERTIES; this is useful for big QUERIES where you do not want to wait for the SYSTEM to refresh but just ONE time after you make all the changes.

When you enable this option, you can stop the query being refreshed automatically after either selecting filter value or change query or properties; this is useful for big queries where you do not want to wait for the system to refresh but just one time after you make all the changes.

a. empty (nothing).
B. SELECT from list — this shows a list of workbooks and you select one. 
C. from a permanent template — USE a permanent template.

a. empty (nothing).
b. select from list — this shows a list of workbooks and you select one. 
c. from a permanent template — use a permanent template.

You can USE VBA to customize the REPORT; for example assume that you want to hide/delete some header/filter are after each refresh of the QUERY; use the SAP BEX on Refresh MACRO to do this; by default this macro is empty; add excel code to customize the functionality of Bex queries in workbooks; remember that the macro functions are available only on bex and no when you do web reporting using the same query.

You can use VBA to customize the report; for example assume that you want to hide/delete some header/filter are after each refresh of the query; use the SAP BEX on Refresh macro to do this; by default this macro is empty; add excel code to customize the functionality of Bex queries in workbooks; remember that the macro functions are available only on bex and no when you do web reporting using the same query.

a. H — QUERY to be read when you NAVIGATE or expand hierarchy; this mode is RECOMMENDED by SAP.
b. X — Query to Read Data during navigation ; OLAP processor requests data for each navigational status of the query.
c. A — Read all at once — read all data at once; will take LONG if it is a big query; use this if the info provider does not SUPPORT selection or a user exit is active in a query.

a. H — Query to be read when you navigate or expand hierarchy; this mode is recommended by SAP.
b. X — Query to Read Data during navigation ; OLAP processor requests data for each navigational status of the query.
c. A — Read all at once — read all data at once; will take long if it is a big query; use this if the info provider does not support selection or a user exit is active in a query.

RSRT.

RSRT.

INFO object, info cube, info SET, ODS and QUERY.

Info object, info cube, info set, ODS and query.

Either when you execute QUERY (right click and select documents for bex and LEFT click and select DOCUMENT from web reports) or use ADMIN work bench -> documents -> metadata PATH.

Either when you execute query (right click and select documents for bex and left click and select document from web reports) or use admin work bench -> documents -> metadata path.

ASSUME that we WANT to add product images for each product; to do this create master DATA document utility to create a document for each OMATERIAL VALUE;

Assume that we want to add product images for each product; to do this create master data document utility to create a document for each OMATERIAL value;

This is to CREATE one or more documents to the transaction data of an info PROVIDER; for example you can define a document for the following COMBINATION of key figures and characteristics — Sales quantity, material and FISCAL YEAR period.

This is to create one or more documents to the transaction data of an info provider; for example you can define a document for the following combination of key figures and characteristics — Sales quantity, material and fiscal year period.

if you WANT to FILTER on key figures or do ranked analysis then you use condition. For example you can use condition to REPORT top 10 CUSTOMERS or customers with more than a million dollars in sales yearly.

if you want to filter on key figures or do ranked analysis then you use condition. For example you can use condition to report top 10 customers or customers with more than a million dollars in sales yearly.

EITHER you can select single characteristic or combination or all characteristics in the DRILL down; you must remember that condition is effective only when the report is drilled down for all characteristics defined in the condition.

Either you can select single characteristic or combination or all characteristics in the drill down; you must remember that condition is effective only when the report is drilled down for all characteristics defined in the condition.

By DEFAULT the report shows overall results total and not the results total only for the filtered results; to display the right totals you should USE “Summation” in the KEY FIGURE PROPERTIES instead of “Nothing defined”.

By default the report shows overall results total and not the results total only for the filtered results; to display the right totals you should use “Summation” in the key figure properties instead of “Nothing defined”.

a. conditions work (all valid).
b. STATUS is displayed as “Variant” because the CHARACTERISTICS combination is not included in the drill down. 
c. status is displayed as “Not Used” because of colliding conditions where ONE CONDITION deactivates the other.

a. conditions work (all valid).
b. status is displayed as “Variant” because the characteristics combination is not included in the drill down. 
c. status is displayed as “Not Used” because of colliding conditions where one condition deactivates the other.

Exception is not a filter (like CONDITION) but used to HIGHLIGHT reports with different colors for unusual KEY FIGURES; for example you may want to show RED for all accounts receivables that are older than 90 days and yellow for older than 60 days.

Exception is not a filter (like condition) but used to highlight reports with different colors for unusual key figures; for example you may want to show red for all accounts receivables that are older than 90 days and yellow for older than 60 days.

a. send mail — alerts user by email; for example you can send an email saying the sales qty target were missed. 
B. alert monitor entry — view results in the alert monitor; you can also give an URL for the alert monitor. 
c. export — send the data to a work FLOW for follow-up action.
d. RRJ INTERFACE — if an exception happens you can jump to another QUERY for a more detailed data display using the Go To OPTION.

a. send mail — alerts user by email; for example you can send an email saying the sales qty target were missed. 
b. alert monitor entry — view results in the alert monitor; you can also give an URL for the alert monitor. 
c. export — send the data to a work flow for follow-up action.
d. RRJ interface — if an exception happens you can jump to another query for a more detailed data display using the Go To option.

If EXCEPTION is handled by alert monitor then you can go to AWB, REPORTING AGENT, select Exception on the left window; now you can use the Alert ICON; alternatively from bex you can select open -> exceptions.

If exception is handled by alert monitor then you can go to AWB, Reporting agent, select Exception on the left window; now you can use the Alert icon; alternatively from bex you can select open -> exceptions.

You use PRINT settings to print back ground JOBS data using REPORTING AGENT; from reporting agent use the create icon; using this you can specify title. zeros suppression, colors, position, margins, how the info objects will be displayed in the report, etc.

You use print settings to print back ground jobs data using reporting agent; from reporting agent use the create icon; using this you can specify title. zeros suppression, colors, position, margins, how the info objects will be displayed in the report, etc.

Using REPORTING agent you can fill VALUES for a particular characteristic in the background; assume that every day you generate a detailed report on the top 10 PRODUCTS; to get the top 10 products you run another QUERY with condition; so the parent query can be defined as a value set returning values for OMATERIAL.

Using reporting agent you can fill values for a particular characteristic in the background; assume that every day you generate a detailed report on the top 10 products; to get the top 10 products you run another query with condition; so the parent query can be defined as a value set returning values for OMATERIAL.

USE the AWB -> REPORTING agent and select the value SET icon on the LEFT.

Use the AWB -> Reporting agent and select the value set icon on the left.

In this EXAMPLE, CREATE a variable with type valueset for OMATERIAL and use it in the REPORT.

In this example, create a variable with type valueset for OMATERIAL and use it in the report.

Chart, table, dropdown box, RADIO button group, CHECK boxes, generic navigation block, hierarchical context menu, filter, LABEL, text ELEMENTS, list of exceptions, alert monitor, menu, ticker, map, single document, list of documents, etc.

Chart, table, dropdown box, radio button group, check boxes, generic navigation block, hierarchical context menu, filter, label, text elements, list of exceptions, alert monitor, menu, ticker, map, single document, list of documents, etc.

a. open dialog for web APPLICATIONS in new windows.
b. use the READ mode for data flag to use pre-calculated or HTML PAGES. 
c. flag for output OPTIMIZATION .
d. force variables entry.

a. open dialog for web applications in new windows.
b. use the read mode for data flag to use pre-calculated or HTML pages. 
c. flag for output optimization .
d. force variables entry.

Web items LIBRARY is a reusable object repository; for example you can CUSTOMIZE table web item (like SETTING flags and display OPTIONS) and save it in library for other web templates; these flags and settings are repeated again; note that the data provider ASSIGNED to the web item library object is not copied.

Web items library is a reusable object repository; for example you can customize table web item (like setting flags and display options) and save it in library for other web templates; these flags and settings are repeated again; note that the data provider assigned to the web item library object is not copied.

a. M - All VALUES .
b. D — Dimension TABLES; all values from dimension (regardless of the current display); for EXAMPLE if the current report displays only 10 customer data (because of filter) but has 100 customer in the dimension table it will display all 100 customers. 
c. Q — values in the current display — in this case only 10 are displayed.

a. M - All values .
b. D — Dimension tables; all values from dimension (regardless of the current display); for example if the current report displays only 10 customer data (because of filter) but has 100 customer in the dimension table it will display all 100 customers. 
c. Q — values in the current display — in this case only 10 are displayed.

In the MIME repository and store it under SAP -> Public -> SAP BW -> CUSTOMER -> STYLE Sheets.

In the MIME repository and store it under SAP -> Public -> SAP BW -> Customer -> Style Sheets.

SAP -> Public -> SAP BW -> CUSTOMER -> IMAGES.

SAP -> Public -> SAP BW -> Customer -> Images.

a. STORED — use pre-calculated DATA exclusively. 
b. HYBRID — USES pre calculated if available else NEW data.
C. STATIC - uses pre calculated data.

a. STORED — use pre-calculated data exclusively. 
b. HYBRID — uses pre calculated if available else new data.
c. STATIC - uses pre calculated data.

This is like a precalculated value SET; the REPORT is generated as HTML DOCUMENT by Report AGENT; remember that in this case no navigation/drill down is possible.

This is like a precalculated value set; the report is generated as HTML document by Report Agent; remember that in this case no navigation/drill down is possible.

It is a FRAMEWORK for your WEB REPORTING.

It is a framework for your web reporting.

OQUERY_TEMPLATE.

OQUERY_TEMPLATE.

You should not change OQUERY_TEMPLATE; but you should make a copy using program RS_TEMPLATE_MAINTAIN and make the changes (CALL this NEW template like ZTEMPLATE); then go transaction SPRO to define the new Z template as the default web template.

You should not change OQUERY_TEMPLATE; but you should make a copy using program RS_TEMPLATE_MAINTAIN and make the changes (call this new template like ZTEMPLATE); then go transaction SPRO to define the new Z template as the default web template.

Use the tag SAP_B W_TEXT and specify the PROGRAM NAME and KEY.

Use the tag SAP_B W_TEXT and specify the program name and key.

An X will force the web REPORT to display the variables ENTRY screen.

An X will force the web report to display the variables entry screen.

TRANSACTION RSRT2.

Transaction RSRT2.

This is a program that allows the USERS to schedule the downloading of HTML reports from REPORTING agents.

This is a program that allows the users to schedule the downloading of html reports from reporting agents.

a. enhanced scalability, USE of IGS for charts, background processing. 
b. full SAP application SERVER with ABAP run time. 
c. HTTP server and client functionality. 
d. Native support for open PROTOCOLS like HTTPS, SSL, SSO, etc. 
e. No proprietary products (no RFC) .
f. XMIJXSLT engine and integrated J2EE engine .
g. MIME objects are cached now.

a. enhanced scalability, use of IGS for charts, background processing. 
b. full SAP application server with ABAP run time. 
c. HTTP server and client functionality. 
d. Native support for open protocols like HTTPS, SSL, SSO, etc. 
e. No proprietary products (no RFC) .
f. XMIJXSLT engine and integrated J2EE engine .
g. MIME objects are cached now.

RSO2.

RSO2.

SBIW.

SBIW.

a. replicate the data SOURCES.
b. assign to info source. 
C. MAINTAIN communication structure and transfer rules. 
d. create info PACKAGE. 
e. load data.

a. replicate the data sources.
b. assign to info source. 
c. maintain communication structure and transfer rules. 
d. create info package. 
e. load data.

Ascential, INFORMATICA, Mercator, ETC.

Ascential, Informatica, Mercator, etc.

a. define the RFC connection; example define the IP address, etc using SM59.
b. define the third party SOURCE SYSTEM. 
C. assign to info sources. 
d. map and define transformation rules .
e. create info package and LOAD DATA.

a. define the RFC connection; example define the IP address, etc using SM59.
b. define the third party source system. 
c. assign to info sources. 
d. map and define transformation rules .
e. create info package and load data.

CSV, ASCII.

CSV, ASCII.

a. Before IMAGE : before the record got changed; in this CASE it is 20.
B. After image: after the record got changed; in this EXAMPLE it is 10. 
c. Additive image: in this case only the difference; ie -10. 
d. Reverse image — used for deletion; reverse with the qty to NULLIFY. 
e. Delete image — only the ODS keys are given for deletion; not supported for cubes.

a. Before Image : before the record got changed; in this case it is 20.
b. After image: after the record got changed; in this example it is 10. 
c. Additive image: in this case only the difference; ie -10. 
d. Reverse image — used for deletion; reverse with the qty to nullify. 
e. Delete image — only the ODS keys are given for deletion; not supported for cubes.