Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PBCS - DATAEXPORT - Ignore Shared Members Possible?

3921866Apr 26 2019 — edited Apr 30 2019

Hi,

I'm referencing this: Cameron's Blog For Essbase Hackers: Stupid Programming Tricks #15 -- @SHARE the pain with FIX

My calc looks like below. I'm basically trying to do a zero level export for backup purposes but ignore 'Shared Members'. All the dims in the EXCLUDE statements contain shared members. Not sure if possible or not. If I get rid of the EXCLUDE lines then what gets exported is only the shared members as they are last in that outline. I don't want to tag every shared member with a UDA either. Is this possible to nest the EXCLUDE maybe?

FIX( "FY17" , "Local" , "USD" "BegBalance" , "Jan":"Dec")

FIX (@Relative("Account", 0) ,

@Relative("Category", 0) ,

@Relative("Customer", 0) ,

@Relative("Data Source", 0) ,

@Relative("Entity", 0) ,

@Relative("Product", 0) ,

@Relative("Scenario", 0) )

EXCLUDE(@Share(@Relative("Account", 0)))

EXCLUDE(@Share(@Relative("Category", 0)))

EXCLUDE(@Share(@Relative("Customer", 0)))

EXCLUDE(@Share(@Relative("Data Source", 0)))

EXCLUDE(@Share(@Relative("Entity", 0)))

EXCLUDE(@Share(@Relative("Product", 0)))

EXCLUDE(@Share(@Relative("Scenario", 0)))

DATAEXPORT "File" "," "/u03/lcm/FY17_Export-3.txt" "";

ENDEXCLUDE

ENDFIX

Added on Apr 26 2019

#business-intelligence-applications, #pbcs, #performance-management-applications, #planning-and-budgeting

5 comments

877 views