public class RolapCubeOrganization extends CubeOrganization
CubeOrganization
for a relational deployment of an MdmCube
. A RolapCubeOrganization
specifies the form of SQL SELECT
statement that organizes the data of the measures of the cube. To get an existing RolapCubeOrganization
or to create a new one, use the findOrCreateRolapCubeOrganization
method of the MdmCube
.
The SQL SELECT
statement can use a GROUP BY ROLLUP
or GROUP BY GROUPING SETS
clause, or it can use an embedded totals column of a view. For more information on the GROUP BY
clauses, see Oracle Database Data Warehousing Guide or Oracle Database SQL Reference.
Modifier and Type | Field and Description |
---|---|
static java.lang.String |
ET_FORM
A constant that represents an organization of the measure data of the cube that results from the use of an embedded totals column of a view in the
SELECT statement. |
static java.lang.String |
GROUPING_SET_FORM
A constant that represents an organization of the measure data of the cube that results from the use of a
GROUP BY GROUPING SETS clause in the SELECT statement. |
static java.lang.String |
ROLLUP_FORM
A constant that represents an organization of the measure data of the cube that results from the use of a
GROUP BY ROLLUP clause in the SELECT statement. |
static java.lang.String[] |
VALID_GROUPING_FORMS
A constant that has the valid values for the forms of organization.
|
Modifier and Type | Method and Description |
---|---|
java.lang.String |
getGroupingForm()
Gets the grouping form for the cube that is associated this
RolapCubeOrganization . |
java.lang.String |
getName()
Gets the name of this
MetadataObject . |
void |
setGroupingForm(java.lang.String type)
Specifies the grouping form for the cube that is associated with this
RolapCubeOrganization . |
addSparseDimension, clearSparseDimensions, getCube, getSparseDimensions, removeSparseDimension
getContainedByObject, getID, getNewName, getOwner
public static final java.lang.String ROLLUP_FORM
GROUP BY ROLLUP
clause in the SELECT
statement.public static final java.lang.String GROUPING_SET_FORM
GROUP BY GROUPING SETS
clause in the SELECT
statement.public static final java.lang.String ET_FORM
SELECT
statement.public static final java.lang.String[] VALID_GROUPING_FORMS
public final java.lang.String getGroupingForm()
RolapCubeOrganization
. The grouping form is one of the values indicated by the VALID_GROUPING_FORMS
constant.String
that contains the null storage type of the cube.public final void setGroupingForm(java.lang.String type)
RolapCubeOrganization
.
The grouping form can be one of the following constants:
ET_FORM
ROLLUP_FORM
GROUPING_SET_FORM
The following table lists the constants that represent the valid values for the type
parameter.
Constant | Description |
---|---|
ET_FORM |
Indicates that Oracle OLAP uses the embedded totals column of a view in the SELECT statement that specifies the measure data of the cube. |
ROLLUP_FORM |
Indicates that Oracle OLAP uses a GROUP BY ROLLUP clause in the SELECT statement that specifies the measure data of the cube. |
GROUPING_SET_FORM |
Indicates that Oracle OLAP uses a GROUP BY GROUPING SETS clause in the SELECT statement that specifies the measure data of the cube. |
type
- A String
that contains a grouping form for the cube.public java.lang.String getName()
MetadataObject
.getName
in class BaseMetadataObject
String
that contains the name of this MetadataObject
.