on 07-06-2010 10:33 PM
Is there a way to use one dimension to push data into two other dimensions using push logic? The client has one dimension in App1 that is a combination of 2 dimensions in App2 ie the Costcenter dimension in App1 is a combination of Plant and Account in App2.
Now they want to push data from App1 into App2 using the Costcenter dimension to populate the Plant and Account.
I have Plant and Acct properties in the Costcenter dimension for mapping.
I tried to use *Rename_dim CC= CC.Plant and *Rename_dim CC=CC.Acct but would get errors when validating the logic script.
Any help would be greatly appreciated.
Yes you are right.
I understood your problem now,
Actually you need Rename twice.
What was the error message received when you tried to validate the logic?
Regards
Sorin Radulescu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Parameters
COSTCENTER: 70101014
When I test the logic using the logic debugger, I get the error:
Validate member failed:
70101014
70101014
70101014
70101014 on COSTCENTER dimension
When I run the logic thru data manager, the package is successful but the end of the detail status log is 'No records to process'
The push logic should ideally take the Costcenter 70101014 from App1 and take the first 4 char (7010) and record to the Plant dimension in App2 then take the last 4 char (1014) and record to the Account dimension in App2
Logic script:
*DESTINATION_APP= APP2
*RENAME_DIM CC = ACCOUNT
*RENAME_DIM CC= PLANT
*WHEN CATEGORY
*IS "AOP"
*REC(CC=CC.RPT_A,CC=CC.PLANT,CATEGORY=AOP)
*ENDWHEN
*COMMIT
The problem is the fact that you are using Rename.
You can use Rename for one dimension but for the other one you have to use ADD not one more time rename.
Regards
Sorin Radulescu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Assuming that each CC member in App1 corresponds to single specific Plant-Account intersection I'd suggest using CC dimension properties PLANT and ACCOUNT.
The you could use *REC instruction with %CC%.PLANT and %CC%.ACCOUNT parameters to populate that particular interserction using the value of current CC member.
Hope this helps,
Madis
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.