Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Accounts copy to corresponding drivers

Summary
data copy to corresponding accounts
Content
Hello All
I have a requirement where data need to copied between accounts which in the selected node
example :
A1 (Accounts)
---A111
---A112
---A113
---A11_Modeling
---A11_Remainder
---A12_Modeling
---A12_Remainder
---A13_Modeling
---A14_Modeling
now data need to copy from Remainder to Corresponding Modeling accounts, but A13_Modeling and A14_Modeling don't have
corresponding Remainder accounts in this case data remain same Modeling Accounts
I have a script but it does not run when there is no corresponding Modeling and Remainder accounts
Fix(@Match(A1,"??_Modeling"))
@MEMBER(@CONCATENATE(@SUBSTRING(@NAME(@CURRMBR(A1)),0,3),_REMAINDER));
ENDFIX
Answers
-
Hi Vijaykumar,
One of the ways to achieve this is by putting an attribute dimension or attach an UDA to the corresponding members in the Account dimension which will be explicitly used the calculation scripts to exclude the members that doesn't have a specific attribute or UDA.
Prakash M
0