Refer below link for steps to create custom hierarchy data source and to enhance hierarchy data source to modify the structure http://scn.sap.com/docs..
By using the below tables , you can get list of all queries used in BI 7 WAD. Tables RSZWBTMPXREF RSZWBTMPHEAD RSZWBTMPHEADTXT RSZCOMPDIR RSZCOMPIC RSZELTTXT Join Conditions RSZWBTMPXREF OBJNM = RSZCOMPDIR COMPUID RSZWBTMPXREF OBJVERS = RSZCOMPDIR OBJVERS RSZWBTMPXREF OBJID = RSZWBTMPHEAD OBJID RSZWBTMPXREF OBJVERS = RSZWBTMPHEAD OBJVERS RSZWBTMPHEAD OBJID = RSZWBTMPHEADTXT OBJID RSZWBTMPHEAD OBJVERS ..
There are scenarios you might want to create an user input variable for key figures in BEx instead of traditional variables for characteristics.Below are simple steps to achieve it. 1) Open BEx query designer and open the required or create new query. 2) Drag & Drop the key figure you would like to create a ..