BookmarkSubscribeRSS Feed
sas_newbie_at
Calcite | Level 5

Hello everyone,

 

I have a question about SAS OLAP Cube - I have a dimension with lets say 2 members + "all" member. These members' values should not be aggregated because this does not make business sense (2 entities, lets say, which are separate and together in cube because all other dimenesions and members are the same for them).

Is there an option how I can designate members/hierarchy/dimension so that no aggregation takes place only there? SAS version is 9.3.

 

Here is the same thing how it's done in Essbase (designated as "~"):

Example Essbase docs

Is there something similar available in SAS OLAP as well?

 

thank you very much!

2 REPLIES 2
LinusH
Tourmaline | Level 20
My immediate response would be, why keeping data together in a cube that can't be presented together?
If you are in some way worried about duplicating dimensions you could use shared ones.
Data never sleeps
sas_newbie_at
Calcite | Level 5

Hello LinusH,

 

thanks for your reply!

You are right that that would be a solution but in that case we have 2 cubes which is not very convenient for end users.

I agree in principle that it is something that does not belong together maybe, however there is a similar situation which is tipical in cubes - Scenario dimension which holds e.g ACTUAL, PLAN, FORECAST values which are not to be summarized.

Another thing, this might happen possibly not only for the whole dimension, maybe just some members are not to be aggregated...

 

Also if this stays in cube as it is, it will happen sooner or later that users will look at summarized results which should not be summarized. It would be good to aviod that.

 

It is a rather specific situation, but Essbase does it with no problems.

 

Is there really no such option?

 

Nevertheless, I'll think about 2 cubes with shared dimensions and each having it's specific dimension part (of the one where the difference is).

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

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

View all other training opportunities.

Discussion stats
  • 2 replies
  • 399 views
  • 0 likes
  • 2 in conversation