I have an SSAS time dimension cube and would like to use this in my report to reference the fact table. It refers to a column "SnapshotDate" in the fact table. This column only has date values of the last day of a month. I can drag and drop the time dimension on the data tab and tick the box that I want to use this as a parameter. That works well, but what I would like to achieve is having the parameter selection list filtered on the possible values that are in the fact table. For example: - Time dimension ranging from 2004 to 2016 - A select distinct on the fact table column SnapshotDate gives me the following" 2009-07-31 2009-06-30 2009-05-31 Since there are only three different dates in the column SnapshotDate, I would like to have my parameter list only filled with those three months and not a selection of every month in the time dimension. Thanks! -

In that Date Dataset {PARAMETER dAtaset]u need to check for Empty By using ISEMPTY.and Filter out the members using FILTER functionPraxy

Thanks...the ISEMPTY did it. Never knew it was so easy... :)-

Can you explain that further? I am not following... Please give step by step...