Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Logic in Conversion File

Dear Experts,

We  have a requirement where we need to extract actual data from BW to BPC for GL 5020520001, but in BPC we have static GLs under this GL 5020520001 , say GL1001 and GL1002. That means GL1001 and GL1002 is under GL 5020520001, so I cannot pull data for 5020520001 since it is not basemember.

Now while extracting actual data , only for this single GL, I want to map this GL in conversion file to these static GLs depending upon certain criteria on profit center ( other dimension)  , i.e. in converion :

External              Internal             Formula

5020520001       GL1001       if Profit center is TA01

5020520001       GL1002       if Profit center is KU01

I have heard of javascript, but never implemented. Can we apply such logic in conversion file

Or do we have any alternate solution to pull data in such criteria.

I could have mapped Profit center to GL in transformations, and according could have mapped  the same in conversions also , but the thing is I want to apply logic to GL series also in order to eliminate a series of GLs.

So my second query is can we apply two conversions for a single dimension, and if so please explain.

Your inputs will appreciated!!

Thanks in advance!!

Former Member
Not what you were looking for? View more on this topic or Ask a question