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

ASO GROOVY Script to export data to a file for a specific scenario excluding the shared members

edited Jun 10, 2024 7:22AM in Planning 6 comments

Summary:

Hi All,

Im trying to write a calc manager groovy script to export the data out of ASO reporting cube for specific scenario to a file which excludes the shared members. How can i pass the
EXPORT INTO FILE "test.txt" OVERWRITE USING COLUMNDELIMITER "," to the below and pass the output on the file. Any idea or a better method , pls suggest

/* RTPS: {RTP_Scr}{RTP_Ver}
CustomCalcParameters calcParameters = new CustomCalcParameters()
calcParameters.Pov = "nonemptysubset(Crossjoin(Crossjoin(Crossjoin(Crossjoin(Crossjoin(Crossjoin(Crossjoin({FILTER (Descendants([Account], [Account].dimension.Levels(0)), ([Account].CurrentMember.MEMBER_TYPE <> 2) AND NOT [Account].CurrentMember.SHARED_FLAG)},{FILTER (Descendants([Entity], [Entity].dimension.Levels(0)), ([Entity].CurrentMember.MEMBER_TYPE <> 2) AND NOT [Entity].CurrentMember.SHARED_FLAG)}),{FILTER (Descendants([Currency], [Currency].dimension.Levels(0)), ([Currency].CurrentMember.MEMBER_TYPE <> 2) AND NOT [Currency].CurrentMember.SHARED_FLAG)}),{FILTER (Descendants([CC], [CC].dimension.Levels(0)), ([CC].CurrentMember.MEMBER_TYPE <> 2) AND NOT [CC].CurrentMember.SHARED_FLAG)}),{FILTER (Descendants([Period], [Period].dimension.Levels(0)), ([Period].CurrentMember.MEMBER_TYPE <> 2) AND NOT [Period].CurrentMember.SHARED_FLAG)}),{FILTER (Descendants([Plan Element], [Plan Element].dimension.Levels(0)), ([Plan Element].CurrentMember.MEMBER_TYPE <> 2) AND NOT [Plan Element].CurrentMember.SHARED_FLAG)}),{FILTER (Descendants([PRD], [PRD].dimension.Levels(0)), ([PRD].CurrentMember.MEMBER_TYPE <> 2) AND NOT [PRD].CurrentMember.SHARED_FLAG)}),{[&CURRRange]}))"

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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