Questions tagged [mondrian]
3 questions
3
votes
1 answer
BI - Cube Concept and MDX Query Help
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…
lucassig
- 41
- 3
1
vote
0 answers
OLAP Advanced custom filters date
How do i filter, in a Mondrian MDX Query, just the FACTS that have ocurred in a Range of Months over last 3 years?
I need to make it dynamic so i can use parameters latter, so i need the following:
Month Range over last 3 years, Where StartMonth and…
lucassig
- 41
- 3
0
votes
1 answer
SQL to MDX translation?
An MDX (a language dealing with multidimensional data, in particularly dealing with the cube metaphor) statement can be translated to an SQL (a well-known language for the relational model) statement - Mondrian is one example solution which provides…
Zeruno
- 547
- 1
- 4
- 15