Post reply

Sorting Parent Table

  • December 5, 2008 at 12:36 pm

    #202474

    Hi everyone,

    I have one cube strutured in tree, whit parent.....

    so i can only sort this by a key table? or i can sort for another column?

    I need sorting by a column because i can't change my Table Id so anyone have a solution for me?

    many thanls

  • December 8, 2008 at 8:40 am

    #909177

    If your question is: how can I set the default sortorder for a dimension(-attribute); the answer is that you can sort by

    - key (the default, which is apparently not what you want)

    - name (which by default will be the same as key, but you can specify otherwise)

    - attributekey (the key of a related attribute)

    - attributename (the name of a related attiribute)

    These sort-options are configured in BIDS, in the appropiate dimension, on the appropiate attribute, by setting the OrderBy- property ( and the OrderByAttribute- property if you choose attributekey or attributename)

    In most client apps you will be able to overrule this setting and sort otherwise.

    Peter Rijs
    BI Consultant, The Netherlands

  • December 8, 2008 at 10:31 am

    #909263

    Hi,

    i'm explain the better way, so

    I have a table like this:

    Id(Primary Key)|Name|Parent|Action|

    and I now i made a table like this

    Id(Primary Key)|Name|Parent|Action|Order of columns|

    So i want see like a tree and the childs order by "Order of columns"

    How i do that?

    Thank for your answers ;), and sorry my english

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply