Script logic BPC 10 MS

[Former Member]

hello,

In the attached logic - Acct1 & DEPT1 are calculated members and the get statement  is not returning  any records..Anything wrong with that statement?

I ran the logic by selecting one time period and one category...

Thanks In Advance

[cecilia_petersson2 · Accepted solution]

Hi Meghana,

Syntax wise the statement looks fine, but I suspect All_Data_Sources is a parent and that won't work. Try creating a variable: *SELECT (%ALL_DATA_SRC%, "ID", "DATATSRC", "CALC"='N'") to get all base members. Then use %ALL_DATA_SRC% in your GET statement.

/Cecilia

[Former Member · Accepted solution]

can we not use "parent/calculate" member in GET statement?

I also tried  with  "Select(%DS%....)...." and using %DS% in GET .still didn't work.

GET works only  with basemebers

[Former Member · Accepted solution]

Hi Meghana,

together with the *SELECT use a *FOR/*NEXT

i.e.

*SELECT (%ALL_DATA_SRC%, "ID", "DATATSRC", "CALC"='N'")

*FOR %DATA_SRC1%=%ALL_DATA_SRC%

...

*REC(FACTOR=GET(... , DATASRC=%DATA_SRC1%, ...) ...

...

*NEXT

Regards

     Roberto

[Former Member]

Hi Meghana,

this piece of logic seems ok, what happens? Did you receive an error? check in the logs if any.

Verify also that there are values in your GET scope, (i.e with currency USD,entity LE1, etc)

Regards

     Roberto

[Former Member]

hi Roberto,

I have data at those intersections but the get statement is not  returning data.

I am thinking bcos of the parent members in the GET...

thanks