BookmarkSubscribeRSS Feed
Calcite | Level 5

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:
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.
Calcite | Level 5
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.



Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Get the $99 certification deal.jpg



Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 2 in conversation