-
Slicer with members from same dimension
Hi,
Could anyone help me in my mdx query so that i could put 1 or more slicer of the same member of the slicer dimension.
"select
{ [Measures].[Units Shipped], [Measures].[Units
Ordered] } on columns,
NON EMPTY [Store].[Store Name].members on rows
from Warehouse
where ([Product].[All Products].[Drink].[Alcoholic
Beverages],[Product].[All Products].[Drink].[Dairy])"
this is the sample from FoodMart 2003. currently i
could do only slicing with different dimension.
thanks! i hope you could help me
Regards
-
If I understand the requirement, I believe this will help. You can run it against the Warehouse sample cube with the MDX sample application (Note that spacing in the syntax might be off, due to my pasting it into the area below):
WITH
MEMBER
[PRODUCT].[Alko-Dairy]
AS
'AGGREGATE({[Product].[All Products].[Drink].[Alcoholic Beverages], [Product].[All Products].[Drink].[Dairy]})'
SELECT
{[Measures].[Units Shipped], [Measures].[Units Ordered]} ON COLUMNS,
NON EMPTY { [Store].[Store Name].Members }ON ROWS
FROM
[Warehouse]
WHERE
([Product].[Alko-Dairy])
Let us know if this doesn't answer the need, and why, and I'll get back as time is available. Thanks for posting, and for visiting Database Journal!
Bill
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|