Skip to Content
0
Former Member
Apr 15, 2010 at 05:41 PM

Script Logic in BPC is not working properly

137 Views

Hi All,

I have the BPC Microsoft version 7.0.114. I am trying to create a script logic to calculate price x units.

I have an application called GYP with the following dimensions:

PL (Account type) in this dimension are the units

Time

Category

Entity

Product

RptCurrency

I have another application called PRICE with the following dimensions:

Price (Account type) in this dimension are the prices

Time

Category

Entity

Product

RptCurrency

The script logic i created in the GYP application is as follows:

*XDIM_MEMBERSET PL="Units"

*XDIM_MEMBERSET PRODUCT=<ALL>

*XDIM_MEMBERSET ENTITY=<ALL>

*XDIM_MEMBERSET CATEGORY="Budget"

*LOOKUP PRICE

*DIM PR:PRICE ="PRICES"

*ENDLOOKUP

*WHEN PL

*IS "Units"

*REC(FACTOR=LOOKUP(PR), PL="Revenues")

*ENDWHEN

*COMMIT

I also put in the default.lgf :

*INCLUDE UnitsxPrice.LGF

*COMMIT

I have loaded data for units and price only for one product to validate the script logic but I'm not getting any calculated value in the revenues element.

I have read a lot of documentation about script logic but i haven't found which could be the problem.

Please, could you help me to know what i am missing to?

Thanks in advance for all your help.

Regards,

Luisana