Home > Archive > MS SQL Data Warehousing > December 2005 > how to refer to different members cross hierarchies?









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author how to refer to different members cross hierarchies?
Word 2003 memory Leakage

2005-12-07, 8:23 pm

Hi,

I have a dimension called Dim_Asset for assets, which has two hierarchies.

One is BU (business units), and Org (which has levels of BU, SPU, and
Segment).
a Segment has several SPU, which has several BU.

Actually BU is just a property of the dimension Dim_Asset.

Given a name in BU, how can I get the right hierarchy (its SPU and Segement)
in Org?

thanks,

Guangming
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com