Home > Class Reference > ENSLIB namespace > %BI.PivotTable
Private  Storage   


persistent class %BI.PivotTable extends %Persistent, %XML.Adaptor


Parameters Properties Methods Queries Indices ForeignKeys Triggers
43 9 3 3


ChartAttrib ChartFormat ColCustomGroup ColMeasure
DataMart DataMartName DrillDownReport EffQuery
ExcelDrillDownInfo ExcelFilterInfo ExcelLayout Folder
FolderName HideColumns HideRows LinkReport
MOLAPClass MOLAPColumn MetricStr Metrics
NestedReport ObjectOwner PivotCat PivotClass
PivotName PivotNotes QueryCom QueryVariable
RankRemain Ranking RecreateMOLAPClass RowAggregateOption
RowCustomGroup RowMeasure SQLClause ShowColumnAvg
ShowColumnTotal StaticReport SuppressNullRows SyncOption
TableClass TableQuery UnionReport

%AddToSaveSet %AddToSyncSet %BMEBuilt %CheckConstraints
%CheckConstraintsForExtent %ClassIsLatestVersion %ClassName %ComposeOid
%ConstructClone %Delete %DeleteExtent %DeleteId
%DispatchClassMethod %DispatchGetModified %DispatchGetProperty %DispatchMethod
%DispatchSetModified %DispatchSetMultidimProperty %DispatchSetProperty %Exists
%ExistsId %Extends %GUID %GUIDSet
%GetLock %GetParameter %GetSwizzleObject %Id
%InsertBatch %IsA %IsModified %IsNull
%KillExtent %KillExtentData %LoadFromMemory %LockExtent
%LockId %New %NormalizeObject %ObjectIsNull
%ObjectModified %Oid %OnAfterSave %OnBeforeAddToSync
%OnDetermineClass %Open %OpenId %OriginalNamespace
%PackageName %PhysicalAddress %PurgeIndices %Reload
%RemoveFromSaveSet %ResolveConcurrencyConflict %RollBack %Save
%SaveDirect %SaveIndices %SerializeObject %SetModified
%SortBegin %SortEnd %SyncObjectIn %SyncTransport
%UnlockExtent %UnlockId %ValidateIndices %ValidateObject
EffQueryGet FolderNameGet GetDataMartName GetEffQuery
GetMetricStr GetTableClass MetricStrGet TableClassGet
XMLDTD XMLExport XMLExportToStream XMLExportToString
XMLNew XMLSchema XMLSchemaNamespace XMLSchemaType


• property ChartAttrib as %Library.Stream;
• property ChartFormat as %String(MAXLEN=32000,TRUNCATE=1);
• property ColCustomGroup as %String(MAXLEN=32000,TRUNCATE=1);
• property ColMeasure as %String(MAXLEN=32000,TRUNCATE=1);
• property DataMart as %String(MAXLEN=2000,TRUNCATE=1);
• property DataMartName as %String(TRUNCATE=1) [ Calculated ];
• property DrillDownReport as %String(MAXLEN=32000,TRUNCATE=1);
• property EffQuery as %String(TRUNCATE=1) [ Calculated ];
• property ExcelDrillDownInfo as %String(TRUNCATE=1);
• property ExcelFilterInfo as %String(TRUNCATE=1);
• property ExcelLayout as %String(TRUNCATE=1);
• property Folder as %String(TRUNCATE=1);
• property FolderName as %String(TRUNCATE=1) [ Calculated ];
• property HideColumns as %String(MAXLEN=32000,TRUNCATE=1);
• property HideRows as %String(MAXLEN=32000,TRUNCATE=1);
• property LinkReport as %String(MAXLEN=32000,TRUNCATE=1);
• property MOLAPClass as %String(TRUNCATE=1);
• property MOLAPColumn as %String(TRUNCATE=1);
• property MetricStr as %String(TRUNCATE=1) [ Calculated ];
• property Metrics as %String(MAXLEN=32000,TRUNCATE=1);
• property NestedReport as %String(MAXLEN=32000,TRUNCATE=1);
• property ObjectOwner as %BI.Users;
• property PivotCat as %String(TRUNCATE=1);
• property PivotClass as %String(TRUNCATE=1);
• property PivotName as %String(MAXLEN=300,TRUNCATE=1) [ Required ];
• property PivotNotes as %String(MAXLEN=32000,TRUNCATE=0);
• property QueryCom as %String(MAXLEN=2000,TRUNCATE=1);
• property QueryVariable as %String(MAXLEN=2000,TRUNCATE=1);
• property RankRemain as %String(MAXLEN=2000,TRUNCATE=1);
• property Ranking as %String(MAXLEN=2000,TRUNCATE=1);
• property RecreateMOLAPClass as %Boolean;
• property RowAggregateOption as %Integer;
• property RowCustomGroup as %String(MAXLEN=32000,TRUNCATE=1);
• property RowMeasure as %String(MAXLEN=32000,TRUNCATE=1);
• property SQLClause as %String(MAXLEN=32000,TRUNCATE=1);
• property ShowColumnAvg as %Boolean;
• property ShowColumnTotal as %Boolean;
• property StaticReport as %Boolean;
• property SuppressNullRows as %Boolean;
• property SyncOption as %Integer;
• property TableClass as %String(TRUNCATE=1) [ Calculated ];
• property TableQuery as %String(MAXLEN=32000,TRUNCATE=1);
• property UnionReport as %String(MAXLEN=32000,TRUNCATE=1);


• final method %OnAfterSave(insert As %Boolean) as %Status
This callback method is invoked by the %Save method to provide notification that the object is being saved. It is called after the object's data has been successfully written to disk.

insert will be set to 1 if this object is being saved for the first time.

If this method returns an error then the call to %Save will fail.

• method EffQueryGet() as %String
This is a Get accessor method for the EffQuery property.
• method FolderNameGet() as %String
This is a Get accessor method for the FolderName property.
• classmethod GetDataMartName(dmid As %String) as %String
• classmethod GetEffQuery(dmid As %String, tabquery As %String) as %String
• classmethod GetMetricStr(dmid As %String, iMetric As %String) as %String
• classmethod GetTableClass(dmid As %String) as %String
• method MetricStrGet() as %String
This is a Get accessor method for the MetricStr property.
• method TableClassGet() as %String
This is a Get accessor method for the TableClass property.


• query ByTableClass(Class As %String)
SQL Query :
FROM %BI.PivotTable
WHERE TableClass=:Class
• query FolderAll(iFolder As %String)
SQL Query :
FROM %BI.PivotTable
WHERE Folder=:iFolder
ORDER BY PivotName
• query ListAll()
SQL Query :
SELECT ID,PivotName,DataMartName,Folder,PivotNotes
FROM %BI.PivotTable ORDER BY PivotName


•index (Folder on Folder:Exact);
•index (MOLAP on MOLAPClass:Exact);
•index (SYNC on PivotClass:Exact,SyncOption:Exact) [Data = MOLAPClass];