How to write the start routine in BI 7

[Former Member]

Hi experts,

I am facing problem with the follwing, please help me as it is urgent and points will be assigned.

I am working on BI 7, I had two extractors from R/3 0FI_GL_4 and 0FI_GL_6. Extracted data to BI system, In BI system created two DSO namely 0FIGL_O02 and ZFI_GL_6. so I had moved the data from 0FI_GL_4 to 0FIGL_O02 ( P&L accounts) and from 0FI_GL_6 to ZFI_GL_6 ( Balance sheet accounts).

So here what we did is that we had created created one more DSO ZFI_GL_7, in this DSO we had loaded the both the DSO data of 0FIGL_O02 and ZFI_GL_6.

so here comes the problem.

Balance sheet accounts would not have Cost Centre values and in turn P & L accounts would have Cost Centre data. this is true.

But i am not able to look the costcentre data for all the GL accountsin the DSO ZFI_GL_7, only some few GL accounts have the data some does not have.

In this regard please help me. and it is very much urget.

For your kind information , one more info is there please note.

Whatever the data is coming to DSO ZFI_GL_7 is copied into the another DSO ZFI_GL_8 ( HYPERION DATA LOAD) , FOR THIS WE HAD WRITTEN THE ABAP PROGRAM also.

So can anyone help.

Hi ABAP experts,

Please find the above information,

Since I had to write the ABAP program in 0FIGL_O02 in Transformations, the program is already there, but the delete statement shows like this.

"DELETE SOURCE_PACKAGE where BAL_FLAG = 'X'."

In this case I want to allow the GL accounts data with cost centre data, so that I want to see for all GL accounts the cost center data will be populated. so Please help me what is the process to write the code.

At the same time I want to write the ABAP code at ZFI_GL_6 to restrict the GL accounts, since this accounts are already present in the DSO, so that we cannot get the duplicate data in the ZFI_GL_7 DSO.

So what I had did is that I had created database table in BDV system using SE11, So here I had created G/L account and costcenter fields using the BSEG table . I had add all the entries for G/L accounts and activated.

Now I have to write the ABAP code in the transformations of 0FIGL_O02 to allow the G/L accounts with the cost center data.

Please help me how to write the ABAP code

So Please help me in this regard.

Thanks

Sekhar

[p291102]

Hi,

The link below is a PDF for SAP-BW.

Check out this. it shud help u.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/505351fe-ec8c-2910-c5b5-a43bbf53...

in the start routine you have the complete data package in an internal table and you can do lots of derivations at once. In the field routine you have only one single row each time the routine gets processed and you can only derive the value of that single field.

The decision is pretty much depending on the fields of your communication structure (data package). If everything you need is there, it is best to use a start routine.

Check this link for more details.

Routines are like conditions or business rules that could be applied to filter the data while entering the BW system or could be used to apply certain conditions on the info objects itself.

There are 4 types of routines

1. Start routine- Could be used at two levels (transfer rule level and the Update rule level)

This Start routine written at the transfer rule level helps filter the necessary data coming from the source system.

For Example: If you decide to extract data that contain only quantity greater than 500 , then you could specify the Start rouitne to achieve this.

The Start routine at the Update rule level provides similar functionality but at this point it helps direct specific data to

different data targets. For Example: If there 3 data targets being fed from the Infosource, you may want to apply some condition to each data target, like send year 2000 data ti Data target1, 2001 to data target 2 and so on. This can be achieved by using Start routine at the Update rule level

2. Transfer Routine: This feature is available at the transfer rule levels

While performing the transfer rules operation, there are 4 features available to the developers to create business rules on top pf the Infoobjects.

1. You could do a one to one mappping of the Infoobject

2. Provide a constant value

3. Include a formula

4. Write an ABAp routine.

These 4 options refers to the transfer routine

3. Update Routine:

The limitations of just having 4 options in the transfer routine is overcome at the update rule level. There are various other

sophisticated features avaialable apart from the 4 options mentioned above. These business rules could be specified pertaining to each data target.

4. Conversion Routine: It provides functionality to do Currency and unit conversion.

Check this link

http://bluestonestep.com/component/option,com_docman/task,doc_download/gid,13/.

www.sap-hefte.de/download/dateien/1127/098_leseprobe.pdf

Thanks,

Sankar M