Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: MDX: Slicing on a set

  1. #1

    Default MDX: Slicing on a set

    Hi!
    I have to specify a slicer for a mdx-query.
    I have a dimension with only one level.
    I have to slice a couple of members of that dimension but I don't know how.

    Code:
    ...
    where
    [dimension].[all level].[meber x],
    [dimension].[all level].[meber y]
    doesn't work.

    Also an "OR" instead of the comma doesn't work.
    Does anybody know the solution? It's really important....

  2. #2

    Default

    as far as I was aware you can only slice on one dimension, otherwise you have to put it into the on row and on columns and utilise the .children .parent etc stuff

    HTH

    Tom

  3. #3
    wgorman Guest

  4. #4

    Default Thanks!

    Whoo ... relaxation ...
    Thanks to both of you!
    The link was really profitable for me!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.