Results 1 to 2 of 2

Thread: Mdx Query Dim?split?left?

  1. #1
    Join Date
    Jun 2005
    Posts
    1

    Mdx Query Dim?split?left?


    Hello
    i have some problem with this MDX Statment :


    with
    SET [kunden] as 'Filter (descendants([Dim_x].[Alle Kunden], , LEAVES),
    left([Dim_x],1,1) = "(" ) '
    select
    {descendants([Dim_Kx].[Alle Kunden], , LEAVES) } on rows,
    {([measures].[Standard])} on columns


    from z
    Result :
    Standard
    (test1) 44444
    (test2) 54567
    (test3) 3214
    test5 4535
    test6 11111
    but i want to filter i need only result with () how can i do it please
    i need help


    many thanks,
    Prince

  2. #2
    Join Date
    Jun 2004
    Location
    Atlanta and Manhattan
    Posts
    607
    Having a hard time understanding your question ... try restating with a FoodMart example, so others can benefit as well.

    Thanks.

    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
  •