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...
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?
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.
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...
