cube with nonadditive measures

[hestala]

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...

[TomKari]

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

[christa]

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

[TomKari]

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

[christa]

Thank you. I will try this ...