MS BPC Script Logic

[former_member539521]

Hi,

We are editing a script that currently works that reads from a temp account and then writes by multiplying that account by a property stored in a dimension. For some reason when I try to pull in that property now we get a package error that says "Error in ProcessSQL: Input string was not in a correct format. The script will properly write to the tmp account but when I put in the REC statement:

*REC(FACTOR=FLD(Weeks.PGW_ACCR_days_TBD), Accountst="DLRS_ACCRUED")

it gives me that error. Any ideas? Thanks, Tracey

[JohnL]

Hi Tracey,

Can you check the property "PGW_ACCR_days_TBD" has correct values?

When copying code you can use the "code" button:

Like this ... 

[former_member539521]

Hi John,

Interesting I checked the values and they have always been stored numbers in the weeks dimension and currently work with other scripts. The off-weeks of a pay-cycle were blank. So just to test out I put numeric values in all weeks (saves as text)...even put zeros for blanks. I then ran the script and it worked-it read the property. I just don't understand if they were working for other scripts why would I have to change them? Also, after I process the dimension, it saves everything as a text value anyway. I'm glad it wrote but I don't understand why this changed and if it would impact other things? I didn't even change this part of the script.

Thanks a lot, Tracey

*REC(FACTOR=FLD(Weeks.PG1_Accr_Days_TBD),ACCOUNTST="DLRS_ACCRUED")

[cecilia_petersson2]

Could you post the full script please. Also, which version are you on?

/Cecilia

[former_member539521]

Hi, actually I just tried to edit my question and those are commas when I tried to copy/paste...not sure why they show as periods. Thanks

[former_member539521]

Hi, thanks, that was just a typo in my question...I just checked and the script has a comma there...any other ideas? thank you, Tracey

[cecilia_petersson2]

Hi Tracey,

You have a dot (.) rather than a comma (,) between "_TBD)" and "Accountst".

/Cecilia