using HOLAP to resolve semi additive

jplarios — Wed, 09 Feb 2011 13:20:18 GMT

HI:
I came across this great paper:"What You Need to Consider When Building and Deploying an OLAP Application" ; by a SAS guy named Greg Henderson. Although this paper talks about PROC MDDB- I did not notice until the end- it seems to apply to PROC OLAP. I liked his way of how to handle semi-additive measures with a HOLAP on the 'Special Aggregation Rules' section. This seems to be a HOLAP in PROC OLAP. Could "manually aggregate those subtables
using the appropriate business rules in SAS Data Step or SQL
code" be accomplished by having a detail(or star schema) as input and then affixing those special aggregated tables to the cube? Could this happen with PROC OLAP? Could I apply everything on this paper to PROC OLAP?
I never found a reason to use ROLAP(or HOLAP) in a cube ( I would just use an information map), but to solve semi-additives this seems like a great option.

Re: using HOLAP to resolve semi additive

TSBruce — Wed, 09 Feb 2011 14:36:38 GMT

You may also want to check out http://support.sas.com/resources/papers/proceedings09/046-2009.pdf.

Re: using HOLAP to resolve semi additive

jplarios — Wed, 09 Feb 2011 15:08:47 GMT

TSBruce,
excellent! that addresses the question with pros and cons.

topic Re: using HOLAP to resolve semi additive in SAS Web Report Studio

using HOLAP to resolve semi additive

Re: using HOLAP to resolve semi additive

Re: using HOLAP to resolve semi additive