ASO GROOVY Script to export data to a file for a specific scenario excluding the shared members
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]}))"