These dimension columns. Are they filled with text or IDs pointing to dimension tabels?
I would load them into QlikView and look at the memory info, but from a sheer amount of rows I would think that if you change it to vertical and these columns are filled with dimension info that would take more memory storage space.
Check out Qlik Document Analyzer.
Thanks for your response.
I tested with the vertical and it nearly double the size of storage (i have nearly 50 measures), it's not good at all.
If i keep using TYPE 1 to store the data, how can i create drill down dimension, e.g. a pie chart that show total A , B -> when i click in A, it shows A1 and A2...
I just think about create a dimension hierarchy in text file and maybe using pick, match to get the corresponding expression.
Replace the dimension columns with ID's pointing to tables and that should take down the storage needed to store this significantly seeing as you replace text with numbers and store much less information in the fact table.
This is for the table that is vertical.
You can create ID's using AutoNumber and load distinct from fact table to create the dimension tables needed.