Questions tagged [mondrian]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
7 views

aggregation sum and aggregation last value MDX

I have to design a datawarehouse for the reporting of the stock to date, historized on a daily basis. I have designed datawarehouse and a fact table I want to design a mondrian cube with aggregation ...
0
votes
0answers
8 views

Template is missing “reference” property, that is the reference to the Mondrian schema

I created a mondrian schema xml with schema workbanch after generating the xmh file successfuly, I uploaded it in Mondrian schemas catalog , then I created the docuemnt in "documents developper&...
0
votes
0answers
33 views

OLAP cube designing: runtime generated measures

I'm facing a requirement that I'm not entirely sure that can be achieved by pure OLAP designing (anyway, my OLAP knowledge is SO small). I have a dimension table such as DROP TABLE IF EXISTS ...
0
votes
1answer
150 views

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 -...
1
vote
0answers
470 views

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: ...
3
votes
1answer
335 views

BI - Cube Concept and MDX Query Help [closed]

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 ...