persistent class %BI.PivotTable
extends %Persistent, %XML.Adaptor
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
:
SELECT ID,PivotName
FROM %BI.PivotTable
WHERE TableClass=:Class
query FolderAll(iFolder As %String)
SQL Query
:
SELECT ID,PivotName
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];