Calculated Members and Parent/Child

  • Hi there, i wonder if anyone can help with a little problem i have :-

     

    I have a parent/child hierarchy where i would like to add some Calculated members into it.  Ideally i need to add them under their own heading as a level 2 entry.

    I have sucessfully added them at level two, but AS will only display the calculated members if there is a genuine child to the hierarchy.  If there is no child, despite defining the parent of the calculated member, they will not display.

    Hope this makes sense.

    Thanks

    Russ

     

  • Not saying it's the best way, but the last time I saw someone attempt this, they created the member placeholders outside of the model (ie in your source, possibly use a union with some static fields returned in sql in the view that feeds your P-C dim), and then they used calc cells to manipulate the values at these placeholders.

    Steve.

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

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