MDX Element Comparison
Posted: Fri Nov 14, 2008 10:21 am
I'm trying to compare 2 different dims with MDX to pick out only the elements that exist in both. EXCEPT looks like the closest match, but it only works on the current dim, it won't allow a comparison across multiples. I know i could do this with attributes and a rule but i'm trying to get to grips with MDX more and wanted to know if there was a way of doing it.
The essence is i have 2 dims, Clients and }Clients. The first will always hold more because its historic but i wish to filter its elements by the existing }Clients when browsing the cube its used in. The plan was to used EXCEPT to find all those that didn't match, then use the results of that to reverse it.
The essence is i have 2 dims, Clients and }Clients. The first will always hold more because its historic but i wish to filter its elements by the existing }Clients when browsing the cube its used in. The plan was to used EXCEPT to find all those that didn't match, then use the results of that to reverse it.