hi,
I have a tree prompt(?TREE?) that is based on date column X. But i want to filter three other queries that are based on date column Y, Z, M through this date column X. Somehow it is not filtering the data correctly.
I am using this filter
[Heirachy].[Date].[Y]=?TREE? in one query
[Heirachy].[Date].[Z]=?TREE? in second query
[Heirachy].[Date].[M]=?TREE? in third query
i am also using:
[Heirachy].[Date].[Y]->?TREE?
[Heirachy].[Date].[Z]->?TREE?
[Heirachy].[Date].[M]->?TREE?
as column definitions
pls advice