Chapter 4 Building Multidimensional Diagrams


Cube properties

You can double-click any cube symbol in a diagram to display its properties:

Property Description
Name The name of the item which should be clear and meaningful, and should convey the item's purpose to non-technical users
Code The technical name of the item used for generating code or scripts, which may be abbreviated, and should not generally include spaces
Comment Descriptive label for the cube
Stereotype Sub-classification used to extend the semantics of an object without changing its structure; it can be predefined or user-defined
Fact Fact used by the cube

A cube definition also includes the following properties:

Property Description
Queries SQL statement required to generate the cube data text file that will be used to populate the OLAP cube
Fact Measures Measures linked to the fact of the cube
Notes Description associated with the cube
Rules Business rules associated with the cube
Extended Dependencies User defined semantic dependencies between objects in the model
Dependencies Relationship between two modeling elements, in which a change to the influent element will affect the dependent element
Version Info Cube owner, version number, modification and creation details

 


Copyright (C) 2005. Sybase Inc. All rights reserved.