Skip to Content

Incorrect sort order of Hierarchy in BPC webclient


Last week, I added 4 hierarchies in the Entity Dimension. H1 hierarchy and H4 hierarchy have similar number of members (except couple of Parent members's name are different)

Now, when users open the BPC web client or excel, they only see H4 hierarchy, but I would expect them to see H1 Hierarchy (Which is original hierarchy).

I also created new Data access profile and added members from H1 hierarchy, but that also didn't work.


entitymembers.jpg (27.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Dec 02, 2016 at 07:00 AM


    Its by default the standard view of member selector in web! We cant change it....In order to select other hierarchy we have to select it from the button given above. Its the same in NW too! Checked!



    Add comment
    10|10000 characters needed characters exceeded

  • Dec 02, 2016 at 11:47 PM

    Hi JP

    That's right. But there is another issue.

    For e.g. I have Base level entity - Etest which has same parent in two hierarchies (H1 and H4) When I processed the Entity dimension, I looked at Dimentity SQL table, which doesn't look right. I have attached the screenshot which explains the example.



    Add comment
    10|10000 characters needed characters exceeded

    • Anybody reading this in the future, note that the above comment is incorrect. You absolutely CAN have the same parent member in both hierarchies. The actual restriction is that the same parent can't have different children in both hierarchies (other than not having any children).