Oracle Analytics and AI

Vijaykumar Yes

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

Prakash Malmarugan-71506

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