Hello.

Hopefully, someone can help with this. As as I mentioned in the
subject, I'm looking to try and implement multiple parents for one
member in a single dimension.

I have a dimension containing departments and sub-division and
division. I've implemented this using a parent-child relationship.
Therefore, the table which my dimension is based on looks something
like this....

ou = organisational unit

ou_id parent_ou_id
1 NULL
100 1
1000 100
2000 100
3000 100

The dimension looks like...

Europe (1)
Western Europe (100)
Switzerland (1000)
France (2000)
Spain (3000)

My company is shortly to merge with another company and we would like
to add their structure to the dimension i.e. a department could be part
of two organisational structures. How can I do this so sales figures
for a particular department don not end up being double counted.

The dimension should look something like this...

Europe (1)
Western Europe (100)
Switzerland (1000)
France (2000)
Spain (3000)
EU (?)
Spain (3000)
France (2000)
Non EU (?)
Switzerland (1000)


I've tried doing this in AS2000 and have not found a solution. We are
currently investigating migrating to AS2005, so a solution in either
would be fine.

Thanks and regards,
J.

Would it be possible to do this with different hierarchies? For example,
you can have
Geography.[Company 1]
Geography.[Company 2]
If you can do it this way, you can create the hierarchies in either AS2000
or AS2005 - though the latter is much better at it.

--
HTH!
Denny Lee
<dennyglee_at_hotmail_dot_com>
space: http://spaces.msn.com/members/denster/



<jerstep (AT) yahoo (DOT) com> wrote

I have nearly the same requirement as J, and I'm also looking for a
solution, but Denny's may not work, because I need to be able to
specify an arbitrarily large number of parents, and Denny's second
hierarchy will only support a second parent. Also, I need to enable my
one power user to modify the dimension hierarchy on the fly, adding
multiple children and multiple parents as he desires. Is there an easy
way to support creation of many (> 5 and counting) parents some other
way, or is there an easy way to for the user to create many parallel
hierarchies as adds parents to a member?

Denny Lee wrote:

To be honest I don't really understand hierarchies. Aren't they just a
different way of looking at the same data ? The Time hieracrchies of
Calendar and Fiscal being typical. Using my example with Western Europe
as a category, how would this not be included in the second hierarchy ?

Also, if there are totals involved, for example sales figures for a
department, would these figures not double up when viewing from a high
level ?

I have a look for previous posts and have found a few where people want
to do the same as I but there don't seem to be any solutions posted.
Thanks for the posts; Denny and PM

Right. I've looked at other posts and haven't seen the solution
either. I agree that the system may double-count measures associated
with members that have multiple parents, but there should be a solution
(custom calculation logic?) for all of this. I just haven't found it
yet. I did notice that someone indicated that the June CTP (which I've
been using) had a bug that prevented specification of many-to-many
links within a dimension, and maybe the Sept CTP fixed this. I need to
upgrade to the Sept CTP and try again to establish the many-to-many
links within my dimensions. Then I'll let you know if I figure it out.

PM

I've actually got the September CTP but can't work out how to do this
so anything you find out would be appreciated.

Hmm - in that case, you will probably want to make use of the Many-to-many
relationship functionality of Yukon. You can find a good reference to it
at:
http://www.sqljunkies.com/WebLog/sql...0/04/4447.aspx

You would probably do something like create a country table with
Switzerland, France, and Spain in it, while creating a Region table with
Western Europe, EU, and non-EU in it (with all of it hooking up to Europe).
Then you would create a CountryRegion table that would allow the
many-to-many relationships between Country and Region in this particular
case.

--
HTH!
Denny Lee
<dennyglee_at_hotmail_dot_com>
space: http://spaces.msn.com/members/denster/



<jerstep (AT) yahoo (DOT) com> wrote

In article <1129912174.541075.79630 (AT) g14g2000cwa (DOT) googlegroups.com>,
jerstep (AT) yahoo (DOT) com says...
I posted an article on my blog today about how to get something like
this to work in either AS2k or AS2k5. Have a look and see if it helps.

http://www.geekswithblogs.net/darren...0/24/57812.asp
x

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

Thanks for that Darren. Your link didn't seem to work for me but I
found the article anyway. Only skimmed through your article but it
looks pretty exciting as you've put in screenshots and as well as
narrative. I'll read through properly and get back to you.