Hi All,


I'm new with Pentaho and I'm having a lot of problems with MDX. I want to create a Dashboard in Pentaho with 'DATE_FROM' and 'DATE_TO' parameters.
As I don't have knowledge with MDX, I installed Saiku in my BI Server and I use it to create the MDX query.


This is one simple example of query for all dates


WITH
SET [~COLUMNS] AS
{[view.all].[view].Members}
SET [~ROWS] AS
{[time.all].[date].Members}
SELECT
NON EMPTY CrossJoin([~COLUMNS], {[Measures].[sessions]}) ON COLUMNS,
NON EMPTY [~ROWS] ON ROWS
FROM [VisionGeneral]


But as I want introduce the 'DATE_FROM' and the 'DATE_TO' as a parameters I don't know how to do it. For example I tried to set it in saiku and the result was the following.


WITH
SET [~COLUMNS] AS
{[view.all].[view].Members}
SET [~ROWS] AS
{[time.all].[2015].[01].[20150101], [time.all].[2015].[01].[20150102], [time.all].[2015].[01].[20150103], [time.all].[2015].[01].[20150104], [time.all].[2015].[01].[20150105], [time.all].[2015].[01].[20150106], [time.all].[2015].[01].[20150107], [time.all].[2015].[01].[20150108]}
SELECT
NON EMPTY CrossJoin([~COLUMNS], {[Measures].[sessions]}) ON COLUMNS,
NON EMPTY [~ROWS] ON ROWS
FROM [VisionGeneral]


But with this I can't introduce the two parameters than I want.
In The last example of MDX query the DATE_FROM=20150101 and the DATE_TO=20150108


I used to work with sql and this situation in sql was very simple to fix with the WHERE clause BETWEEN DATE_FROM and DATE_TO But here in MDX for me is very dificult to find the solution.


I hope that somebody can help me, because I spent a lot of time searching in internet but I couldn't find the solution and I really need it for my final degree project.


Thanks in advance and regards