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

Pivot in Data Management Export to File

Accepted answer
edited Apr 19, 2020 4:13AM in Planning 7 comments


Pivot in DM to File is only creating a single column - only the first member is pivoted.


G'day Guys, 

I'm trying to setup a PBCS data export using data management. 

I've got everything working, but now I'm trying to pivot a dimension across the columns. 

Tried a number of different things, but as soon as I do - only the first member is selected rather than all the members in the dimension so I only end up with a single column 

Attempting to pivot Scenario across columns, I update the filter to:
"Actual","PlanFY20","Forecast1" And make the pivot dimension Scenario. 


Howdy, Stranger!

Log In

To view full details, sign in.


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