USD Logic Issue BPC V7

[Former Member]

Greeting BPC Users,

We are having an issue with some script logic that has been migrated from an Outlooksoft V4.2 install to BPC V7. The logic is calculating CTA (Cumulative Translation Adjustment). It basically needs to determine the out of balance amount in the balance sheet in USD and write to an account called CTA for USD only. IT has worked fine for years in the old system.

The problem we are having is that BPC V7 now seems to have some additional validation when it builds the query that checks if the member you are writing to is calculated. Since USD is automatically set as a calculated member in the dimension, our logic will not generate any results. The logic debugger gives us a message that there is no base member in the selected members of the dimension. Does any one have any ideas how to get around this issue?

Regards

John G.

[Former Member]

What scripting syntax are you using for the calculation? SQL script logic, or the business rules tables and SPRunConvert (which back in 4.2 were called zoom tables)?

If you're not using SPRunConvert, you should at least take a look at that syntax, and consider moving your logic over. It may allow you to throw out a lot of code and use a simpler, easier-to-maintain logic style.

Either way, your problem with USD is most likely related to a currency dimension property that you need to change. (You may even need to add a new property or two, to this dimension.) What to change it to depends on which way you're calculating CTA. Compare the property setup of LC and USD members, and it may help if you post that information here to SDN. You may also want to post your CTA logic here.

Also, are you using an accdetail / movement / flow type dimension in your applcation?