You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need Help! Building a Dynamic Calc Currency Translation in PBCS BSO

Received Response
57
Views
6
Comments
edited Nov 5, 2019 3:35PM in Planning 6 comments

Summary

I'm trying to build a dynamic calc currency translation member that works on parent members

Content

I'm trying to build a dynamic calc Scenario member to do currency translation on the fly in order to simulate FX-Rate developments without doubling my data (or multiplying, the moment we start looking at several scenarios at the same time). While this is easy for LEV-0 members, I'm stuck at making this work for parents/nodes.

So I've got my Actual Scenario with the Entity Currency member (Currency is a dense dimension) which is the basis for my calculation. Theoretically, when I use this member in connection with a node (let's say "Group" -> approx. 40 LEV-0 members), it would have to collect, translate and sum up all LEV-0 members the selected POV. Performance aside, is that something that anybody can make work? Also, are there other/better approaches to FX-Rate simulation scenarios?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!