Take the 2-minute tour ×
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. It's 100% free, no registration required.

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 in 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
    
I'm having trouble decoding your question can you attempt to clarify please. –  Zane Jan 31 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 at 12:18

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.