Post reply

Can I use members from multiple dimensions from to define a hierarchy

  • December 6, 2007 at 10:22 am

    #184679

    I m aware that the hierarchies can be defined with in members of individual dimension.

    Below is my hierarchy with in cluster dimension

    companyid -> acctdid -> products..

    But I want to show the companyname instead of companyid during drill down and drill through across that hierarchy..Company name is present in a different table other than the cluster dimension.

    How can I define hierarchy as companyname -> acctdid -> products.

  • December 11, 2007 at 8:19 pm

    #759242

    You might like to add a named calculation to your data source view. This calculation will be something like "SELECT companyname FROM othertable WHERE thistable.companyid = othertable.companyid'. Then you can use this field as the NameColumn for your companyid attribute.

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

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