on 2020 Feb 04 3:19 PM
Dear all,
We are making an BPC upgrade 7.5 Standard to 10.1 NT.
Currency dimension in 7.5 is divided in two, Currency and Scope with the different group of consolidation. So I created SCOPE dimension in the newer version with G_NONE for the group that are not consolidated and the different consolidation groups.
I'll give you the step I made for it:
1. Productive environment copy
2. Backup of the Consolidation model to have the historical data without changes.
3. Create the new dimension SCOPE assigning the parameters and change the currency dimension just with the LC and EUR
4. We Transformed the data in BW assigning the proper data in each dimension with the appropiate changes in the routines.
OLDER CUBE NEWEST CUBE
DIMENSION --> CURRENCY TO CURRENCY
DIMENSION --> CURRENCY TO SCOPE
5. Assigning the new dimension to the CONSOLIDATION and OWNERSHIP models.
When we tried to run the different package to start the consolidation, the following error appeared
RUNC LOGIC: Dimension Set “SCOPE” is not assigned in Data Manager. (CONSOLIDATION MODEL)
RUN LOGIC: Dimension assigned of definition not valid in *DESTINATION_APP: CONSOLIDATION (BUDGET CONSOLIDATION)
We tried to change the logic, but nothing happened. It seems that the new dimension is not recognize someone who has made this kind of upgrade has had this problems? Could you please help us?
Request clarification before answering.
Hello Vadim,
I attached you the information below. I hope it helps.
Thank you for your time.
transformation-bw.png tranform-bw.png routine.png
That what I meant. We changed the routine depends on the data. For example:
CASE SOURCE_FIELDS-/**/*_****
WHEN 'LC'. RESULT = 'G_NONE'.
WHEN 'EUR'. RESULT = 'G_CONSO'.
WHEN OTHERS. RESULT = 'G_CONSO1'.
ENDCASE.
Thank you
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 17 | |
| 8 | |
| 7 | |
| 6 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.