Skip to Content

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

Allocation Script Logic

Hi Guys,

I am trying to find a work around.

I copied the DRIVER data to the same BPC cube with a data source called like DRIVER DS.

I am using the standard allocation script logic.

So the WHAT vertical is the data set selection for the sender data right ?

The WHERE vertical is the data set selection for the target and USING is the percentage calculation .

If I have few dimension member values different between the SOURCE and the DRIVER data. if I ignore the dimensions in the allocation script it is not reading the READ driver data set.

For example Dim1 = V1 in the source and in the driver data Dim1 = V2. I want to ignore the Dim1 in the driver and select the driver data comparing other dimensions. But still it is comparing with the source and it is not selecting the DRIVER data. if I have the same members for example Dim1= V1 in both source and DRIVER(Reference data) then it selects the intersection .How to avoid this in script logic. Like don't check that dimension values in the DRIVER data and select only like 4 out 7 dimensions.

I tried to use

*RUNALLOCATION

     *FACTOR=USING/TOTAL

* The below code is only to ignore the dimensions - just copy the source to target

     *DIM D1          WHAT=%D1%;     WHERE=<<<

     *DIM D2          WHAT=%D2%;     WHERE=<<<

     *DIM D3          WHAT=%D3%;     WHERE=<<<

//PLUS ALL THE DIMESNIONS LIKE WHAT SENDER ..WHERE MULTIPLE TARGET MEMBERS ..USING..ETC

*ENDALLOCATION

But if I want to copy the same source value to the target it is not reading the DRIVER data . If the dimension values D1,D2 and D3 are same between source and driver then DRIVER data is READ.Do you know know how to achieve this ?

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