|
Hi, I have seen a number of questions related to this topic but not exactly... I have to deal with a huge DB (multi-million rows, ~20 dimensions, ~30 measures) and certain dimensions have a lot of different values (possibly 100 000's). How can tell Saiku (or Mondrian through Saiku) to return only the top N rows (where N will be acceptable for Saiku tables or charts)? For example, if I have a firstname dimension and a measure counting the number of occurrences, how can I build a query in Saiku using the usual drag and drop and get only the 100 top firstname occurrences? 100 can be fixed in advance whenever firstname is used. I think this can be a way to workaround other performance issues discussed in this forum. What do you think? Regards, Stephane. As this is my first question, I take this opportunity to write that Saiku is great and shows a lot of potential. Congratulations to the Team. |
|
Hi Stephane Thanks for getting in touch. TopCount currently doesn't exist in Saiku apart from where you hand write a query. We need to add the TopCount MDX function to the Olap4J query model. Once it is in there we can then add it to the Saiku server. When this will be i can't say, its on the list of things todo, hopefully sometime early in the new year. Regards, Tom |
|
Hi, I have revisited this topic and come across the following statement in http://mondrian.pentaho.com/documentation/schema.php#Named_sets "The <namedset> element allows you to define a named set in your schema as part of a cube definition. It is implicitly available for any query against that cube" I have added "named sets" to one of my cubes but nothing changed (and no error in the logs). I realize this is maybe more a Mondrian question but I'm interested in Saiku Team and User's take on that. So, has anyone successfully used NamedSets in Saiku with the current MDX support (v2.2). Thanks, Stéphane. |
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: 23 Dec '11, 05:37
Seen: 215 times
Last updated: 19 Jan, 05:54
