Hi,

I have a dimension table Date (dim_date) with all dates from 2000 to 2100 year. In fact table, only have dates from 2007 to 2016.
When I try to filter the year of dim_date, it show all years. I only need to show years with reference in fact table

I am using this MDX query in a CDE Dashboard, but it don't run properly. I get all years...

WITH
MEMBER [Measures].[Years] AS [Date].currentmember.UniqueName
SET YEARVALUE AS UNION( [Fecha].[Todas] , [Fecha].[Anio].Members )

SELECT
[Measures].[Years] ON COLUMNS,
YEARVALUE ON ROWS
from [Sales_Datamart]


Any solution?

Thanks