Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Can I use members from multiple dimensions from to define a hierarchy Expand / Collapse
Posted Thursday, December 6, 2007 10:22 AM


Group: General Forum Members
Last Login: Monday, June 30, 2008 8:34 PM
Points: 16, Visits: 71
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.

Post #430310
Posted Tuesday, December 11, 2007 8:19 PM


Group: General Forum Members
Last Login: Wednesday, July 14, 2010 3:02 AM
Points: 163, Visits: 171
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.
Post #432117
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse