Apparatus and method for an extended semantic layer specifying data model objects with calculated values
A computer readable storage medium includes executable instructions to define a semantic domain describing a data source. At least one base dimension is established as a data model object for the semantic domain. At least one base measure is specified as a data model object for the semantic domain. At least one of a calculated measure or a calculated dimension is described as a data model object for the semantic domain.
1 . A computer readable storage medium, comprising executable instructions to:
define a semantic domain describing a data source;
establish at least one base dimension as a data model object for the semantic domain;
specify at least one base measure as a data model object for the semantic domain; and
describe at least one of a calculated measure or a calculated dimension as a data model object for the semantic domain.
2 . The computer readable storage medium of claim 1 further comprising executable instructions to compute a calculated measure that has a value expression that is evaluated to produce values for the calculated measure.
3 . The computer readable storage medium of claim 1 further comprising executable instructions to define expressions that reference values or ranges of values from other data model objects.
4 . The computer readable storage medium of claim 1 further comprising executable instructions to compute a calculated dimension that contains members, where each member has an associated base measure determined by a calculation.
5 . The computer readable storage medium of claim 1 further comprising executable instructions to dynamically determine dimension members based on the transformation of underlying data.
6 . The computer readable storage medium of claim 1 further comprising executable instructions to determine dimension members related to a dimension hierarchy.
7 . The computer readable storage medium of claim 1 wherein the data source is specified as one of a relational, OLAP, or semantic definition data source.
8 . The computer readable storage medium of claim 1 further comprising executable instructions to display a graphical user interface to facilitate the definition of data model objects and semantic domains.
9 . The computer readable storage medium of claim 1 further comprising executable instructions to maintain restrictions, such that a data model object is defined based on existing data structures in the data source.
10 . The computer readable storage medium of claim 1 further comprising executable instructions to maintain restrictions, such that a data domain object is defined based on existing data structures in the data source.
11 . The computer readable storage medium of claim 1 further comprising executable instructions to evaluate a calculated measure or calculated dimension that references a data source other than the data source described by the semantic domain.
12 . The computer readable storage medium of claim 1 further comprising executable instructions to calculate attributes.
13 . The computer readable storage medium of claim 12 further comprising executable instructions to calculate a base attribute specifying the relation between the base dimension and a dimension attribute.
14 . The computer readable storage medium of claim 12 further comprising executable instructions to form a calculated attribute specifying the relation between the calculated dimension and a dimension attribute.
15 . The computer readable storage medium of claim 1 , further comprising executable instructions to:
define a semantic domain describing a relational data source, wherein the relational data source does not explicitly contain hierarchy logic for dimensions; and
form at least one hierarchical base dimension as a data model object for the semantic domain.
16 . The computer readable storage medium of claim 15 wherein a hierarchical base dimension describes an arrangement of dimension members within a tree structure.
17 . The computer readable storage medium of claim 15 further comprising executable instructions to display a graphical user interface to facilitate the definition of a hierarchical dimension data model object.
18 . The computer readable storage medium of claim 15 further comprising executable instructions to create calculated data model objects based on hierarchical dimension data model objects.