Expand Order RRS feed

  • Question




    I'm wondering whether we can set the order of expand option or not.

    Suppose, if we use date hierarhcy and expand month level to week level then the way proclarity works like:



    Month         $400    

        Week 1   $100

        Week 2   $200

        Week 3   $100


    And the total of this month shows on top. But instead of this order, is there anyway to show month level (total of the selected month) at the bottom as a default instead of using custom order setting?


     Week 1   $100

     Week 2   $200

     Week 3   $100

     Month     $400


    Please let me know and thanks in advance.


    Thursday, November 29, 2007 6:26 PM


  • Unfortunately, there is no way to do this out of the box.  You can use the Subtotal or Grand Total feature in the Grid and it will place a calculated member at the bottom that would return the same value as Month in your example.  However, you do not have control over the label that it uses.  In MDX, there is a function called Hierarchize that supports reversing the order so that the Parent is on the bottom of the list, but ProClarity does not use it.  If you want to build a Named Set, here is the basic syntax:


    HIERARCHIZE({<mdx set>}, POST)


    If you build a set using this function though, be aware that ProClarity's Grid was designed to explicitly place the Parent item before the Children so you end up with a weird look to the indentation of the labels.  You can get around it by using the Flatten Row Headers menu option, which removes all indentation.


    If I knew of a way to post screenshots of all of this I would, but I'm not sure if TechNet allows it (I'm new to TechNet).

    Thursday, November 29, 2007 11:32 PM