Oracle Analytics Cloud and Server

Products Banner

Accounts copy to corresponding drivers

Received Response
11
Views
1
Comments

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