MDX Filtering on Multiple Dimensions
Posted: Fri Mar 25, 2011 9:42 pm
A couple of general questions here about MDX and TM1 ...
1) Is it possible to filter on multiple dimensions in TM1? Here's an example for the sake of clarity:
* Cube Products has three dimensions: Color, Size, Price.
* In a cube view, Color and Size are to the left (rows) and price is on top (column).
* Can a filter be created that produces the following output
Blue, Small, 3.00
Blue, Large, 4.00
Red, Small, 1.00
Green, Large, 9.00
2) Assuming this is possible, can anyone point me to a good resource or example that explains it?
I see a lot of MDX tutorials with SELECTs, nested statements, and other useful constructs, but my brain is stuck on the fact that each of these filters is sitting in a dimension (Color *or* Size) when it seems like I should be filtering the elements together, not separately. Effectively, I need to have a different Size subset for each element in Color, using the example above.
Hopefully that makes sense. I feel like this is probably basic MDX stuff here, but I'm new to it. Just trying to get some concept help.
Thanks for reading.
1) Is it possible to filter on multiple dimensions in TM1? Here's an example for the sake of clarity:
* Cube Products has three dimensions: Color, Size, Price.
* In a cube view, Color and Size are to the left (rows) and price is on top (column).
* Can a filter be created that produces the following output
Blue, Small, 3.00
Blue, Large, 4.00
Red, Small, 1.00
Green, Large, 9.00
2) Assuming this is possible, can anyone point me to a good resource or example that explains it?
I see a lot of MDX tutorials with SELECTs, nested statements, and other useful constructs, but my brain is stuck on the fact that each of these filters is sitting in a dimension (Color *or* Size) when it seems like I should be filtering the elements together, not separately. Effectively, I need to have a different Size subset for each element in Color, using the example above.
Hopefully that makes sense. I feel like this is probably basic MDX stuff here, but I'm new to it. Just trying to get some concept help.
Thanks for reading.