Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In a Mondrian Schema, I have a fact table for Sales, a dimension table Time and a dimension table Client.

I need to create a Saiku report where i can show how many clients joined per year. I have a the Time dimension and a join_date in Client (which DO NOT link to the Time Dimension key, is just a date field),.

If I create a cube adding Join_date as a Level of the Client Table, I wouldn't know how to filter that latter in the Saiku.

Does anyone know how is the best way to add JOIN_DATE on client? I just need a report: Clients that have joined to the company by year.

And how should <Property> work in cubes? When i tested using this <Property>, it was not visible in Saiku...

share|improve this question

closed as off-topic by Tom V, RolandoMySQLDBA, Julien Vavasseur, Phil, mustaccio Jan 29 at 13:01

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Tom V, RolandoMySQLDBA, Julien Vavasseur, Phil, mustaccio
If this question can be reworded to fit the rules in the help center, please edit the question.

I'm having trouble decoding your question can you attempt to clarify please. – Zane Jan 31 '14 at 16:04
Ok i try to add more details, but if it doesen't help please tell me what you didn't get, the Objetive or the Scenario. Thanks – lucassig Feb 3 '14 at 12:18

you can do this with help of MDX Custom filer on filter option when we generated report for cube.

there you write query regaring dimension table and fact table with help of select measures.[attribute] on rows from cube name where conditon apply . and so on...

share|improve this answer
Thanks for the useful answer. It might be even more helpful if you could describe why this works and how it would help - you'll probably attract more up votes that way as well :) – Tom V Oct 21 '15 at 16:03

Not the answer you're looking for? Browse other questions tagged or ask your own question.