Results 1 to 2 of 2

Thread: Slicer with members from same dimension

  1. #1
    Join Date
    May 2005
    Posts
    1

    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

  2. #2
    Join Date
    Jun 2004
    Location
    Atlanta and Manhattan
    Posts
    607
    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
  •