Business Warehouse SAP Interview

Business Warehouse SAP Interview

1.  How to convert a BeX query Global structure to local structure  (Steps involved)?


To convert a BeX query Global structure to local structureSteps:
A local structure when you want to add structure elements that are unique to the specific query. Changing the global structure changes the structure for all the queries that use the global structure. That is reason you go for a local structure.

Coming to the navigation part--

In the BEx Analyzer, from the SAP Business Explorer toolbar, choose the open query icon (icon tht looks like a folder) On the SAP BEx Open dialog box: Choose Queries. Select the desired InfoCube Choose New. On the Define the query screen: In the left frame, expand the Structure node. Drag and drop the desired structure into either the Rows or Columns frame. Select the global structure. Right-click and choose Remove reference. A local structure is created.

Remember that you cannot revert back the changes made to global structure in this regard. You will have to delete the local structure and then drag n drop global structure into query definition.

When you try to save a global structure, a dialogue box prompts you to comfirm changes to all queries. that is how you identify a global structure.

2.I have RKF & CKF in a query, if report is giving error which one should be checked first RKF or CKF and why (This is asked in one of int).

RKF consists of a key figure restricted with certain charecteristics combinations CKF have calculations which fully uses various key figures

They are not interdependent on each other . You can have both at same time

To my knowledge there is no documented limit on the number of RKF's and CKF's. But the only concern would be the performance. Restructed and Calculated Key Figures would not be an issue. However the No of Key figures that you can have in a Cube is limited to around 248.

Restricted Key Figures restrict the Keyfigure values based on a Characteristic.(Remember it wont restrict the query but only KF Values)

Ex: You can restrict the values based on particular month

Now I create a RKFlike this:(ZRKF)
Restrict with a funds KF
with period variable entered by the user.

This is defined globally and can be used in any of the queries on that infoprovider. In columns: Lets assume 3 company codes are there. In new selection, i drag

ZRKF
Company Code1

Similarly I do for other company codes.

Which means I have created a RKF once and using it in different ways in different columns(restricting with other chars too)

In the properties I give the relevant currency to be comverted which will display after converting the value to target currency from native currency.

Similarly for other two columns with remaining company codes.

3.  What is the use of Define cell in BeX & where it is useful?

Cell  in BEX:::Use

When you define selection criteria and formulas for structural components and there are two structural components of a query, generic cell definitions are created at the intersection of the structural components that determine the values to be presented in the cell.

Cell-specific definitions allow you to define explicit formulas, along with implicit cell definition, and selection conditions for cells and in this way, to override implicitly created cell values. This function allows you to design much more detailed queries.

In addition, you can define cells that have no direct relationship to the structural components. These cells are not displayed and serve as containers for help selections or help formulas.

You need two structures to enable cell editor in bex. In every query you have one structure for key figures, then you have to do another structure with selections or formulas inside.

Then having two structures, the cross among them results in a fix reporting area of n rows * m columns. The cross of any row with any column can be defined as formula in cell editor.

This is useful when you want to any cell had a diferent behaviour that the general one described in your query defininion.

For example imagine you have the following where % is a formula kfB/KfA * 100.

kfA kfB %
chA 6 4 66%
chB 10 2 20%
chC 8 4 50%

Then you want that % for row chC was the sum of % for chA and % chB. Then in cell editor you are enable to write a formula specifically for that cell as sum of the two cell before. chC/% = chA/% + chB/% then:

kfA kfB %
chA 6 4 66%
chB 10 2 20%
chC 8 4 86%