Results 1 to 2 of 2

Thread: Is there a way to group results returend by Descendants function?

  1. #1
    Join Date
    Jan 2009
    Posts
    1

    Is there a way to group results returend by Descendants function?

    Here is my query:

    select Non Empty Crossjoin({[Measures].[Duration (m/h)]}, {[Tester].[All testers].Children}) ON COLUMNS,
    NON EMPTY Descendants([Manual test].[All manual tests], 3.0, SELF) ON ROWS
    from [runs]

    Which returns lowest level of 'Manual Tets' Hierarchy in a way like:
    Tester 1 Tester 2
    Manual test 1 10 20
    Manual test 1 20 30
    Manual test 2 30 40

    Is there a way to group and sum 'Manual test 1' in one row?
    Thanks in advance.

  2. #2
    Join Date
    Jun 2004
    Location
    Atlanta and Manhattan
    Posts
    607

    Can You Restate in the Adventure Works Scenario?

    Would you mind restating this using the Adventure Works cube? That will allow us to get you a working example as an answer.

    Many 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
  •