HELP:
I NEED TO DO SOMETHING LIKE THIS:

WITH
SET [~ROWS] AS
{[Dim].[x], [Dim].[y]}
SELECT
NON EMPTY {[Measures].[Cantidad]} ON COLUMNS,
NON EMPTY [~ROWS] ON ROWS
FROM [Cube]
WHERE {[Fecha desde.Fecha simple].[01/01/2004]:[Fecha hasta.Fecha simple].[31/01/2004]}

EQUIVALENTE EN SQL:
WHERE TO_CHAR(FCHDES, 'YYYY-MM-DD') < ${DATE} AND (TO_CHAR(FCHHAS, 'YYYY-MM-DD') > ${DATE} OR TO_CHAR(FCHHAS, 'YYYY-MM-DD') = '0001-01-01')
I NEED TO ADD TO MY MDX A CONDITION LIKE THIS.
REGARDS