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