Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Accounts copy to corresponding drivers — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Accounts copy to corresponding drivers

Received Response
7
Views
1
Comments
edited Sep 11, 2019 5:18AM in Oracle Analytics 1 comment

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))

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!