When connected to a sas metadata Server, the main window of the sas olap cube studio displays cube information specific to that metadata server.
All cube administration tasks, such as creating and updating cubes, are initiated from this window.
The main window has six main visual components:
The toolbar and pull-down menus provide fast access to a set of selected commands. The icons available on the toolbar depend on which window is active from within the interface.
The Shortcut bar is populated with icons for each task an OLAP user would typically perform:
The navigation tree displays an organized list of the cubes, OLAP schemas, and tables registered in the selected SAS Metadata Repository.
The status bar is located at the bottom of the SAS OLAP Cube Studio application window. It displays short status messages for the application.
The Messages window displays application messages such as:
Application Server Error: Attempted connection to Application Server failed. Verify that the server is running.
To resize the Messages window, use your mouse to drag the top edge of the window up or down. When you close the window, your resized setting is saved.
To toggle the display of the Messages window, select
View Ð Message Window.
CAUTION: Other SAS OLAP Cube Studio elements, such as the Properties dialog box and the SAS Log window, are displayed in the same area as the Messages window. For this reason, when resizing the Messages window, make sure that you leave enough room for SAS OLAP Cube Studio to display those other elements.
The Cube Designer wizard is used to
The same Cube Designer Wizard is also available from SAS ETL Studio.
The General window is used to specify the cube’s name and description. You also select a storage location for the cube’s definition and a storage location for the physical cube.
SAS OLAP Server names for cubes, dimensions, hierarchies, measures, and member properties follow these general rules:
These guidelines assume that the SAS Workspace Server is running with the VALIDVARNAME= system option set to ANY.
If a hierarchy is balanced, then all of its branches descend to the same leaf (bottom) level. In addition, each member has a parent level that is positioned immediately above it. However, hierarchies are not always balanced and sometimes they contain missing hierarchy members. This type of hierarchy is a ragged hierarchy. The Ragged Hierarchies tab enables you to set options to handle the missing members (character and numeric) for all levels and hierarchies within the cube.
On the Input window, you specify the data source that provides the input data for your cube by selecting an already registered data source or by defining a new data source.
The Drill-Through window is used to specify an optional drill-through table. Drill-through tables can be used by client applications to provide a view from processed data into the underlying data source.
From this wizard window you launch the Dimension Designer wizard to define the cube’s dimensions and their associated hierarchies and levels.
You can have a maximum of 128 dimensions per cube.
For example, in a Time dimension, a hierarchy might consist of Year, Quarter, Month, and Day (which are the levels).
The Member Property window is where you can add, modify, and delete member properties for the levels in the cube.
The maximum number of member properties per level is 256.
In the Generated Aggregations window, you define aggregations to be generated for the cube in addition to whether the NWAY aggregation (the crossing of all dimension levels) is automatically generated.
The finish window is where you review the details of the cube that you just defined and choose whether to only save the cube’s definition to the active metadata repository, or to save the cube’s definition and build the cube.
In this window, you can also save the PROC OLAP code that is created by the wizard.
Goal: Build a cube in order to examine trends in length of delivery over time and for different types of orders.
The OrionStar cube will be built from the OrderFact detail table and consists of two dimensions and several measures.
This demonstration illustrates building a cube using SAS OLAP Cube Studio.
Invoke the SAS OLAP Cube Studio by selecting Start Ð All Programs Ð SAS Ð SAS OLAP Cube Studio 1.
2. Select the metadata profile BIArchitecture, then select
3. If prompted, enter the username and password provided by the instructor.
The OLAP Cube Studio desktop opens:
4. Select the Cube Designer from the Shortcut bar to access the Cube Designer wizard.
Selectto access the general window of the Cube Designer.
g. Selectto get to the Advanced Cube Options window. The Ragged Hierarchies tab enables you to set options to handle the missing members globally for all levels and hierarchies.
Selectto close the Advanced Cube Options.
Selectto access the Cube Designer – Drill-Through window.
Selectto access the Cube Designer – Dimension Tables window.
Selectto access the Dimension Designer – Levels window.
10. Selectto review the Level Properties.
Selectto access the Define a Hierarchy window.
Selectto close the Define a Hierarchy window.
e. Selectto access the Dimension Designer – Levels window.
g. Selectto review the Level
k. Selectto close the Define a Hierarchy window.
Selectto access the Cube Designer – Measure Details window.
Selectto access the Cube Designer – Member Property window.
Selectto access the Cube Designer – Generated Aggregations window.
A status window displays as the cube is being built.
19. Check the Log Frame for messages and to verify that the cube was created successfully.
20. If the cube was created successfully, it will be listed in the Cube group:
21. Select File Ð Exit to close SAS OLAP Cube Studio.
22. A SAS OLAP cube is stored as a set of files on the operating system – the OrionStar cube is stored at C:WorkshopwinsassbiovrDataMartsCubesOrionStar:
Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!
Vinod M is a Big data expert writer at Mindmajix and contributes in-depth articles on various Big Data Technologies. He also has experience in writing for Docker, Hadoop, Microservices, Commvault, and few BI tools. You can be in touch with him via LinkedIn and Twitter.
Copyright © 2013 - 2023 MindMajix Technologies