Hello, I am new to using SAS OLAP. I have been using SSAS for several years. I just have a few comparison questions that I am curious about: Is it possible to have multi-fact cubes, or to link cubes together? I.E., can I make calculations that refering to measures of different granularity, like comparing customer counts to demographic houshold counts and so forth. Also, is it posslbe to somehow do many-to-many relationships, I.E. looking at counts of auto insurance policies with certain driver charateristics. This would be like counting if x attribute exists on a lower grained dimension, count it, otherwise do not ect.
... View more