on ‎2020 Jul 23 5:21 PM
Hello
I created a new (2nd) Time dimension called TimeFY (fiscal year hierarchy). Created a new model ConsolFY which uses new TimeFY dim while all other dimensions are existing (shared with original Consol model). Below are details.
New 2nd Time dimension

Created simple Rules Table, Logic and Data Manager package below:
Rule

Logic
If I change line 8 to: TIMEFY = %TIMEFY_SET% package runs successfully but results are incorrect. Logic is run for months not selected in Data Manager Package prompt - basically selected TimeFY member is not being read into logic script.
Data Manager
Constants show %TIME_DIM% = TIMEFY
Failed package - Selection shows a valid TimeFY member selected
Request clarification before answering.
Attached is TIMEFY memebers for 1 year +
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Look on the syntax of CALC_ACCOUNT in help:
Has to be:
TID_RA = %TIMEFY_SET%P.S. And remove useless COMMIT!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 34 | |
| 6 | |
| 4 | |
| 4 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.