Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to create a cost accounting report as a pivot table with a rigid structure. That means it has to have the same number of rows for every combination of clickable Dimensions, even if there's no value. In addition to that the cells with no values should show 0 (zero). Reason for that is the controllers want to use the downloaded report to process them e.g. in excel with macros.
I fixed this problem by creating zero-values for every combination of dimensions using an outer join, but that blows up data extremely, increases file size and reduces performance. The original fact table contains several millions of entries with a lot of dimensions...
Anyone with an idea?
Mario
P.S.: I tried checking and unchecking the supress NullValues and show all boxes in the different chart tabs, but that didn't work properly.
Is there nobody to help me..?
I removed the script where you added 0 value and it seems to be working for me. What exactly isn't working for you? Would you be able to show it via images?
Hi Sunny,
thank you for your answer.
Sorry, i forgot something very important. I'd like to create a pivot table with a cyclic group of dimensions. I changed the app. Please watch it with and without the generic 0 values.
Greetings
Mario
I decreased the amount of records just loading 0 values for the combination of dimensions and accounts where is not existing any value, but that is still too much...
So basically regardless of which dimension you are looking at (Dim1 or Dim2), you would want to see same number of columns?
No, the columns should be shown just for the selected dimensions with values.
no chance to solve my problem?