Groups | Search | Server Info | Login | Register

Groups > comp.soft-sys.sas > #855

build SAS OLAP cube on data from snowflake schema

Show all headers | View raw

I need to build SAS OLAP cubes on data from SAS OpRisk Monitor
database. And i've faced with one serios problem: SAS OpRisk database
is a fnowflake schema, but SAS OLAP coudn't load this schema (only
star schema or detailed table).
I try to find out the way how to transform snowflake shema to star
schema and then load data into cube correctly (with possibility of
correct reception of the aggregated data).
Could some One help me, maybe You faced the same problem sometime?
Link to the documentation with the description of the general
algorithm will be the most usefull for us, i think.

Back to comp.soft-sys.sas | Previous | Next — Next in thread | Find similar

Thread

build SAS OLAP cube on data from snowflake schema Andrey Sindickii <a.sindickii@businessdecision.ru> - 2011-06-02 05:41 -0700
  Re: build SAS OLAP cube on data from snowflake schema Reeza <fkhurshed@gmail.com> - 2011-06-02 10:48 -0700

csiph-web