Would anyone have a process defined for "How" to load Actual data into a model. I get that I need an Actual data file with tuple detail. And then I load the data into a Module, likely that has base members to load values. BUT my issue is then, how do I get that data into other Modules, when I cannot run a test against the Version in an IF statement? For example, I have a Gross Margin Statement, which has product revenue. In the FCST process we have products value by volume estimates...thus building the Revenue as we need for a forecast. Now I have Revenue data from accounts in my GL that get loaded into a table described above, in a seperate Module. I now need to marry the two parts together, so that ACTUAL values come from a book of record, versus a calculation. I prefer not to attempt to emmulate the Revenue from Actuals using the calculation, but see that we could enter in a value of 1 for price and the revenue for volume. But then if we have various sales currencies, this isn't a good option. How does an actual GL account get connected to another account (or line item) which is a calculated member in a forecast? I have tried several different scenarios, but don't see a simple direct path to the solution. What is the best advice from the design teams? Thanks. Petar
Solved! Go to Solution.
But based on my current design, the LC values from Actual will not convert to the various report currencies.