How can I export data into table in which dimension is displayed as field?
Dear all,
Assumption: There are 8 dimensions. I have a form in which 3 dimensions are POV, 3 dimensions are Page and 2 dimensions are Row and Column. After entering data into that form. I want to export data like below table:
Dim 1 (POV) | Dim 2 (POV) | Dim 3 (POV) | Dim 4 (Page) | Dim 5 (Page) | Dim 6 (Page) | Dim 7 (Row) | Dim 8 (Column) | Value |
---|---|---|---|---|---|---|---|---|
Member 1 | Member 2 | Member 3 | Member 4 | Member 5 | Member 6 | Member 7 | Member 8 | 10 |
Member 1 | Member 2 | Member 3 | Member 4 | Member 5 | Member 6 | Member 9 | Member 10 | 20 |
... | ... | ... | ... | ... | ... | ... | ... | ... |
Thanks in advance