SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

cube with nonadditive measures

Reply
New User
Posts: 1

cube with nonadditive measures

[ Edited ]

I want to built a olap cube where somme measures (like sales) are additive, while others (like price) are not. any suggestions?

 

I am not sure i am in the right place here...

PROC Star
Posts: 1,334

Re: cube with nonadditive measures

Do you want the non-additive measures to be available at higher aggregation levels? If so, where are you going to get them from?

 

Tom

Contributor
Posts: 20

Re: cube with nonadditive measures

Hi Tom,

 

as a start I would be happy to have no values at higer levels.

 

Later on I could have a 'aggregate table'?

 

Christa

PROC Star
Posts: 1,334

Re: cube with nonadditive measures

I had to do something similar, but it was quite a few years ago and I no longer have access to SAS OLAP facilities. However, I had a pretty good idea of what I was looking for, so I found the following link. This paper jumps straight to the full solution, but if you just wanted no values you could create the tables using missing values for the measures.

 

It's somewhat complicated, but sadly this isn't an easy problem to solve!

 

Note that when I did it, I had one table with all of the values that I wanted, and I used a "where" to subset the rows in the AGGREGATION statement. Both work fine.

 

Best,

   Tom

 

https://www.mwsug.org/proceedings/2009/appdev/MWSUG-2009-A02.pdf

Contributor
Posts: 20

Re: cube with nonadditive measures

Thank you. I will try this ...

Ask a Question
Discussion stats
  • 4 replies
  • 144 views
  • 0 likes
  • 3 in conversation