Maintaining OLAP Groups and OLAP Summary Data Stores

Preparing to Create Summary Data Stores

Before you create an OLAP Group and its associated summary data stores, you must do some preparation, which is summarized as follows:

Hierarchy of objects	In SAS/Warehouse Administrator, make sure that you have created the appropriate Data Warehouse Environment, Data Warehouse, and Subject.
Input source(s)	Determine which input source(s) to use for each summary data store. For example, if the input source for an OLAP MDDB is a Detail Table, the Detail Table must be fully operational before the OLAP MDDB is populated. Analyze the input data. For details, see Analyzing Detail Data for an OLAP Application. Decide what columns are needed for the summary data store.
Processes	Determine whether the source code, which defines how data moves from input sources to output targets, is generated by SAS/Warehouse Administrator or is it user written and stored in a SAS catalog entry. Determine the type of Mapping processes, for example, you might need to transform data or generate data. Determine whether you need to define other processes such as a User Exit process, Data Transfer process, or Record selector process.
Output target	Determine how you want to store each summary data store. For example, determine what format you want to store the data, such as SAS format or a DBMS. For more information, see Summarizing Data Using SAS/Warehouse Administrator. Determine on what platform you want to store the summary data store and where the summarization should occur. That is, you could store the data store locally and have the summarization occur on a remote host.