06-27-2018 02:28 AM - edited 06-27-2018 02:36 AM
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...
06-28-2018 10:41 AM
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.