Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
PBCS - Rule with variable in Calculation Manager

I have created this rule:
FIX (@Relative("SEVE_PARTIDAS", 0))
DATACOPY "Actual"->"FY15" to "Forecast"->"FY16";
ENDFIX
With this rule, I copy in the account members (SEVE_PARTIDAS) the data, from Actual (Scenario member) of FY15 (Year member) to Forecast (Scenario member) of FY16 (Year member).
Now, I want to add a {Percent} variable. Then, this value will use to calculate the amount. For example, the amount of "Forecast FY16" is the result of: {Percent} variable * (Amount "Actual FY15).
What instruction need to include in the rule above with {Percent} variable?
Thanks a lot.
Best Answer
-
This formula, I think that to serve me:
FIX (@Relative("SEVE_PARTIDAS", 0))
FIX("FY16")
"Forecast" = "Actual"->"FY15" * {Percent};
ENDFIX
ENDFIX
Answers
-
Hi
How about you try something and if it doesn't work we'll help you figure it out?
-
In the previous formula, I added the variable directly:
FIX (@Relative("SEVE_PARTIDAS", 0))
DATACOPY ("Actual"->"FY15"{Percent}) to ("Forecast"->"FY16"*);
ENDFIX
-
DATACOPY is a pretty self explanatory command, it copies data. Please read the documentation for the commands you use first.
If you want to perform a multiplication you'll have to write an equation. Though if Year is sparse you'll want to keep the DATACOPY command to create blocks.
If "sparse" and "blocks" are not concepts you're familiar with, please refer to: Understanding Multidimensional Databases
-
I thougt that "datacopy" allowed to copy data and to include formulas.
I review the documentation that refer you.
Thanks.
-
This formula, I think that to serve me:
FIX (@Relative("SEVE_PARTIDAS", 0))
FIX("FY16")
"Forecast" = "Actual"->"FY15" * {Percent};
ENDFIX
ENDFIX
-
That's much better yes