Hi! Is it possible to have columns and results like img below?

alt text

asked 18 Jun '11, 08:27

Bob's gravatar image

Bob
1112
accept rate: 0%

edited 20 Jan, 09:53


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

link

answered 29 Jun '11, 06:36

pstoellberger's gravatar image

pstoellberger ♦♦
89727
accept rate: 5%

Ok, thanks. I'm not a programmer but would this be possible by writing a plugin? This type of output i very efficent when it comes to quickly get a grip of for example market research data.

Love Saiku!

link

answered 12 Sep '11, 07:57

Bob's gravatar image

Bob
1112
accept rate: 0%

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

link

answered 17 Sep '11, 15:31

pstoellberger's gravatar image

pstoellberger ♦♦
89727
accept rate: 5%

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?

link

answered 20 Sep '11, 18:04

Bob's gravatar image

Bob
1112
accept rate: 0%

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.

link

answered 21 Sep '11, 13:19

pstoellberger's gravatar image

pstoellberger ♦♦
89727
accept rate: 5%

Hi again,

Just revisited your demo and it looks and works absolutely beautiful! So by your answer above, you could theoretically have a "check box" which would merge your, for example, 3 chosen column dimensions, into one single dimension?

link

answered 09 Jan, 14:38

Bob's gravatar image

Bob
1112
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×2
×2
×1

Asked: 18 Jun '11, 08:27

Seen: 370 times

Last updated: 20 Jan, 09:53

powered by OSQA