World of SAP BI/BO

Requirement
Our requirement was , we were having one Ztable in Ecc and from Ecc we were fetching all the data upto standard dso in BI , and from some other source we are having data up to cube .In our flow we were having 4 ds including the above Ztable.
All flow were independent.Like DS-WOP DSO-Std.DSO-CUBE , on top of all 3 cube we were having one Multiprovider, and we were having our query , but even though Ztable flow was there in that flow but we dnt add the dso of Ztable flow in our Multiprovider.all the above flow were having profit center and Company code as key field , based on company code user was expecting all the Key figures from the Ztable but their intention was those KF IOs sd not be there in query .In that table around 20 KFS were there (User was not bother about the performance, also ).Company code was Mandatory and Single value in our selection, also currency was constant that is USD.
To achive this what I did , I have created one data source for that Ztable and loaded data upto standard DSO.
den Have created 20 formula variable processing type user exit .
and was achived the requirement .the sample code for one formula variable as follow .

Requirement:
We have developed this program to down load all the info objects fields and rule types into Excel sheet to compare the objects between two server, our aim was everything sd be sync between both the server.
This program will be helpful in many area.
The program follows below.

*&---------------------------------------------------------------------*
*& Report ZY_DATA_DOWNLOAD_TRANS
*& Author:Madhusmita Jena
*& Date:17/05/2011
REPORT ZY_DATA_DOWNLOAD_TRANS.
*tables:RSTRANFIELD,
* RSTRANRULE.

To check whether the query is already migrated to BI .By the field VERSION in table RSZCOMPDIR table we can identify .
go to the table RSZCOMPDIR , there go to field COMPID , give your query name and execute .
if in version field if value is <100
the query is a 3.X query. If it is more than 100 query has been migrated to 7.X version.