Forum Stats

  • 3,874,838 Users
  • 2,266,780 Discussions
  • 7,911,975 Comments

Discussions

PBCS data management export form ASO

Planning Data Management export data from ASO

When extracting data from ASO cube to data target file and Pivot dimension set to Period.  We ALWAYS want the output to include 12 periods even if there is only #Missing for a particular period.  The output we are getting now is dropping periods with #Missing, I believe because the MDX query says NON EMPTY.  Is there a way to hold the column output of periods columns constant?

We would also like to replace #Mi with 0 in the output, is this possible?

Thanks in advance

John