|
Hi! Is it possible to have columns and results like img below?
|
|
Sorry for the late response. This result doesn't really work for OLAP datasources. This would be a SQL-like, 2 dimensional result, while we would produce something that has the Time dimension on one axis, and then the Store dimension on the same axis, but below the Time dimension. So thats hierarchically organised, which is important for the results. The only way to get a flat resultset is to drillthrough (i think its the 7th icon in the toolbar from the left) The drillthrough returns all single rows that are responsible for the current OLAP resultset Hope this helps! -Paul |
|
theoretically you could write a UI plugin, but changing layout in the UI is always slow but i think you would still have problems because in OLAP you cant have 2 dimensions next to each other, but always hierarchical. what exactly do you want to achieve? maybe we can achieve this somehow else -paul |
|
Let's say I have data from an employee satisfaction survey. 20 questions + demographics like gender, age, department, years employed. By listing all questions in a row and distribute them per demographics in columns, I can quickly identify any significant differences in opinion depending on those demographics. So instead of creating one table for every demographic question I get to have them in the same spot, side by side, easy to grasp. Makes any sence? |
|
yeah i know what you mean the only way to do that in OLAP is to create a dimension "Demographic" and a level with all those demographic data. then you can just drag that over to rows but if you create different dimensions there is no way you can do it in OLAP. this is simply not possible. you would crossjoin all the different dimensions and get an according result, which is hierarchical. |
Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
Tags:
Asked: 18 Jun '11, 08:27
Seen: 370 times
Last updated: 20 Jan, 09:53