|
Hi, I have installed Saiku 2.2, I like it. When I select a child from a dimension, I get all the child values repeated for every father value and the values are ordered by father value. Even if this can be right, is not what the end user want. For example: From Foodmart Sales I select Day on column and profit on row, I get some dais repeated and not ordered. The MDX is this SELECT NON EMPTY {Hierarchize({[Time.Weekly].[Day].Members})} ON COLUMNS, NON EMPTY {Hierarchize({[Measures].[Profit]})} ON ROWS FROM [Sales] This MDX is translated in select "time_by_day"."the_year" as "c0", "time_by_day"."week_of_year" as "c1", "time_by_day"."day_of_month" as "c2", sum("sales_fact_1997"."store_sales") as "m0", sum("sales_fact_1997"."store_cost") as "m1" from "time_by_day" as "time_by_day", "sales_fact_1997" as "sales_fact_1997" where "sales_fact_1997"."time_id" = "time_by_day"."time_id" and "time_by_day"."the_year" = 1997 group by "time_by_day"."the_year", "time_by_day"."week_of_year", "time_by_day"."day_of_month" I would like this select "time_by_day"."day_of_month" as "c2", sum("sales_fact_1997"."store_sales") as "m0" from "time_by_day" as "time_by_day", "sales_fact_1997" as "sales_fact_1997" where "sales_fact_1997"."time_id" = "time_by_day"."time_id" and "time_by_day"."the_year" = 1997 group by "time_by_day"."day_of_month" order by "time_by_day"."day_of_month" Is there a way? Thanks in advance |
|
this is how olap works the repeated values are correct: http://cl.ly/0u393T2I2V44132y0A1p if you just want the days without father values, just create a hierarchy that has only the day level in it, without year / week, then you would probably get the result you want to see i guess Thank you for the answer. I can understand but is difficult for an end-user. From end-user point of view, I think the displayed values should be always unique and ordered (even when only a child without his fathers is selected). If this is not how olap works, maybe should be better that saiku shows also the father values, when the user select a child. In our example : When the user select only day, also Week and Year are automatically dragged in the query panel and the query result is like the one you did. What do you think?
(22 Feb, 08:03)
alisadec
you could also change your cube and make the day unique: 2007-FEB-01 e.g I know that some people do that e.g. for quarters .... 2007-Q1 instead of just Q1 i understand the issue but not sure how to deal with this best. the option you describe always depends on your cube/data and i cant guess that...
(23 Feb, 10:53)
pstoellberger ♦♦
|
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- 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:
Asked: 20 Feb, 03:48
Seen: 161 times
Last updated: 23 Feb, 10:53
