topic Re: Hierachy: Shared bottom level members in SAS Web Report Studio

Hierachy: Shared bottom level members

metalray — Thu, 18 Nov 2010 15:10:29 GMT

Hello,

I have an accounts hierachy with about 10 000 botton level accounts
that roll up into various relationship managers. now one account
can be managed by multiple managers. I remember in Oracle Hyperion
a bottom level member can be "shared" between loads of parents.
How is this done in SAS OLAP?

On this page:http://support.sas.com/documentation/cdl/en/olapug/59574/HTML/default/viewer.htm#a003212362.htm
I read "You cannot share levels between dimensions." Which does not sound so good to me.

The relationship of those 10 000 bottom level members comes from a nice flat table that I
can design according to what SAS OLAP likes but I am not keen to use SAS OLAP Cube studio
to hand pick my bottom level member allocations.

Re: Hierachy: Shared bottom level members

AngelaHall — Thu, 18 Nov 2010 15:43:24 GMT

You might consider using Identity Driven Security.

Reference material: http://support.sas.com/documentation/cdl/en/olapug/59574/HTML/default/viewer.htm#a003212399.htm
http://support.sas.com/documentation/cdl/en/olapug/59574/HTML/default/viewer.htm#a003212372.htm#a003212373
and pg66 http://support.sas.com/documentation/cdl/en/bisecag/61133/PDF/default/bisecag.pdf

~ Angela

Re: Hierachy: Shared bottom level members

metalray — Fri, 19 Nov 2010 08:07:08 GMT

Hi Angela,
Thanks for the reply.
My problem has nothing to do with security. When I say "shared" I dont mean
shared in terms of access but shared between different parents.
So one level 0 account can be under level 1 "John Smith" and level 1 "bob healey"
and when this level 0 account changes, it is seen by both level 1 account managers. I think the nice thing behind this idea is that the data is --not--stored twice but just referenced twice. a similar idea in SAS might be "multiple hierachies" but its not exactly what I want.