topic cube with nonadditive measures in SAS Data Management

cube with nonadditive measures

hestala — Wed, 27 Jun 2018 06:36:57 GMT

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

Re: cube with nonadditive measures

TomKari — Wed, 27 Jun 2018 19:50:45 GMT

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

Re: cube with nonadditive measures

christa — Thu, 28 Jun 2018 04:44:58 GMT

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

Re: cube with nonadditive measures

TomKari — Thu, 28 Jun 2018 14:41:45 GMT

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

Re: cube with nonadditive measures

christa — Fri, 29 Jun 2018 05:03:23 GMT

Thank you. I will try this ...