How to create variable with exist : (no more cmod t-code but BAPI)

BW Naming Conventions

How to create BEx Variant based on Security Authorization

How to compare Queries between 2 systems

On both systems, run transaction SE38
Launch program "RSRQ_QUERYDEFINITION"
Run the program for the Query you want to analyse.

TECHNO - BI TEAM > Attachment Library > QueryComp1.png

Click on the "Download" button. Then OK.
Go to "System" -> List -> Save --> Local File

TECHNO - BI TEAM > Attachment Library > Querycomp2.png

Export to the "Clipboard"
Open a txt file and paste the content.
Use a code comparison tool to compare both files. Exemple : http//www.tareeinternet.com/scripts/comparison-tool/

How to find queries using an info object

You can use the following function modules in order to display the queries using an info object.

Function modules

RSZ_I_BASIC_CHA_WHERE_USED

RSZ_I_BASIC_KEYFIG_WHERE_USED

It’s much more efficient than using the metadata repository.
Example for info object 0GL_ACCOUNT__C_GL_TYPE. With metadata repository I list around 40 queries with this object.
The reality is much more different because with the function module I obtain 96 queries!

TECHNO - BI TEAM > Attachment Library > Function module.jpg

There are also some tables to list the info provider using the nav attributes

RSDODSOATRNAV – For DSO

RSDCUBEIOBJ – For Cubes and MPR

TECHNO - BI TEAM > Attachment Library > Table.jpg

In this page, there is a list of very useful tables

http//wiki.scn.sap.com/wiki/display/BI/Important+Tables+in+SAP+BW+7.x