脚本目录：
D:\Oracle\Middleware\EPMSystem11R1\products\Foundation\BPMA\Server\conf\Oracle_Create_Interface_Tables.sql
------------------------------------------------------------------------
-- Company : Hyperion Solutions
-- Project : BPM Architect
-- Module : Interface Tables
-- Author : Bhanu Prakash Ayyadevara
--
-- Date Created : Friday, August 18, 2006 16:18:38
-- Target DBMS : Oracle 9.2
------------------------------------------------------------------------
-- Create static tables
CREATE TABLE IM_Dimension(
i_Load_ID NUMBER(38, 0),
c_Dimension_Name NVARCHAR2(150) NOT NULL,
c_Dimension_Class_Name NVARCHAR2(255) NOT NULL,
c_Member_Table_Name NVARCHAR2(255),
c_Hierarchy_Table_Name NVARCHAR2(255),
c_Property_Array_Table_Name NVARCHAR2(255),
c_Dim_Property_Table_Name NVARCHAR2(255),
CONSTRAINT PK_IntDim PRIMARY KEY (c_Dimension_Name)
)
;
CREATE TABLE IM_Dimension_Association(
i_Load_ID NUMBER(38, 0),
c_Base_Dimension NVARCHAR2(255) NOT NULL,
c_Property NVARCHAR2(255) NOT NULL,
c_Target_Dimension NVARCHAR2(255) NOT NULL
)
;
CREATE TABLE IM_Load_Info(
i_Load_ID NUMBER(38, 0) NOT NULL,
c_Source_System NVARCHAR2(255) NOT NULL,
c_User_Last_Updated NVARCHAR2(255) NOT NULL,
d_Date_Last_Updated TIMESTAMP(6) NOT NULL,
c_Last_Update_Login NVARCHAR2(255) NOT NULL,
CONSTRAINT PK_IntLoad PRIMARY KEY (i_Load_ID)
)
;
-- Create HS_Scenario_Member table
create table HS_Scenario_Member(
LoadID NUMBER(38, 0) NULL,
Name nvarchar2(255) NOT NULL,
Description nvarchar2(255) NULL,
ConsolidateYTD NUMBER(1, 0) NULL,
DataType nvarchar2(50) NULL,
DefaultFrequency nvarchar2(255) NULL,
DefaultParent nvarchar2(255) NULL,
DefaultView nvarchar2(50) NULL,
DefFreqForICTrans nvarchar2(255) NULL,
EnableDataAudit nvarchar2(50) NULL,
EnableProcessManagement NUMBER(1, 0) NULL,
HfmEnableProcessManagement nvarchar2(50) NULL,
EndPeriod nvarchar2(255) NULL,
EndYear nvarchar2(255) NULL,
ExchangeRateTable nvarchar2(255) NULL,
MaximumReviewLevel NUMBER(38, 0) NULL,
BSOMemberFormula nvarchar2(255) NULL,
SecurityClass nvarchar2(255) NULL,
SmartList nvarchar2(255) NULL,
StartPeriod nvarchar2(255) NULL,
StartYear nvarchar2(255) NULL,
UDA nvarchar2(255) NULL,
UseBegBalance NUMBER(1, 0) NULL,
UserDefined1 nvarchar2(255) NULL,
UserDefined2 nvarchar2(255) NULL,
UserDefined3 nvarchar2(255) NULL,
UsesLineItems NUMBER(1, 0) NULL,
ZeroViewForAdj nvarchar2(50) NULL,
ZeroViewForNonAdj nvarchar2(50) NULL)
;
-- Create HS_Scenario_Hierarchy table
create table HS_Scenario_Hierarchy(
LoadID NUMBER(38, 0) NULL,
Parent nvarchar2(255) NOT NULL,
Child nvarchar2(255) NOT NULL,
IsPrimary NUMBER(1, 0) NOT NULL,
SortOrder NUMBER(38, 0) NULL,
DataStorage nvarchar2(50) NULL,
MemberValidForCapex NUMBER(1, 0) NULL,
MemberValidForPlan1 NUMBER(1, 0) NULL,
MemberValidForPlan2 NUMBER(1, 0) NULL,
MemberValidForPlan3 NUMBER(1, 0) NULL,
MemberValidForWorkforce NUMBER(1, 0) NULL)
;
-- Create HS_Scenario_PropertyArray table
create table HS_Scenario_PropertyArray(
LoadID NUMBER(38, 0) NULL,
Property nvarchar2(255) NOT NULL,
Name nvarchar2(255) NOT NULL,
Key nvarchar2(255) NOT NULL,
Value nvarchar2(255) NULL)
;
-- Create HS_Scenario_Property table
create table HS_Scenario_Property(
LoadID NUMBER(38, 0) NULL,
DimensionAlias nvarchar2(255) NULL,
DimDataStorage nvarchar2(50) NULL,
DimValidForCapex NUMBER(1, 0) NULL,
DimValidForPlan1 NUMBER(1, 0) NULL,
DimValidForPlan2 NUMBER(1, 0) NULL,
DimValidForPlan3 NUMBER(1, 0) NULL,
DimValidForWorkforce NUMBER(1, 0) NULL,
EnumOrder1 NUMBER(38, 0) NULL,
EnumOrder2 NUMBER(38, 0) NULL,
EnumOrder3 NUMBER(38, 0) NULL,
EnumOrderCapex NUMBER(38, 0) NULL,
EnumOrderWF NUMBER(38, 0) NULL,
Plan1Density nvarchar2(50) NULL,
Plan2Density nvarchar2(50) NULL,
Plan3Density nvarchar2(50) NULL,
WorkforceDensity nvarchar2(50) NULL,
CapexDensity nvarchar2(50) NULL)
;
-- Create HS_Year_Member table
create table HS_Year_Member(
LoadID NUMBER(38, 0) NULL,
Name nvarchar2(255) NOT NULL,
Description nvarchar2(255) NULL,
DataType nvarchar2(50) NULL,
BSOMemberFormula nvarchar2(255) NULL,
SmartList nvarchar2(255) NULL,
UDA nvarchar2(255) NULL)
;
-- Create HS_Year_Hierarchy table
create table HS_Year_Hierarchy(
LoadID NUMBER(38, 0) NULL,
Parent nvarchar2(255) NOT NULL,
Child nvarchar2(255) NOT NULL,
IsPrimary NUMBER(1, 0) NOT NULL,
SortOrder NUMBER(38, 0) NULL,
DataStorage nvarchar2(50) NULL,
MemberValidForCapex NUMBER(1, 0) NULL,
MemberValidForPlan1 NUMBER(1, 0) NULL,
MemberValidForPlan2 NUMBER(1, 0) NULL,
MemberValidForPlan3 NUMBER(1, 0) NULL,
MemberValidForWorkforce NUMBER(1, 0) NULL)
;
-- Create HS_Year_PropertyArray table
create table HS_Year_PropertyArray(
LoadID NUMBER(38, 0) NULL,
Property nvarchar2(255) NOT NULL,
Name nvarchar2(255) NOT NULL,
Key nvarchar2(255) NOT NULL,
Value nvarchar2(255) NULL)
;
-- Create HS_Year_Property table
create table HS_Year_Property(
LoadID NUMBER(38, 0) NULL,
DimensionAlias nvarchar2(255) NULL,
DimDataStorage nvarchar2(50) NULL,
DimValidForCapex NUMBER(1, 0) NULL,
DimValidForPlan1 NUMBER(1, 0) NULL,
DimValidForPlan2 NUMBER(1, 0) NULL,
DimValidForPlan3 NUMBER(1, 0) NULL,
DimValidForWorkforce NUMBER(1, 0) NULL,
EnumOrder1 NUMBER(38, 0) NULL,
EnumOrder2 NUMBER(38, 0) NULL,
EnumOrder3 NUMBER(38, 0) NULL,
EnumOrderCapex NUMBER(38, 0) NULL,
EnumOrderWF NUMBER(38, 0) NULL,
Plan1Density nvarchar2(50) NULL,
Plan2Density nvarchar2(50) NULL,
Plan3Density nvarchar2(50) NULL,
WorkforceDensity nvarchar2(50) NULL,
CapexDensity nvarchar2(50) NULL)
;
-- Create HS_Period_Member table
create table HS_Period_Member(
LoadID NUMBER(38, 0) NULL,
Name nvarchar2(255) NOT NULL,
Description nvarchar2(255) NULL,
DataType nvarchar2(50) NULL,
DefaultParent nvarchar2(255) NULL,
DTSGeneration NUMBER(38, 0) NULL,
DTSEnabled NUMBER(1, 0) NULL,
BSOMemberFormula nvarchar2(255) NULL,
SmartList nvarchar2(255) NULL,
TwoPassCalc NUMBER(1, 0) NULL,
UDA nvarchar2(255) NULL)
;
-- Create HS_Period_Hierarchy table
create table HS_Period_Hierarchy(
LoadID NUMBER(38, 0) NULL,
Parent nvarchar2(255) NOT NULL,
Child nvarchar2(255) NOT NULL,
IsPrimary NUMBER(1, 0) NOT NULL,
SortOrder NUMBER(38, 0) NULL,
CapexAggregation nvarchar2(50) NULL,
DataStorage nvarchar2(50) NULL,
MemberValidForCapex NUMBER(1, 0) NULL,
MemberValidForPlan1 NUMBER(1, 0) NULL,
MemberValidForPlan2 NUMBER(1, 0) NULL,
MemberValidForPlan3 NUMBER(1, 0) NULL,
MemberValidForWorkforce NUMBER(1, 0) NULL,
PeriodType nvarchar2(50) NULL,
Plan1Aggregation nvarchar2(50) NULL,
Plan2Aggregation nvarchar2(50) NULL,
Plan3Aggregation nvarchar2(50) NULL,
WorkforceAggregation nvarchar2(50) NULL)
;
-- Create HS_Period_PropertyArray table
create table HS_Period_PropertyArray(
LoadID NUMBER(38, 0) NULL,
Property nvarchar2(255) NOT NULL,
Name nvarchar2(255) NOT NULL,
Key nvarchar2(255) NOT NULL,
Value nvarchar2(255) NULL)
;
-- Create HS_Period_Property table
create table HS_Period_Property(
LoadID NUMBER(38, 0) NULL,
DimensionAlias nvarchar2(255) NULL,
DimDataStorage nvarchar2(50) NULL,
DimValidForCapex NUMBER(1, 0) NULL,
DimValidForPlan1 NUMBER(1, 0) NULL,
DimValidForPlan2 NUMBER(1, 0) NULL,
DimValidForPlan3 NUMBER(1, 0) NULL,
DimValidForWorkforce NUMBER(1, 0) NULL,
EnumOrder1 NUMBER(38, 0) NULL,
EnumOrder2 NUMBER(38, 0) NULL,
EnumOrder3 NUMBER(38, 0) NULL,
EnumOrderCapex NUMBER(38, 0) NULL,
EnumOrderWF NUMBER(38, 0) NULL,
Plan1Density nvarchar2(50) NULL,
Plan2Density nvarchar2(50) NULL,
Plan3Density nvarchar2(50) NULL,
WorkforceDensity nvarchar2(50) NULL,
CapexDensity nvarchar2(50) NULL)
;
-- Create HS_View_Member table
create table HS_View_Member(
LoadID NUMBER(38, 0) NULL,
Name nvarchar2(255) NOT NULL,
Description nvarchar2(255) NULL)
;
-- Create HS_View_Hierarchy table
create table HS_View_Hierarchy(
LoadID NUMBER(38, 0) NULL,
Parent nvarchar2(255) NOT NULL,
Child nvarchar2(255) NOT NULL,
IsPrimary NUMBER(1, 0) NOT NULL,
SortOrder NUMBER(38, 0) NULL)
;
-- Create HS_View_PropertyArray table
create table HS_View_PropertyArray(
LoadID NUMBER(38, 0) NULL,
Property nvarchar2(255) NOT NULL,
Name nvarchar2(255) NOT NULL,
Key nvarchar2(255) NOT NULL,
Value nvarchar2(255) NULL)
;
-- Create HS_View_Property table
create table HS_View_Property(
LoadID NUMBER(38, 0) NULL,
DimensionAlias nvarchar2(255) NULL)
;
-- Create HS_Entity_Member table
create table HS_Entity_Member(
LoadID NUMBER(38, 0) NULL,
Name nvarchar2(255) NOT NULL,
Description nvarchar2(255) NULL,
AllowAdjFromChildren NUMBER(1, 0) NULL,
AllowAdjs NUMBER(1, 0) NULL,
Currency nvarchar2(255) NULL,
DataType nvarchar2(50) NULL,
DefaultParent nvarchar2(255) NULL,
HoldingCompany nvarchar2(255) NULL,
IsICP nvarchar2(50) NULL,
BSOMemberFormula nvarchar2(255) NULL,
SecurityAsPartner nvarchar2(255) NULL,
SecurityClass nvarchar2(255) NULL,
SmartList nvarchar2(255) NULL,
TwoPassCalc NUMBER(1, 0) NULL,
UDA nvarchar2(255) NULL,
UserDefined1 nvarchar2(255) NULL,
UserDefined2 nvarchar2(255) NULL,
UserDefined3 nvarchar2(255) NULL)
;
-- Create HS_Entity_Hierarchy table
create table HS_Entity_Hierarchy(
LoadID NUMBER(38, 0) NULL,
Parent nvarchar2(255) NOT NULL,
Child nvarchar2(255) NOT NULL,
IsPrimary NUMBER(1, 0) NOT NULL,
SortOrder NUMBER(38, 0) NULL,
CapexAggregation nvarchar2(50) NULL,
DataStorage nvarchar2(50) NULL,
MemberValidForCapex NUMBER(1, 0) NULL,
MemberValidForPlan1 NUMBER(1, 0) NULL,
MemberValidForPlan2 NUMBER(1, 0) NULL,
MemberValidForPlan3 NUMBER(1, 0) NULL,
MemberValidForWorkforce NUMBER(1, 0) NULL,
Plan1Aggregation nvarchar2(50) NULL,
Plan2Aggregation nvarchar2(50) NULL,
Plan3Aggregation nvarchar2(50) NULL,
WorkforceAggregation nvarchar2(50) NULL)
;
-- Create HS_Entity_PropertyArray table
create table HS_Entity_PropertyArray(
LoadID NUMBER(38, 0) NULL,
Property nvarchar2(255) NOT NULL,
Name nvarchar2(255) NOT NULL,
Key nvarchar2(255) NULL,
Value nvarchar2(255) NULL)
;
-- Create HS_Entity_Property table
create table HS_Entity_Property(
LoadID NUMBER(38, 0) NULL,
DimensionAlias nvarchar2(255) NULL,
DimDataStorage nvarchar2(50) NULL,
DimValidForCapex NUMBER(1, 0) NULL,
DimValidForPlan1 NUMBER(1, 0) NULL,
DimValidForPlan2 NUMBER(1, 0) NULL,
DimValidForPlan3 NUMBER(1, 0) NULL,
DimValidForWorkforce NUMBER(1, 0) NULL,
EnumOrder1 NUMBER(38, 0) NULL,
EnumOrder2 NUMBER(38, 0) NULL,
EnumOrder3 NUMBER(38, 0) NULL,
EnumOrderCapex NUMBER(38, 0) NULL,
EnumOrderWF NUMBER(38, 0) NULL,
Plan1Density nvarchar2(50) NULL,
Plan2Density nvarchar2(50) NULL,
Plan3Density nvarchar2(50) NULL,
WorkforceDensity nvarchar2(50) NULL,
CapexDensity nvarchar2(50) NULL)
;
-- Create HS_Value_Member table
create table HS_Value_Member(
LoadID NUMBER(38, 0) NULL,
Name nvarchar2(255) NOT NULL,
Description nvarchar2(255) NULL,
DefaultParent nvarchar2(255) NULL)
;
-- Create HS_Value_Hierarchy table
create table HS_Value_Hierarchy(
LoadID NUMBER(38, 0) NULL,
Parent nvarchar2(255) NOT NULL,
Child nvarchar2(255) NOT NULL,
IsPrimary NUMBER(1, 0) NOT NULL,
SortOrder NUMBER(38, 0) NULL)
;
-- Create HS_Value_PropertyArray table
create table HS_Value_PropertyArray(
LoadID NUMBER(38, 0) NULL,
Property nvarchar2(255) NOT NULL,
Name nvarchar2(255) NOT NULL,
Key nvarchar2(255) NOT NULL,
Value nvarchar2(255) NULL)
;
-- Create HS_Value_Property table
create table HS_Value_Property(
LoadID NUMBER(38, 0) NULL,
DimensionAlias nvarchar2(255) NULL)
;
-- Create HS_Account_Member table
create table HS_Account_Member(
LoadID NUMBER(38, 0) NULL,
Name nvarchar2(255) NOT NULL,
Description nvarchar2(255) NULL,
AccountType nvarchar2(50) NULL,
CalcAttribute nvarchar2(255) NULL,
Consolidation nvarchar2(50) NULL,
ConsolidationAccountType nvarchar2(50) NULL,
CurrencyCategory nvarchar2(255) NULL,
CurrencyConversion nvarchar2(50) NULL,
CustomTopMemberProducts nvarchar2(255) NULL,
CustomTopMemberCustomers nvarchar2(255) NULL,
CustomTopMemberCustom3 nvarchar2(255) NULL,
CustomTopMemberFlow nvarchar2(255) NULL,
DataType nvarchar2(50) NULL,
DefaultParent nvarchar2(255) NULL,
EnableCustomAggrProducts NUMBER(1, 0) NULL,
EnableCustomAggrCustomers NUMBER(1, 0) NULL,
EnableCustomAggrCustom3 NUMBER(1, 0) NULL,
EnableCustomAggrFlow NUMBER(1, 0) NULL,
EnableDataAudit nvarchar2(50) NULL,
FullyQualifiedSharedMember nvarchar2(255) NULL,
HierarchyType nvarchar2(50) NULL,
ICPTopMember nvarchar2(255) NULL,
ICPTopMemberString nvarchar2(255) NULL,
IsCalculated NUMBER(1, 0) NULL,
IsConsolidated NUMBER(1, 0) NULL,
IsICP nvarchar2(50) NULL,
BSOMemberFormula nvarchar2(255) NULL,
MemberSolveOrder NUMBER(38, 0) NULL,
NumDecimalPlaces NUMBER(38, 0) NULL,
PlugAccount nvarchar2(255) NULL,
PrimaryLevelWeighting nvarchar2(50) NULL,
SecurityClass nvarchar2(255) NULL,
SkipValue nvarchar2(50) NULL,
SmartList nvarchar2(255) NULL,
SubmissionGroup NUMBER(38, 0) NULL,
TimeBalance nvarchar2(50) NULL,
TwoPassCalc NUMBER(1, 0) NULL,
UDA nvarchar2(255) NULL,
UserDefined1 nvarchar2(255) NULL,
UserDefined2 nvarchar2(255) NULL,
UserDefined3 nvarchar2(255) NULL,
UsesLineItems NUMBER(1, 0) NULL,
VarianceReporting nvarchar2(50) NULL,
XBRLTags nvarchar2(255) NULL)
;
-- Create HS_Account_Hierarchy table
create table HS_Account_Hierarchy(
LoadID NUMBER(38, 0) NULL,
Parent nvarchar2(255) NOT NULL,
Child nvarchar2(255) NOT NULL,
IsPrimary NUMBER(1, 0) NOT NULL,
SortOrder NUMBER(38, 0) NULL,
CapexAggregation nvarchar2(50) NULL,
DataStorage nvarchar2(50) NULL,
MemberValidForCapex NUMBER(1, 0) NULL,
MemberValidForPlan1 NUMBER(1, 0) NULL,
MemberValidForPlan2 NUMBER(1, 0) NULL,
MemberValidForPlan3 NUMBER(1, 0) NULL,
MemberValidForWorkforce NUMBER(1, 0) NULL,
Plan1Aggregation nvarchar2(50) NULL,
Plan2Aggregation nvarchar2(50) NULL,
Plan3Aggregation nvarchar2(50) NULL,
ExchangeRateType nvarchar2(50) NULL,
SourcePlanType nvarchar2(50) NULL,
WorkforceAggregation nvarchar2(50) NULL)
;
-- Create HS_Account_PropertyArray table
create table HS_Account_PropertyArray(
LoadID NUMBER(38, 0) NULL,
Property nvarchar2(255) NOT NULL,
Name nvarchar2(255) NOT NULL,
Key nvarchar2(255) NOT NULL,
Value nvarchar2(255) NULL)
;
-- Create HS_Account_Property table
create table HS_Account_Property(
LoadID NUMBER(38, 0) NULL,
DimensionAlias nvarchar2(255) NULL,
CommentDuplicate nvarchar2(255) NULL,
AllowDuplicatesInDimension NUMBER(1, 0) NULL,
ConsolidationDuplicate nvarchar2(50) NULL,
DimDataStorage nvarchar2(50) NULL,
DimensionHierarchyType nvarchar2(50) NULL,
DimensionSolveOrder NUMBER(38, 0) NULL,
DimValidForCapex NUMBER(1, 0) NULL,
DimValidForPlan1 NUMBER(1, 0) NULL,
DimValidForPlan2 NUMBER(1, 0) NULL,
DimValidForPlan3 NUMBER(1, 0) NULL,
DimValidForWorkforce NUMBER(1, 0) NULL,
EnumOrder1 NUMBER(38, 0) NULL,
EnumOrder2 NUMBER(38, 0) NULL,
EnumOrder3 NUMBER(38, 0) NULL,
EnumOrderCapex NUMBER(38, 0) NULL,
EnumOrderWF NUMBER(38, 0) NULL,
BSOMemberFormulaDuplicate nvarchar2(255) NULL,
MemberSolveOrderDuplicate NUMBER(38, 0) NULL,
Plan1Density nvarchar2(50) NULL,
Plan2Density nvarchar2(50) NULL,
Plan3Density nvarchar2(50) NULL,
WorkforceDensity nvarchar2(50) NULL,
CapexDensity nvarchar2(50) NULL,
SkipValueDuplicate nvarchar2(50) NULL,
TimeBalanceDuplicate nvarchar2(50) NULL,
TwoPassCalcDuplicate NUMBER(1, 0) NULL,
UDADuplicate nvarchar2(255) NULL,
VarianceReportingDuplicate nvarchar2(50) NULL)
;
-- Create HS_ICP_Member table
create table HS_ICP_Member(
LoadID NUMBER(38, 0) NULL,
Name nvarchar2(255) NOT NULL,
Description nvarchar2(255) NULL,
DefaultParent nvarchar2(255) NULL,
SecurityClass nvarchar2(255) NULL,
SubmissionGroup NUMBER(38, 0) NULL)
;
-- Create HS_ICP_Hierarchy table
create table HS_ICP_Hierarchy(
LoadID NUMBER(38, 0) NULL,
Parent nvarchar2(255) NOT NULL,
Child nvarchar2(255) NOT NULL,
IsPrimary NUMBER(1, 0) NOT NULL,
SortOrder NUMBER(38, 0) NULL)
;
-- Create HS_ICP_PropertyArray table
create table HS_ICP_PropertyArray(
LoadID NUMBER(38, 0) NULL,
Property nvarchar2(255) NOT NULL,
Name nvarchar2(255) NOT NULL,
Key nvarchar2(255) NOT NULL,
Value nvarchar2(255) NULL)
;
-- Create HS_ICP_Property table
create table HS_ICP_Property(
LoadID NUMBER(38, 0) NULL,
DimensionAlias nvarchar2(255) NULL)
;
-- Create HS_Generic_Member table
create table HS_Generic_Member(
LoadID NUMBER(38, 0) NULL,
Name nvarchar2(255) NOT NULL,
Description nvarchar2(255) NULL,
Consolidation nvarchar2(50) NULL,
DataType nvarchar2(50) NULL,
DefaultParent nvarchar2(255) NULL,
FullyQualifiedSharedMember nvarchar2(255) NULL,
HierarchyType nvarchar2(50) NULL,
IsCalculated NUMBER(1, 0) NULL,
BSOMemberFormula nvarchar2(255) NULL,
MemberSolveOrder NUMBER(38, 0) NULL,
PrimaryLevelWeighting nvarchar2(50) NULL,
SecurityClass nvarchar2(255) NULL,
SmartList nvarchar2(255) NULL,
SubmissionGroup NUMBER(38, 0) NULL,
SwitchSignForFlow NUMBER(1, 0) NULL,
SwitchTypeForFlow NUMBER(1, 0) NULL,
TwoPassCalc NUMBER(1, 0) NULL,
UDA nvarchar2(255) NULL,
UserDefined1 nvarchar2(255) NULL,
UserDefined2 nvarchar2(255) NULL,
UserDefined3 nvarchar2(255) NULL)
;
-- Create HS_Generic_Hierarchy table
create table HS_Generic_Hierarchy(
LoadID NUMBER(38, 0) NULL,
Parent nvarchar2(255) NOT NULL,
Child nvarchar2(255) NOT NULL,
IsPrimary NUMBER(1, 0) NOT NULL,
SortOrder NUMBER(38, 0) NULL,
AggregationWeight float NULL,
CapexAggregation nvarchar2(50) NULL,
DataStorage nvarchar2(50) NULL,
MemberValidForCapex NUMBER(1, 0) NULL,
MemberValidForPlan1 NUMBER(1, 0) NULL,
MemberValidForPlan2 NUMBER(1, 0) NULL,
MemberValidForPlan3 NUMBER(1, 0) NULL,
MemberValidForWorkforce NUMBER(1, 0) NULL,
Plan1Aggregation nvarchar2(50) NULL,
Plan2Aggregation nvarchar2(50) NULL,
Plan3Aggregation nvarchar2(50) NULL,
WorkforceAggregation nvarchar2(50) NULL)
;
-- Create HS_Generic_PropertyArray table
create table HS_Generic_PropertyArray(
LoadID NUMBER(38, 0) NULL,
Property nvarchar2(255) NOT NULL,
Name nvarchar2(255) NOT NULL,
Key nvarchar2(255) NOT NULL,
Value nvarchar2(255) NULL)
;
-- Create HS_Generic_Property table
create table HS_Generic_Property(
LoadID NUMBER(38, 0) NULL,
DimensionAlias nvarchar2(255) NULL,
AllowDuplicatesInDimension NUMBER(1, 0) NULL,
ApplySecurity NUMBER(1, 0) NULL,
CommentDuplicate nvarchar2(255) NULL,
ConsolidationDuplicate nvarchar2(50) NULL,
CustomDimensionId nvarchar2(50) NULL,
DimDataStorage nvarchar2(50) NULL,
DimensionHierarchyType nvarchar2(50) NULL,
DimensionSolveOrder NUMBER(38, 0) NULL,
DimValidForCapex NUMBER(1, 0) NULL,
DimValidForPlan1 NUMBER(1, 0) NULL,
DimValidForPlan2 NUMBER(1, 0) NULL,
DimValidForPlan3 NUMBER(1, 0) NULL,
DimValidForWorkforce NUMBER(1, 0) NULL,
EnumOrder1 NUMBER(38, 0) NULL,
EnumOrder2 NUMBER(38, 0) NULL,
EnumOrder3 NUMBER(38, 0) NULL,
EnumOrderCapex NUMBER(38, 0) NULL,
EnumOrderWF NUMBER(38, 0) NULL,
BSOMemberFormulaDuplicate nvarchar2(255) NULL,
Plan1Density nvarchar2(50) NULL,
Plan2Density nvarchar2(50) NULL,
Plan3Density nvarchar2(50) NULL,
WorkforceDensity nvarchar2(50) NULL,
CapexDensity nvarchar2(50) NULL,
TwoPassCalcDuplicate NUMBER(1, 0) NULL,
UDADuplicate nvarchar2(255) NULL)
;
-- Create HS_ConsolMethod_Member table
create table HS_ConsolMethod_Member(
LoadID NUMBER(38, 0) NULL,
Name nvarchar2(255) NOT NULL,
Description nvarchar2(255) NULL,
Control nvarchar2(50) NULL,
IsHoldingMethod NUMBER(1, 0) NULL,
PercentConsol nvarchar2(50) NULL,
PercentConsolValue NUMBER(38, 0) NULL,
ToPercentControl NUMBER(38, 0) NULL,
ToPercentControlComp nvarchar2(50) NULL,
UsedByCalcRoutine NUMBER(1, 0) NULL)
;
-- Create HS_ConsolMethod_Hierarchy table
create table HS_ConsolMethod_Hierarchy(
LoadID NUMBER(38, 0) NULL,
Parent nvarchar2(255) NOT NULL,
Child nvarchar2(255) NOT NULL,
IsPrimary NUMBER(1, 0) NOT NULL,
SortOrder NUMBER(38, 0) NULL)
;
-- Create HS_ConsolMethod_PropertyArray table
create table HS_ConsolMethod_PropertyArray(
LoadID NUMBER(38, 0) NULL,
Property nvarchar2(255) NOT NULL,
Name nvarchar2(255) NOT NULL,
Key nvarchar2(255) NOT NULL,
Value nvarchar2(255) NULL)
;
-- Create HS_ConsolMethod_Property table
create table HS_ConsolMethod_Property(
LoadID NUMBER(38, 0) NULL,
DimensionAlias nvarchar2(255) NULL)
;
-- Create HS_Currency_Member table
create table HS_Currency_Member(
LoadID NUMBER(38, 0) NULL,
Name nvarchar2(255) NOT NULL,
Description nvarchar2(255) NULL,
CurrencyCode nvarchar2(255) NULL,
DataType nvarchar2(50) NULL,
DecimalSep nvarchar2(50) NULL,
DisplayInICT NUMBER(1, 0) NULL,
FullyQualifiedSharedMember nvarchar2(255) NULL,
BSOMemberFormula nvarchar2(255) NULL,
NegativeColor nvarchar2(50) NULL,
NegativeSign nvarchar2(50) NULL,
ReptCurrency NUMBER(1, 0) NULL,
Scale nvarchar2(50) NULL,
SmartList nvarchar2(255) NULL,
Symbol nvarchar2(255) NULL,
ThousandSep nvarchar2(50) NULL,
TranslationOperator nvarchar2(50) NULL,
TriangulationCurrency nvarchar2(255) NULL,
TwoPassCalc NUMBER(1, 0) NULL,
UDA nvarchar2(255) NULL)
;
-- Create HS_Currency_Hierarchy table
create table HS_Currency_Hierarchy(
LoadID NUMBER(38, 0) NULL,
Parent nvarchar2(255) NOT NULL,
Child nvarchar2(255) NOT NULL,
IsPrimary NUMBER(1, 0) NOT NULL,
SortOrder NUMBER(38, 0) NULL,
DataStorage nvarchar2(50) NULL,
MemberValidForCapex NUMBER(1, 0) NULL,
MemberValidForPlan1 NUMBER(1, 0) NULL,
MemberValidForPlan2 NUMBER(1, 0) NULL,
MemberValidForPlan3 NUMBER(1, 0) NULL,
MemberValidForWorkforce NUMBER(1, 0) NULL)
;
-- Create HS_Currency_PropertyArray table
create table HS_Currency_PropertyArray(
LoadID NUMBER(38, 0) NULL,
Property nvarchar2(255) NOT NULL,
Name nvarchar2(255) NOT NULL,
Key nvarchar2(255) NOT NULL,
Value nvarchar2(255) NULL)
;
-- Create HS_Currency_Property table
create table HS_Currency_Property(
LoadID NUMBER(38, 0) NULL,
DimensionAlias nvarchar2(255) NULL,
AllowDuplicatesInDimension NUMBER(1, 0) NULL,
CommentDuplicate nvarchar2(255) NULL,
ConsolidationDuplicate nvarchar2(50) NULL,
DimDataStorage nvarchar2(50) NULL,
DimValidForCapex NUMBER(1, 0) NULL,
DimValidForPlan1 NUMBER(1, 0) NULL,
DimValidForPlan2 NUMBER(1, 0) NULL,
DimValidForPlan3 NUMBER(1, 0) NULL,
DimValidForWorkforce NUMBER(1, 0) NULL,
EnumOrder1 NUMBER(38, 0) NULL,
EnumOrder2 NUMBER(38, 0) NULL,
EnumOrder3 NUMBER(38, 0) NULL,
EnumOrderCapex NUMBER(38, 0) NULL,
EnumOrderWF NUMBER(38, 0) NULL,
BSOMemberFormulaDuplicate nvarchar2(255) NULL,
Plan1Density nvarchar2(50) NULL,
Plan2Density nvarchar2(50) NULL,
Plan3Density nvarchar2(50) NULL,
WorkforceDensity nvarchar2(50) NULL,
CapexDensity nvarchar2(50) NULL,
TwoPassCalcDuplicate NUMBER(1, 0) NULL,
UDADuplicate nvarchar2(255) NULL)
;
-- Create HS_SecurityClass_Member table
create table HS_SecurityClass_Member(
LoadID NUMBER(38, 0) NULL,
Name nvarchar2(255) NOT NULL,
Description nvarchar2(255) NULL)
;
-- Create HS_SecurityClass_Hierarchy table
create table HS_SecurityClass_Hierarchy(
LoadID NUMBER(38, 0) NULL,
Parent nvarchar2(255) NOT NULL,
Child nvarchar2(255) NOT NULL,
IsPrimary NUMBER(1, 0) NOT NULL,
SortOrder NUMBER(38, 0) NULL)
;
-- Create HS_SecurityClass_PropertyArray table
create table HS_SecurityClass_PropertyArray(
LoadID NUMBER(38, 0) NULL,
Property nvarchar2(255) NOT NULL,
Name nvarchar2(255) NOT NULL,
Key nvarchar2(255) NOT NULL,
Value nvarchar2(255) NULL)
;
-- Create HS_SecurityClass_Property table
create table HS_SecurityClass_Property(
LoadID NUMBER(38, 0) NULL,
DimensionAlias nvarchar2(255) NULL)
;
-- Create HS_Alias_Member table
create table HS_Alias_Member(
LoadID NUMBER(38, 0) NULL,
Name nvarchar2(255) NOT NULL,
Description nvarchar2(255) NULL)
;
-- Create HS_Alias_Hierarchy table
create table HS_Alias_Hierarchy(
LoadID NUMBER(38, 0) NULL,
Parent nvarchar2(255) NOT NULL,
Child nvarchar2(255) NOT NULL,
IsPrimary NUMBER(1, 0) NOT NULL,
SortOrder NUMBER(38, 0) NULL)
;
-- Create HS_Alias_Property table
create table HS_Alias_Property(
LoadID NUMBER(38, 0) NULL,
DimensionAlias nvarchar2(255) NULL)
;
-- Create HS_Version_Member table
create table HS_Version_Member(
LoadID NUMBER(38, 0) NULL,
Name nvarchar2(255) NOT NULL,
Description nvarchar2(255) NULL,
DataType nvarchar2(50) NULL,
EnableProcessManagement NUMBER(1, 0) NULL,
BSOMemberFormula nvarchar2(255) NULL,
SmartList nvarchar2(255) NULL,
UDA nvarchar2(255) NULL,
VersionType nvarchar2(50) NULL)
;
-- Create HS_Version_Hierarchy table
create table HS_Version_Hierarchy(
LoadID NUMBER(38, 0) NULL,
Parent nvarchar2(255) NOT NULL,
Child nvarchar2(255) NOT NULL,
IsPrimary NUMBER(1, 0) NOT NULL,
SortOrder NUMBER(38, 0) NULL,
DataStorage nvarchar2(50) NULL,
MemberValidForCapex NUMBER(1, 0) NULL,
MemberValidForPlan1 NUMBER(1, 0) NULL,
MemberValidForPlan2 NUMBER(1, 0) NULL,
MemberValidForPlan3 NUMBER(1, 0) NULL,
MemberValidForWorkforce NUMBER(1, 0) NULL)
;
-- Create HS_Version_PropertyArray table
create table HS_Version_PropertyArray(
LoadID NUMBER(38, 0) NULL,
Property nvarchar2(255) NOT NULL,
Name nvarchar2(255) NOT NULL,
Key nvarchar2(255) NOT NULL,
Value nvarchar2(255) NULL)
;
-- Create HS_Version_Property table
create table HS_Version_Property(
LoadID NUMBER(38, 0) NULL,
DimensionAlias nvarchar2(255) NULL,
DimDataStorage nvarchar2(50) NULL,
DimValidForCapex NUMBER(1, 0) NULL,
DimValidForPlan1 NUMBER(1, 0) NULL,
DimValidForPlan2 NUMBER(1, 0) NULL,
DimValidForPlan3 NUMBER(1, 0) NULL,
DimValidForWorkforce NUMBER(1, 0) NULL,
EnumOrder1 NUMBER(38, 0) NULL,
EnumOrder2 NUMBER(38, 0) NULL,
EnumOrder3 NUMBER(38, 0) NULL,
EnumOrderCapex NUMBER(38, 0) NULL,
EnumOrderWF NUMBER(38, 0) NULL,
Plan1Density nvarchar2(50) NULL,
Plan2Density nvarchar2(50) NULL,
Plan3Density nvarchar2(50) NULL,
WorkforceDensity nvarchar2(50) NULL,
CapexDensity nvarchar2(50) NULL)
;
-- Create HS_SmartList_Member table
create table HS_SmartList_Member(
LoadID NUMBER(38, 0) NULL,
Name nvarchar2(255) NOT NULL,
Description nvarchar2(255) NULL,
ItemValue NUMBER(38, 0) NULL,
SmartListEntryLabel nvarchar2(255) NULL)
;
-- Create HS_SmartList_Hierarchy table
create table HS_SmartList_Hierarchy(
LoadID NUMBER(38, 0) NULL,
Parent nvarchar2(255) NOT NULL,
Child nvarchar2(255) NOT NULL,
IsPrimary NUMBER(1, 0) NOT NULL,
SortOrder NUMBER(38, 0) NULL)
;
-- Create HS_SmartList_PropertyArray table
create table HS_SmartList_PropertyArray(
LoadID NUMBER(38, 0) NULL,
Property nvarchar2(255) NOT NULL,
Name nvarchar2(255) NOT NULL,
Key nvarchar2(255) NOT NULL,
Value nvarchar2(255) NULL)
;
-- Create HS_SmartList_Property table
create table HS_SmartList_Property(
LoadID NUMBER(38, 0) NULL,
DimensionAlias nvarchar2(255) NULL,
DisplayOrder nvarchar2(50) NULL,
GridMissingLabelType nvarchar2(50) NULL,
Increments NUMBER(38, 0) NULL,
MissingLabel nvarchar2(255) NULL,
SmartListLabel nvarchar2(255) NULL,
StartValue NUMBER(38, 0) NULL)
;
-- Create HS_Attribute_Member table
create table HS_Attribute_Member(
LoadID NUMBER(38, 0) NULL,
Name nvarchar2(255) NOT NULL,
Description nvarchar2(255) NULL,
SecondaryLevelWeighting nvarchar2(50) NULL)
;
-- Create HS_Attribute_Hierarchy table
create table HS_Attribute_Hierarchy(
LoadID NUMBER(38, 0) NULL,
Parent nvarchar2(255) NOT NULL,
Child nvarchar2(255) NOT NULL,
IsPrimary NUMBER(1, 0) NOT NULL,
SortOrder NUMBER(38, 0) NULL,
DataStorage nvarchar2(50) NULL)
;
-- Create HS_Attribute_PropertyArray table
create table HS_Attribute_PropertyArray(
LoadID NUMBER(38, 0) NULL,
Property nvarchar2(255) NOT NULL,
Name nvarchar2(255) NOT NULL,
Key nvarchar2(255) NOT NULL,
Value nvarchar2(255) NULL)
;
-- Create HS_Attribute_Property table
create table HS_Attribute_Property(
LoadID NUMBER(38, 0) NULL,
DimensionAlias nvarchar2(255) NULL,
AllowDuplicatesInDimension NUMBER(1, 0) NULL,
AttributeDataType nvarchar2(50) NULL,
ConsolidationDuplicate nvarchar2(50) NULL,
DataStorageDuplicate nvarchar2(50) NULL)
;
-- Create HS_Time_Member table
create table HS_Time_Member(
LoadID NUMBER(38, 0) NULL,
Name nvarchar2(255) NOT NULL,
Description nvarchar2(255) NULL,
Consolidation nvarchar2(50) NULL,
FullyQualifiedSharedMember nvarchar2(255) NULL,
HierarchyType nvarchar2(50) NULL,
BSOMemberFormula nvarchar2(255) NULL,
MemberSolveOrder NUMBER(38, 0) NULL,
PrimaryLevelWeighting nvarchar2(50) NULL,
TwoPassCalc NUMBER(1, 0) NULL,
UDA nvarchar2(255) NULL)
;
-- Create HS_Time_Hierarchy table
create table HS_Time_Hierarchy(
LoadID NUMBER(38, 0) NULL,
Parent nvarchar2(255) NOT NULL,
Child nvarchar2(255) NOT NULL,
IsPrimary NUMBER(1, 0) NOT NULL,
SortOrder NUMBER(38, 0) NULL,
DataStorage nvarchar2(50) NULL)
;
-- Create HS_Time_PropertyArray table
create table HS_Time_PropertyArray(
LoadID NUMBER(38, 0) NULL,
Property nvarchar2(255) NOT NULL,
Name nvarchar2(255) NOT NULL,
Key nvarchar2(255) NOT NULL,
Value nvarchar2(255) NULL)
;
-- Create HS_Time_Property table
create table HS_Time_Property(
LoadID NUMBER(38, 0) NULL,
DimensionAlias nvarchar2(255) NULL,
AllowDuplicatesInDimension NUMBER(1, 0) NULL,
CommentDuplicate nvarchar2(255) NULL,
ConsolidationDuplicate nvarchar2(50) NULL,
DimDataStorage nvarchar2(50) NULL,
DimensionHierarchyType nvarchar2(50) NULL,
DimensionSolveOrder NUMBER(38, 0) NULL,
BSOMemberFormulaDuplicate nvarchar2(255) NULL,
MemberSolveOrderDuplicate NUMBER(38, 0) NULL,
TwoPassCalcDuplicate NUMBER(1, 0) NULL,
UDADuplicate nvarchar2(255) NULL)
;
-- Create HS_Country_Member table
create table HS_Country_Member(
LoadID NUMBER(38, 0) NULL,
Name nvarchar2(255) NOT NULL,
Description nvarchar2(255) NULL,
CurrencyName nvarchar2(255) NULL,
FullyQualifiedSharedMember nvarchar2(255) NULL,
BSOMemberFormula nvarchar2(255) NULL,
TwoPassCalc NUMBER(1, 0) NULL,
UDA nvarchar2(255) NULL)
;
-- Create HS_Country_Hierarchy table
create table HS_Country_Hierarchy(
LoadID NUMBER(38, 0) NULL,
Parent nvarchar2(255) NOT NULL,
Child nvarchar2(255) NOT NULL,
IsPrimary NUMBER(1, 0) NOT NULL,
SortOrder NUMBER(38, 0) NULL,
DataStorage nvarchar2(50) NULL)
;
-- Create HS_Country_PropertyArray table
create table HS_Country_PropertyArray(
LoadID NUMBER(38, 0) NULL,
Property nvarchar2(255) NOT NULL,
Name nvarchar2(255) NOT NULL,
Key nvarchar2(255) NOT NULL,
Value nvarchar2(255) NULL)
;
-- Create HS_Country_Property table
create table HS_Country_Property(
LoadID NUMBER(38, 0) NULL,
DimensionAlias nvarchar2(255) NULL,
CommentDuplicate nvarchar2(255) NULL,
ConsolidationDuplicate nvarchar2(50) NULL,
CurrencyNameDuplicate nvarchar2(255) NULL,
DimDataStorage nvarchar2(50) NULL,
BSOMemberFormulaDuplicate nvarchar2(255) NULL,
TwoPassCalcDuplicate NUMBER(1, 0) NULL,
UDADuplicate nvarchar2(255) NULL)
;
-- Create HS_UDA_Member table
create table HS_UDA_Member(
LoadID NUMBER(38, 0) NULL,
Name nvarchar2(255) NOT NULL,
Description nvarchar2(255) NULL)
;
-- Create HS_UDA_Hierarchy table
create table HS_UDA_Hierarchy(
LoadID NUMBER(38, 0) NULL,
Parent nvarchar2(255) NOT NULL,
Child nvarchar2(255) NOT NULL,
IsPrimary NUMBER(1, 0) NOT NULL,
SortOrder NUMBER(38, 0) NULL)
;
-- Create HS_UDA_Property table
create table HS_UDA_Property(
LoadID NUMBER(38, 0) NULL,
DimensionAlias nvarchar2(255) NULL)
;
-- Create HS_CellTextLabel_Member table
create table HS_CellTextLabel_Member(
LoadID NUMBER(38, 0) NULL,
Name nvarchar2(255) NOT NULL,
Description nvarchar2(255) NULL)
;
-- Create HS_CellTextLabel_Hierarchy table
create table HS_CellTextLabel_Hierarchy(
LoadID NUMBER(38, 0) NULL,
Parent nvarchar2(255) NOT NULL,
Child nvarchar2(255) NOT NULL,
IsPrimary NUMBER(1, 0) NOT NULL,
SortOrder NUMBER(38, 0) NULL)
;
-- Create HS_CellTextLabel_Property table
create table HS_CellTextLabel_Property(
LoadID NUMBER(38, 0) NULL,
DimensionAlias nvarchar2(255) NULL)
;
-- Create HS_Balance_Member table
create table HS_Balance_Member(
LoadID NUMBER(38, 0) NULL,
Name nvarchar2(255) NOT NULL,
Description nvarchar2(255) NULL,
UDA nvarchar2(255) NULL,
Consolidation nvarchar2(50) NULL,
FullyQualifiedSharedMember nvarchar2(255) NULL,
ASOMemberDataStorage nvarchar2(50) NULL,
ASOMemberFormula nvarchar2(255) NULL,
MemberSolveOrder NUMBER(38, 0) NULL,
HierarchyType nvarchar2(50) NULL,
PrimaryLevelWeighting nvarchar2(50) NULL)
;
-- Create HS_Balance_Hierarchy table
create table HS_Balance_Hierarchy(
LoadID NUMBER(38, 0) NULL,
Parent nvarchar2(255) NOT NULL,
Child nvarchar2(255) NOT NULL,
IsPrimary NUMBER(1, 0) NOT NULL,
SortOrder NUMBER(38, 0) NULL)
;
-- Create HS_Balance_PropertyArray table
create table HS_Balance_PropertyArray(
LoadID NUMBER(38, 0) NULL,
Property nvarchar2(255) NOT NULL,
Name nvarchar2(255) NOT NULL,
Key nvarchar2(255) NOT NULL,
Value nvarchar2(255) NULL)
;
-- Create HS_Balance_Property table
-- dimension-level properties, no BSO props should be included
create table HS_Balance_Property(
LoadID NUMBER(38, 0) NULL,
DimensionAlias nvarchar2(255) NULL,
ASODimensionDataStorage nvarchar2(50) NULL,
ASODimensionFormula nvarchar2(255) NULL,
UDADuplicate nvarchar2(255) NULL,
DimensionSolveOrder NUMBER(38, 0) NULL,
DimensionHierarchyType nvarchar2(50) NULL,
DimensionSortOrder NUMBER(38, 0) NULL)
;
-- Create HS_Rule_Member table
create table HS_Rule_Member(
LoadID NUMBER(38, 0) NULL,
Name nvarchar2(255) NOT NULL,
Description nvarchar2(255) NULL,
UDA nvarchar2(255) NULL,
Consolidation nvarchar2(50) NULL,
FullyQualifiedSharedMember nvarchar2(255) NULL,
ASOMemberDataStorage nvarchar2(50) NULL,
ASOMemberFormula nvarchar2(255) NULL,
MemberSolveOrder NUMBER(38, 0) NULL,
HierarchyType nvarchar2(50) NULL,
PrimaryLevelWeighting nvarchar2(50) NULL)
;
-- Create HS_Rule_Hierarchy table
create table HS_Rule_Hierarchy(
LoadID NUMBER(38, 0) NULL,
Parent nvarchar2(255) NOT NULL,
Child nvarchar2(255) NOT NULL,
IsPrimary NUMBER(1, 0) NOT NULL,
SortOrder NUMBER(38, 0) NULL)
;
-- Create HS_Rule_PropertyArray table
create table HS_Rule_PropertyArray(
LoadID NUMBER(38, 0) NULL,
Property nvarchar2(255) NOT NULL,
Name nvarchar2(255) NOT NULL,
Key nvarchar2(255) NOT NULL,
Value nvarchar2(255) NULL)
;
-- Create HS_Rule_Property table
-- dimension-level properties, no BSO props should be included
create table HS_Rule_Property(
LoadID NUMBER(38, 0) NULL,
DimensionAlias nvarchar2(255) NULL,
ASODimensionDataStorage nvarchar2(50) NULL,
ASODimensionFormula nvarchar2(255) NULL,
UDADuplicate nvarchar2(255) NULL,
DimensionSolveOrder NUMBER(38, 0) NULL,
DimensionHierarchyType nvarchar2(50) NULL,
DimensionSortOrder NUMBER(38, 0) NULL)
;
-- Insert the records in IM_Dimension table for list of dimensions
insert into IM_Dimension (c_Dimension_Name,c_Dimension_Class_Name,c_Member_Table_Name,c_Hierarchy_Table_Name,c_Property_Array_Table_Name ,c_Dim_Property_Table_Name) values('Scenario','Scenario','HS_Scenario_Member','HS_Scenario_Hierarchy','HS_Scenario_PropertyArray','HS_Scenario_Property')
;
insert into IM_Dimension (c_Dimension_Name,c_Dimension_Class_Name,c_Member_Table_Name,c_Hierarchy_Table_Name,c_Property_Array_Table_Name ,c_Dim_Property_Table_Name) values('Year','Year','HS_Year_Member','HS_Year_Hierarchy','HS_Year_PropertyArray','HS_Year_Property')
;
insert into IM_Dimension (c_Dimension_Name,c_Dimension_Class_Name,c_Member_Table_Name,c_Hierarchy_Table_Name,c_Property_Array_Table_Name ,c_Dim_Property_Table_Name) values('Period','Period','HS_Period_Member','HS_Period_Hierarchy','HS_Period_PropertyArray','HS_Period_Property')
;
insert into IM_Dimension (c_Dimension_Name,c_Dimension_Class_Name,c_Member_Table_Name,c_Hierarchy_Table_Name,c_Property_Array_Table_Name ,c_Dim_Property_Table_Name) values('View','View','HS_View_Member','HS_View_Hierarchy','HS_View_PropertyArray','HS_View_Property')
;
insert into IM_Dimension (c_Dimension_Name,c_Dimension_Class_Name,c_Member_Table_Name,c_Hierarchy_Table_Name,c_Property_Array_Table_Name ,c_Dim_Property_Table_Name) values('Entity','Entity','HS_Entity_Member','HS_Entity_Hierarchy','HS_Entity_PropertyArray','HS_Entity_Property')
;
insert into IM_Dimension (c_Dimension_Name,c_Dimension_Class_Name,c_Member_Table_Name,c_Hierarchy_Table_Name,c_Property_Array_Table_Name ,c_Dim_Property_Table_Name) values('Value','Value','HS_Value_Member','HS_Value_Hierarchy','HS_Value_PropertyArray','HS_Value_Property')
;
insert into IM_Dimension (c_Dimension_Name,c_Dimension_Class_Name,c_Member_Table_Name,c_Hierarchy_Table_Name,c_Property_Array_Table_Name ,c_Dim_Property_Table_Name) values('Account','Account','HS_Account_Member','HS_Account_Hierarchy','HS_Account_PropertyArray','HS_Account_Property')
;
insert into IM_Dimension (c_Dimension_Name,c_Dimension_Class_Name,c_Member_Table_Name,c_Hierarchy_Table_Name,c_Property_Array_Table_Name ,c_Dim_Property_Table_Name) values('ICP','ICP','HS_ICP_Member','HS_ICP_Hierarchy','HS_ICP_PropertyArray','HS_ICP_Property')
;
insert into IM_Dimension (c_Dimension_Name,c_Dimension_Class_Name,c_Member_Table_Name,c_Hierarchy_Table_Name,c_Property_Array_Table_Name ,c_Dim_Property_Table_Name) values('Generic','Generic','HS_Generic_Member','HS_Generic_Hierarchy','HS_Generic_PropertyArray','HS_Generic_Property')
;
insert into IM_Dimension (c_Dimension_Name,c_Dimension_Class_Name,c_Member_Table_Name,c_Hierarchy_Table_Name,c_Property_Array_Table_Name ,c_Dim_Property_Table_Name) values('ConsolidationMethod','ConsolidationMethod','HS_ConsolMethod_Member','HS_ConsolMethod_Hierarchy','HS_ConsolMethod_PropertyArray','HS_ConsolMethod_Property')
;
insert into IM_Dimension (c_Dimension_Name,c_Dimension_Class_Name,c_Member_Table_Name,c_Hierarchy_Table_Name,c_Property_Array_Table_Name ,c_Dim_Property_Table_Name) values('Currency','Currency','HS_Currency_Member','HS_Currency_Hierarchy','HS_Currency_PropertyArray','HS_Currency_Property')
;
insert into IM_Dimension (c_Dimension_Name,c_Dimension_Class_Name,c_Member_Table_Name,c_Hierarchy_Table_Name,c_Property_Array_Table_Name ,c_Dim_Property_Table_Name) values('SecurityClass','SecurityClass','HS_SecurityClass_Member','HS_SecurityClass_Hierarchy','HS_SecurityClass_PropertyArray','HS_SecurityClass_Property')
;
insert into IM_Dimension (c_Dimension_Name,c_Dimension_Class_Name,c_Member_Table_Name,c_Hierarchy_Table_Name,c_Property_Array_Table_Name ,c_Dim_Property_Table_Name) values('Alias','Alias','HS_Alias_Member','HS_Alias_Hierarchy',null,'HS_Alias_Property')
;
insert into IM_Dimension (c_Dimension_Name,c_Dimension_Class_Name,c_Member_Table_Name,c_Hierarchy_Table_Name,c_Property_Array_Table_Name ,c_Dim_Property_Table_Name) values('Version','Version','HS_Version_Member','HS_Version_Hierarchy','HS_Version_PropertyArray','HS_Version_Property')
;
insert into IM_Dimension (c_Dimension_Name,c_Dimension_Class_Name,c_Member_Table_Name,c_Hierarchy_Table_Name,c_Property_Array_Table_Name ,c_Dim_Property_Table_Name) values('SmartList','SmartList','HS_SmartList_Member','HS_SmartList_Hierarchy','HS_SmartList_PropertyArray','HS_SmartList_Property')
;
insert into IM_Dimension (c_Dimension_Name,c_Dimension_Class_Name,c_Member_Table_Name,c_Hierarchy_Table_Name,c_Property_Array_Table_Name ,c_Dim_Property_Table_Name) values('Attribute','Attribute','HS_Attribute_Member','HS_Attribute_Hierarchy','HS_Attribute_PropertyArray','HS_Attribute_Property')
;
insert into IM_Dimension (c_Dimension_Name,c_Dimension_Class_Name,c_Member_Table_Name,c_Hierarchy_Table_Name,c_Property_Array_Table_Name ,c_Dim_Property_Table_Name) values('Time','Time','HS_Time_Member','HS_Time_Hierarchy','HS_Time_PropertyArray','HS_Time_Property')
;
insert into IM_Dimension (c_Dimension_Name,c_Dimension_Class_Name,c_Member_Table_Name,c_Hierarchy_Table_Name,c_Property_Array_Table_Name ,c_Dim_Property_Table_Name) values('Country','Country','HS_Country_Member','HS_Country_Hierarchy','HS_Country_PropertyArray','HS_Country_Property')
;
insert into IM_Dimension (c_Dimension_Name,c_Dimension_Class_Name,c_Member_Table_Name,c_Hierarchy_Table_Name,c_Property_Array_Table_Name ,c_Dim_Property_Table_Name) values('UDA','UDA','HS_UDA_Member','HS_UDA_Hierarchy',null,'HS_UDA_Property')
;
insert into IM_Dimension (c_Dimension_Name,c_Dimension_Class_Name,c_Member_Table_Name,c_Hierarchy_Table_Name,c_Property_Array_Table_Name ,c_Dim_Property_Table_Name) values('CellTextLabel','CellTextLabel','HS_CellTextLabel_Member','HS_CellTextLabel_Hierarchy',null,'HS_CellTextLabel_Property')
;
insert into IM_Dimension (c_Dimension_Name,c_Dimension_Class_Name,c_Member_Table_Name,c_Hierarchy_Table_Name,c_Property_Array_Table_Name ,c_Dim_Property_Table_Name) values('Balance','Balance','HS_Balance_Member','HS_Balance_Hierarchy','HS_Balance_PropertyArray','HS_Balance_Property')
;
insert into IM_Dimension (c_Dimension_Name,c_Dimension_Class_Name,c_Member_Table_Name,c_Hierarchy_Table_Name,c_Property_Array_Table_Name ,c_Dim_Property_Table_Name) values('Rule','Rule','HS_Rule_Member','HS_Rule_Hierarchy','HS_Rule_PropertyArray','HS_Rule_Property')
;
-- Create the Data tables
-- [DOB 02-21-2013] These are for DataSync, and should not be removed.
create table HS_Data_CurrencyRates (
LoadID NUMBER(38, 0) NULL,
Year nvarchar2(255) NOT NULL,
Period nvarchar2(255) NOT NULL,
FromCurrency nvarchar2(255) NOT NULL,
ToCurrency nvarchar2(255) NOT NULL,
ExchangeRate float NOT NULL)
;
create table HS_Data_Sales (
LoadID NUMBER(38, 0) NULL,
Period nvarchar2(255) NOT NULL,
Entity nvarchar2(255) NOT NULL,
Account nvarchar2(255) NOT NULL,
Product nvarchar2(255) NOT NULL,
Customer nvarchar2(255) NOT NULL,
Amount float NOT NULL)
;
create table HS_Data_Consolidation(
LoadID NUMBER(38, 0) NULL,
Scenario nvarchar2(255) NOT NULL,
Year nvarchar2(255) NOT NULL,
Period nvarchar2(255) NOT NULL,
ViewDimension nvarchar2(255) NOT NULL,
Value nvarchar2(255) NOT NULL,
Entity nvarchar2(255) NOT NULL,
Account nvarchar2(255) NOT NULL,
ICP nvarchar2(255) NOT NULL,
Custom1 nvarchar2(255) NOT NULL,
Custom2 nvarchar2(255) NOT NULL,
Custom3 nvarchar2(255) NOT NULL,
Custom4 nvarchar2(255) NOT NULL,
Data float NOT NULL)
;
create table HS_Data_CapExTemplate (
LoadID NUMBER(38, 0) NULL,
Currency nvarchar2(255) NOT NULL,
Entity nvarchar2(255) NOT NULL,
LineItem nvarchar2(255) NOT NULL,
Period nvarchar2(255) NOT NULL,
Scenario nvarchar2(255) NOT NULL,
Version nvarchar2(255) NOT NULL,
Year nvarchar2(255) NOT NULL,
Account nvarchar2(255) NOT NULL,
AssetClass nvarchar2(255) NOT NULL,
Data nvarchar2(255) NOT NULL)
;
COMMENT ON TABLE IM_Dimension IS '- Contains the list of dimensions to be imported'
;
COMMENT ON COLUMN IM_Dimension.i_Load_ID IS '- (optional) The ID of the load group this dimension belongs to, if any'
;
COMMENT ON COLUMN IM_Dimension.c_Dimension_Name IS '- The name of the dimension to be imported'
;
COMMENT ON COLUMN IM_Dimension.c_Dimension_Class_Name IS '- The name of the Dimension Class (aka DimensionType) for this dimension'
;
COMMENT ON COLUMN IM_Dimension.c_Member_Table_Name IS '- The name of the table which contains the members to be imported, along with a number of Dimension-Global Member-level properties to be imported. This is analogous to the Members section in an ADS file.'
;
COMMENT ON COLUMN IM_Dimension.c_Hierarchy_Table_Name IS '- The name of the table which contains the parent-child relationships between members, along with property values to be imported. This is analogous to the Hierarchies section in an ADS file.'
;
COMMENT ON COLUMN IM_Dimension.c_Property_Array_Table_Name IS '- The name of the table which contains array-type property values'
;
COMMENT ON COLUMN IM_Dimension.c_Dim_Property_Table_Name IS '- The name of the table which contains dimension-level property values for the dimension to be imported'
;
COMMENT ON TABLE IM_Dimension_Association IS '- Contains the list of dimension associations that need to be set up between the dimensions being imported.'
;
COMMENT ON COLUMN IM_Dimension_Association.i_Load_ID IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN IM_Dimension_Association.c_Base_Dimension IS '- The name of the base dimension for the dimension association'
;
COMMENT ON COLUMN IM_Dimension_Association.c_Property IS '- The name of the property for the dimension association'
;
COMMENT ON COLUMN IM_Dimension_Association.c_Target_Dimension IS '- The name of the target dimension for the dimension association'
;
COMMENT ON TABLE IM_Load_Info IS '- Optional table which allows data to be imported to be categorized into groups (by Load ID) and selectively imported'
;
COMMENT ON COLUMN IM_Load_Info.i_Load_ID IS '- An integer ID that identifies the various dimensions and members to be imported.'
;
COMMENT ON COLUMN IM_Load_Info.c_Source_System IS '- The name of the source system'
;
COMMENT ON COLUMN IM_Load_Info.c_User_Last_Updated IS '- The name of the user that last updated this Load group'
;
COMMENT ON COLUMN IM_Load_Info.d_Date_Last_Updated IS '- The date/time of the last update'
;
COMMENT ON COLUMN IM_Load_Info.c_Last_Update_Login IS '- The login used for the last update'
;
COMMENT ON TABLE HS_Scenario_Member IS '- Sample table that contains members for the Scenario dimension'
;
COMMENT ON COLUMN HS_Scenario_Member.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Scenario_Member.bsomemberformula IS '- Used to store a property value for the "Member Formula(BSO)" property'
;
COMMENT ON COLUMN HS_Scenario_Member.consolidateytd IS '- Used to store a property value for the "Consolidate YTD" property'
;
COMMENT ON COLUMN HS_Scenario_Member.datatype IS '- Used to store a property value for the "Data Type" property'
;
COMMENT ON COLUMN HS_Scenario_Member.defaultfrequency IS '- Used to store a property value for the DefaultFrequency property'
;
COMMENT ON COLUMN HS_Scenario_Member.defaultparent IS '- Used to store a property value for the "Default Parent" property'
;
COMMENT ON COLUMN HS_Scenario_Member.defaultview IS '- Used to store a property value for the "Default View" property'
;
COMMENT ON COLUMN HS_Scenario_Member.deffreqforictrans IS '- Used to store a property value for the "Default Frequency For IC Transactions" property'
;
COMMENT ON COLUMN HS_Scenario_Member.description IS '- Used to store a property value for the "Description" property'
;
COMMENT ON COLUMN HS_Scenario_Member.enabledataaudit IS '- Used to store a property value for the "Enable Data Audit" property'
;
COMMENT ON COLUMN HS_Scenario_Member.enableprocessmanagement IS '- Used to store a property value for the "Enable Process Management" property'
;
COMMENT ON COLUMN HS_Scenario_Member.endperiod IS '- Used to store a property value for the "End Period" property'
;
COMMENT ON COLUMN HS_Scenario_Member.endyear IS '- Used to store a property value for the "End Year" property'
;
COMMENT ON COLUMN HS_Scenario_Member.exchangeratetable IS '- Used to store a property value for the "ExchangeRate Table" property'
;
COMMENT ON COLUMN HS_Scenario_Member.hfmenableprocessmanagement IS '- Used to store a property value for the "Enable Process Management" property'
;
COMMENT ON COLUMN HS_Scenario_Member.maximumreviewlevel IS '- Used to store a property value for the "Maximum Review Level" property'
;
COMMENT ON COLUMN HS_Scenario_Member.name IS '- (required) The name of the member to be added or updated'
;
COMMENT ON COLUMN HS_Scenario_Member.securityclass IS '- Used to store a property value for the "Security Class" property'
;
COMMENT ON COLUMN HS_Scenario_Member.smartlist IS '- Used to store a property value for the "Smart List" property'
;
COMMENT ON COLUMN HS_Scenario_Member.startperiod IS '- Used to store a property value for the "Start Period" property'
;
COMMENT ON COLUMN HS_Scenario_Member.startyear IS '- Used to store a property value for the "Start Year" property'
;
COMMENT ON COLUMN HS_Scenario_Member.uda IS '- Used to store a property value for the "UDA" property'
;
COMMENT ON COLUMN HS_Scenario_Member.usebegbalance IS '- Used to store a property value for the "Use Beginning Balance" property'
;
COMMENT ON COLUMN HS_Scenario_Member.userdefined1 IS '- Used to store a property value for the "User Defined 1" property'
;
COMMENT ON COLUMN HS_Scenario_Member.userdefined2 IS '- Used to store a property value for the "User Defined 2" property'
;
COMMENT ON COLUMN HS_Scenario_Member.userdefined3 IS '- Used to store a property value for the "User Defined 3" property'
;
COMMENT ON COLUMN HS_Scenario_Member.useslineitems IS '- Used to store a property value for the "Uses Line Items" property'
;
COMMENT ON COLUMN HS_Scenario_Member.zeroviewforadj IS '- Used to store a property value for the "Zero View For Adjustments" property'
;
COMMENT ON COLUMN HS_Scenario_Member.zeroviewfornonadj IS '- Used to store a property value for the "Zero View For Non-adjustments" property'
;
COMMENT ON TABLE HS_Account_Hierarchy IS '- Sample table that contains parent/child relationships for the Account dimension, along with property values'
;
COMMENT ON COLUMN HS_Account_Hierarchy.capexaggregation IS '- Used to store a property value for the "Aggregation For Capital Asset Plan" property'
;
COMMENT ON COLUMN HS_Account_Hierarchy.child IS '- (required) The name of the member to be updated'
;
COMMENT ON COLUMN HS_Account_Hierarchy.datastorage IS '- Used to store a property value for the "Data Storage" property'
;
COMMENT ON COLUMN HS_Account_Hierarchy.exchangeratetype IS '- Used to store a property value for the "ExchangeRate Type" property'
;
COMMENT ON COLUMN HS_Account_Hierarchy.isprimary IS '- If this field is included, it is used to indicate whether the parent/child relationship is primary or not'
;
COMMENT ON COLUMN HS_Account_Hierarchy.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Account_Hierarchy.membervalidforcapex IS '- Used to store a property value for the "Valid For Capital Asset Plan" property'
;
COMMENT ON COLUMN HS_Account_Hierarchy.membervalidforplan1 IS '- Used to store a property value for the "Valid For Plan1" property'
;
COMMENT ON COLUMN HS_Account_Hierarchy.membervalidforplan2 IS '- Used to store a property value for the "Valid For Plan2" property'
;
COMMENT ON COLUMN HS_Account_Hierarchy.membervalidforplan3 IS '- Used to store a property value for the "Valid For Plan3" property'
;
COMMENT ON COLUMN HS_Account_Hierarchy.membervalidforworkforce IS '- Used to store a property value for the "Valid For Workforce" property'
;
COMMENT ON COLUMN HS_Account_Hierarchy.parent IS '- (required) The name of the parent of the member to be updated'
;
COMMENT ON COLUMN HS_Account_Hierarchy.plan1aggregation IS '- Used to store a property value for the "Aggregation For Plan1" property'
;
COMMENT ON COLUMN HS_Account_Hierarchy.plan2aggregation IS '- Used to store a property value for the "Aggregation For Plan2" property'
;
COMMENT ON COLUMN HS_Account_Hierarchy.plan3aggregation IS '- Used to store a property value for the "Aggregation For Plan3" property'
;
COMMENT ON COLUMN HS_Account_Hierarchy.sortorder IS '- (optional) A number indicating the order in which this member should appear among all of its sibling members'
;
COMMENT ON COLUMN HS_Account_Hierarchy.sourceplantype IS '- Used to store a property value for the "Source Plan Type" property'
;
COMMENT ON COLUMN HS_Account_Hierarchy.workforceaggregation IS '- Used to store a property value for the "Aggregation For Workforce" property'
;
COMMENT ON TABLE HS_Account_Member IS '- Sample table that contains members for the Account dimension'
;
COMMENT ON COLUMN HS_Account_Member.accounttype IS '- Used to store a property value for the "Account Type" property'
;
COMMENT ON COLUMN HS_Account_Member.bsomemberformula IS '- Used to store a property value for the "Member Formula(BSO)" property'
;
COMMENT ON COLUMN HS_Account_Member.calcattribute IS '- Used to store a property value for the "Calc Attribute" property'
;
COMMENT ON COLUMN HS_Account_Member.consolidation IS '- Used to store a property value for the "Consolidation" property'
;
COMMENT ON COLUMN HS_Account_Member.consolidationaccounttype IS '- Used to store a property value for the "Consolidation Account Type" property'
;
COMMENT ON COLUMN HS_Account_Member.currencycategory IS '- Used to store a property value for the "Currency Category" property'
;
COMMENT ON COLUMN HS_Account_Member.currencyconversion IS '- Used to store a property value for the "Currency Conversion" property'
;
COMMENT ON COLUMN HS_Account_Member.customtopmembercustom3 IS '- Used to store a property value for the dynamic property "CustomTopMemberCustom3"'
;
COMMENT ON COLUMN HS_Account_Member.customtopmembercustomers IS '- Used to store a property value for the dynamic property "CustomTopMemberCustomers"'
;
COMMENT ON COLUMN HS_Account_Member.customtopmemberflow IS '- Used to store a property value for the dynamic property "CustomTopMemberFlow"'
;
COMMENT ON COLUMN HS_Account_Member.customtopmemberproducts IS '- Used to store a property value for the dynamic property "CustomTopMemberProducts"'
;
COMMENT ON COLUMN HS_Account_Member.datatype IS '- Used to store a property value for the "Data Type" property'
;
COMMENT ON COLUMN HS_Account_Member.defaultparent IS '- Used to store a property value for the "Default Parent" property'
;
COMMENT ON COLUMN HS_Account_Member.description IS '- Used to store a property value for the "Description" property'
;
COMMENT ON COLUMN HS_Account_Member.enablecustomaggrcustom3 IS '- Used to store a property value for the dynamic property "EnableCustomAggrCustom3"'
;
COMMENT ON COLUMN HS_Account_Member.enablecustomaggrcustomers IS '- Used to store a property value for the dynamic property "EnableCustomAggrCustomers"'
;
COMMENT ON COLUMN HS_Account_Member.enablecustomaggrflow IS '- Used to store a property value for the dynamic property "EnableCustomAggrFlow"'
;
COMMENT ON COLUMN HS_Account_Member.enablecustomaggrproducts IS '- Used to store a property value for the dynamic property "EnableCustomAggrProducts"'
;
COMMENT ON COLUMN HS_Account_Member.enabledataaudit IS '- Used to store a property value for the "Enable Data Audit" property'
;
COMMENT ON COLUMN HS_Account_Member.fullyqualifiedsharedmember IS '- Used to store a property value for the "Fully Qualified Shared Member" property'
;
COMMENT ON COLUMN HS_Account_Member.hierarchytype IS '- Used to store a property value for the "Hierarchy Type" property'
;
COMMENT ON COLUMN HS_Account_Member.icptopmember IS '- Used to store a property value for the "ICP Top Member" property'
;
COMMENT ON COLUMN HS_Account_Member.icptopmemberstring IS '- Used to store a property value for the "ICP Top Member String" property'
;
COMMENT ON COLUMN HS_Account_Member.iscalculated IS '- Used to store a property value for the "Is Calculated" property'
;
COMMENT ON COLUMN HS_Account_Member.isconsolidated IS '- Used to store a property value for the "Is Consolidated" property'
;
COMMENT ON COLUMN HS_Account_Member.isicp IS '- Used to store a property value for the "Is ICP" property'
;
COMMENT ON COLUMN HS_Account_Member.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Account_Member.membersolveorder IS '- Used to store a property value for the "Member Solve Order" property'
;
COMMENT ON COLUMN HS_Account_Member.name IS '- (required) The name of the member to be added or updated'
;
COMMENT ON COLUMN HS_Account_Member.numdecimalplaces IS '- Used to store a property value for the "Number Of Decimal Places" property'
;
COMMENT ON COLUMN HS_Account_Member.plugaccount IS '- Used to store a property value for the "Plug Account" property'
;
COMMENT ON COLUMN HS_Account_Member.primarylevelweighting IS '- Used to store a property value for the "Level Usage for Aggregation" property'
;
COMMENT ON COLUMN HS_Account_Member.securityclass IS '- Used to store a property value for the "Security Class" property'
;
COMMENT ON COLUMN HS_Account_Member.skipvalue IS '- Used to store a property value for the "Skip Value" property'
;
COMMENT ON COLUMN HS_Account_Member.smartlist IS '- Used to store a property value for the "Smart List" property'
;
COMMENT ON COLUMN HS_Account_Member.submissiongroup IS '- Used to store a property value for the "Submission Group" property'
;
COMMENT ON COLUMN HS_Account_Member.timebalance IS '- Used to store a property value for the "Time Balance" property'
;
COMMENT ON COLUMN HS_Account_Member.twopasscalc IS '- Used to store a property value for the "Two Pass Calculation" property'
;
COMMENT ON COLUMN HS_Account_Member.uda IS '- Used to store a property value for the "UDA" property'
;
COMMENT ON COLUMN HS_Account_Member.userdefined1 IS '- Used to store a property value for the "User Defined 1" property'
;
COMMENT ON COLUMN HS_Account_Member.userdefined2 IS '- Used to store a property value for the "User Defined 2" property'
;
COMMENT ON COLUMN HS_Account_Member.userdefined3 IS '- Used to store a property value for the "User Defined 3" property'
;
COMMENT ON COLUMN HS_Account_Member.useslineitems IS '- Used to store a property value for the "Uses Line Items" property'
;
COMMENT ON COLUMN HS_Account_Member.variancereporting IS '- Used to store a property value for the "Expense Reporting" property'
;
COMMENT ON COLUMN HS_Account_Member.xbrltags IS '- Used to store a property value for the "User defined 4" property'
;
COMMENT ON TABLE HS_Account_Property IS '- Sample table that contains dimension-level property values for the Account dimension'
;
COMMENT ON COLUMN HS_Account_Property.allowduplicatesindimension IS '- Used to store a property value for the "Allow Duplicates In Dimension" property'
;
COMMENT ON COLUMN HS_Account_Property.bsomemberformuladuplicate IS '- Used to store a property value for the "BSO Member Formula" property'
;
COMMENT ON COLUMN HS_Account_Property.capexdensity IS '- Used to store a property value for the "Capital Asset Plan Density" property'
;
COMMENT ON COLUMN HS_Account_Property.commentduplicate IS '- Used to store a property value for the "Comment" property'
;
COMMENT ON COLUMN HS_Account_Property.consolidationduplicate IS '- Used to store a property value for the "Consolidation" property'
;
COMMENT ON COLUMN HS_Account_Property.dimdatastorage IS '- Used to store a property value for the "Data Storage" property'
;
COMMENT ON COLUMN HS_Account_Property.dimensionalias IS '- Used to store a property value for the "Dimension Alias" property'
;
COMMENT ON COLUMN HS_Account_Property.dimensionhierarchytype IS '- Used to store a property value for the "Hierarchy Type" property'
;
COMMENT ON COLUMN HS_Account_Property.dimensionsolveorder IS '- Used to store a property value for the "Dimension Solve Order" property'
;
COMMENT ON COLUMN HS_Account_Property.dimvalidforcapex IS '- Used to store a property value for the "Valid For Capital Asset Plan" property'
;
COMMENT ON COLUMN HS_Account_Property.dimvalidforplan1 IS '- Used to store a property value for the "Valid For Plan1" property'
;
COMMENT ON COLUMN HS_Account_Property.dimvalidforplan2 IS '- Used to store a property value for the "Valid For Plan2" property'
;
COMMENT ON COLUMN HS_Account_Property.dimvalidforplan3 IS '- Used to store a property value for the "Valid For Plan3" property'
;
COMMENT ON COLUMN HS_Account_Property.dimvalidforworkforce IS '- Used to store a property value for the "Valid For Workforce" property'
;
COMMENT ON COLUMN HS_Account_Property.enumorder1 IS '- Used to store a property value for the "Plan1 Evaluation Order" property'
;
COMMENT ON COLUMN HS_Account_Property.enumorder2 IS '- Used to store a property value for the "Plan2 Evaluation Order" property'
;
COMMENT ON COLUMN HS_Account_Property.enumorder3 IS '- Used to store a property value for the "Plan3 Evaluation Order" property'
;
COMMENT ON COLUMN HS_Account_Property.enumordercapex IS '- Used to store a property value for the "Capital Asset Plan Evaluation Order" property'
;
COMMENT ON COLUMN HS_Account_Property.enumorderwf IS '- Used to store a property value for the "Workforce Evaluation Order" property'
;
COMMENT ON COLUMN HS_Account_Property.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Account_Property.membersolveorderduplicate IS '- Used to store a property value for the "Member Solve Order" property'
;
COMMENT ON COLUMN HS_Account_Property.plan1density IS '- Used to store a property value for the "Plan1 Density" property'
;
COMMENT ON COLUMN HS_Account_Property.plan2density IS '- Used to store a property value for the "Plan2 Density" property'
;
COMMENT ON COLUMN HS_Account_Property.plan3density IS '- Used to store a property value for the "Plan3 Density" property'
;
COMMENT ON COLUMN HS_Account_Property.skipvalueduplicate IS '- Used to store a property value for the "Skip Value" property'
;
COMMENT ON COLUMN HS_Account_Property.timebalanceduplicate IS '- Used to store a property value for the "Time Balance" property'
;
COMMENT ON COLUMN HS_Account_Property.twopasscalcduplicate IS '- Used to store a property value for the "Two Pass Calculation" property'
;
COMMENT ON COLUMN HS_Account_Property.udaduplicate IS '- Used to store a property value for the "UDA" property'
;
COMMENT ON COLUMN HS_Account_Property.variancereportingduplicate IS '- Used to store a property value for the "Variance Reporting" property'
;
COMMENT ON COLUMN HS_Account_Property.workforcedensity IS '- Used to store a property value for the "Workforce Density" property'
;
COMMENT ON TABLE HS_Account_PropertyArray IS '- Sample table that contains property value for properties that use a dimension association for the Account dimension'
;
COMMENT ON COLUMN HS_Account_PropertyArray.key IS '- (required) The name of the member from the target dimension (the property being updated must use a dimension association)'
;
COMMENT ON COLUMN HS_Account_PropertyArray.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Account_PropertyArray.name IS '- (required) The name of the member whose properties are being updated'
;
COMMENT ON COLUMN HS_Account_PropertyArray.property IS '- (required) The name of the property to update (it must be one which uses a dimension association)'
;
COMMENT ON COLUMN HS_Account_PropertyArray.value IS '- (required for StringMap properties, such as Alias) The property value to set for the given key member name'
;
COMMENT ON TABLE HS_Alias_Hierarchy IS '- Sample table that contains parent/child relationships for the Alias dimension, along with property values'
;
COMMENT ON COLUMN HS_Alias_Hierarchy.child IS '- (required) The name of the member to be updated'
;
COMMENT ON COLUMN HS_Alias_Hierarchy.isprimary IS '- If this field is included, it is used to indicate whether the parent/child relationship is primary or not'
;
COMMENT ON COLUMN HS_Alias_Hierarchy.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Alias_Hierarchy.parent IS '- (required) The name of the parent of the member to be updated'
;
COMMENT ON COLUMN HS_Alias_Hierarchy.sortorder IS '- (optional) A number indicating the order in which this member should appear among all of its sibling members'
;
COMMENT ON TABLE HS_Alias_Member IS '- Sample table that contains members for the Alias dimension'
;
COMMENT ON COLUMN HS_Alias_Member.description IS '- Used to store a property value for the "Description" property'
;
COMMENT ON COLUMN HS_Alias_Member.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Alias_Member.name IS '- (required) The name of the member to be added or updated'
;
COMMENT ON TABLE HS_Alias_Property IS '- Sample table that contains dimension-level property values for the Alias dimension'
;
COMMENT ON COLUMN HS_Alias_Property.dimensionalias IS '- Used to store a property value for the "Dimension Alias" property'
;
COMMENT ON COLUMN HS_Alias_Property.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON TABLE HS_Attribute_Hierarchy IS '- Sample table that contains parent/child relationships for an Attribute dimension, along with property values'
;
COMMENT ON COLUMN HS_Attribute_Hierarchy.child IS '- (required) The name of the member to be updated'
;
COMMENT ON COLUMN HS_Attribute_Hierarchy.datastorage IS '- Used to store a property value for the "Data Storage" property'
;
COMMENT ON COLUMN HS_Attribute_Hierarchy.isprimary IS '- If this field is included, it is used to indicate whether the parent/child relationship is primary or not'
;
COMMENT ON COLUMN HS_Attribute_Hierarchy.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Attribute_Hierarchy.parent IS '- (required) The name of the parent of the member to be updated'
;
COMMENT ON COLUMN HS_Attribute_Hierarchy.sortorder IS '- (optional) A number indicating the order in which this member should appear among all of its sibling members'
;
COMMENT ON TABLE HS_Attribute_Member IS '- Sample table that contains members for the Attribute dimension'
;
COMMENT ON COLUMN HS_Attribute_Member.description IS '- Used to store a property value for the "Description" property'
;
COMMENT ON COLUMN HS_Attribute_Member.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Attribute_Member.name IS '- (required) The name of the member to be added or updated'
;
COMMENT ON COLUMN HS_Attribute_Member.secondarylevelweighting IS '- Used to store a property value for the "Level Usage for Aggregation" property'
;
COMMENT ON TABLE HS_Attribute_Property IS '- Sample table that contains dimension-level property values for an Attribute dimension'
;
COMMENT ON COLUMN HS_Attribute_Property.allowduplicatesindimension IS '- Used to store a property value for the "Allow Duplicates In Dimension" property'
;
COMMENT ON COLUMN HS_Attribute_Property.attributedatatype IS '- Used to store a property value for the "Attribute Type" property'
;
COMMENT ON COLUMN HS_Attribute_Property.consolidationduplicate IS '- Used to store a property value for the "Consolidation" property'
;
COMMENT ON COLUMN HS_Attribute_Property.datastorageduplicate IS '- Used to store a property value for the "Data Storage" property'
;
COMMENT ON COLUMN HS_Attribute_Property.dimensionalias IS '- Used to store a property value for the "Dimension Alias" property'
;
COMMENT ON COLUMN HS_Attribute_Property.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON TABLE HS_Attribute_PropertyArray IS '- Sample table that contains property value for properties that use a dimension association for an Attribute dimension'
;
COMMENT ON COLUMN HS_Attribute_PropertyArray.key IS '- (required) The name of the member from the target dimension (the property being updated must use a dimension association)'
;
COMMENT ON COLUMN HS_Attribute_PropertyArray.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Attribute_PropertyArray.name IS '- (required) The name of the member whose properties are being updated'
;
COMMENT ON COLUMN HS_Attribute_PropertyArray.property IS '- (required) The name of the property to update (it must be one which uses a dimension association)'
;
COMMENT ON COLUMN HS_Attribute_PropertyArray.value IS '- (required for StringMap properties, such as Alias) The property value to set for the given key member name'
;
COMMENT ON TABLE HS_CellTextLabel_Hierarchy IS '- Sample table that contains parent/child relationships for the CellTextLabel dimension, along with property values'
;
COMMENT ON COLUMN HS_CellTextLabel_Hierarchy.child IS '- (required) The name of the member to be updated'
;
COMMENT ON COLUMN HS_CellTextLabel_Hierarchy.isprimary IS '- If this field is included, it is used to indicate whether the parent/child relationship is primary or not'
;
COMMENT ON COLUMN HS_CellTextLabel_Hierarchy.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_CellTextLabel_Hierarchy.parent IS '- (required) The name of the parent of the member to be updated'
;
COMMENT ON COLUMN HS_CellTextLabel_Hierarchy.sortorder IS '- (optional) A number indicating the order in which this member should appear among all of its sibling members'
;
COMMENT ON TABLE HS_CellTextLabel_Member IS '- Sample table that contains members for the CellTextLabel dimension'
;
COMMENT ON COLUMN HS_CellTextLabel_Member.description IS '- Used to store a property value for the "Description" property'
;
COMMENT ON COLUMN HS_CellTextLabel_Member.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_CellTextLabel_Member.name IS '- (required) The name of the member to be added or updated'
;
COMMENT ON TABLE HS_CellTextLabel_Property IS '- Sample table that contains dimension-level property values for the CellTextLabel dimension'
;
COMMENT ON COLUMN HS_CellTextLabel_Property.dimensionalias IS '- Used to store a property value for the "Dimension Alias" property'
;
COMMENT ON COLUMN HS_CellTextLabel_Property.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON TABLE HS_Balance_Member IS '- Sample table that contains members for the Balance dimension'
;
COMMENT ON COLUMN HS_Balance_Member.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Balance_Member.name IS '- (required) The name of the member to be added or updated'
;
COMMENT ON COLUMN HS_Balance_Member.description IS '- Used to store a property value for the "Description" property'
;
COMMENT ON COLUMN HS_Balance_Member.uda IS '- Used to store a property value for the "UDA" property'
;
COMMENT ON COLUMN HS_Balance_Member.consolidation IS '- Used to store a property value for the "Consolidation" property'
;
COMMENT ON COLUMN HS_Balance_Member.fullyqualifiedsharedmember IS '- Used to store a property value for the "Fully Qualified Shared Member" property'
;
COMMENT ON COLUMN HS_Balance_Member.asomemberdatastorage IS '- Used to store a property value for the "ASO Member Data Storage" property'
;
COMMENT ON COLUMN HS_Balance_Member.asomemberformula IS '- Used to store a property value for the "ASO Member Formula" property'
;
COMMENT ON COLUMN HS_Balance_Member.membersolveorder IS '- Used to store a property value for the "Member Solve Order" property'
;
COMMENT ON COLUMN HS_Balance_Member.hierarchytype IS '- Used to store a property value for the "Hierarchy Type" property'
;
COMMENT ON COLUMN HS_Balance_Member.primarylevelweighting IS '- Used to store a property value for the "Level Usage for Aggregation" property'
;
COMMENT ON TABLE HS_Balance_Hierarchy IS '- Sample table that contains parent/child relationships for the Balance dimension, along with property values'
;
COMMENT ON COLUMN HS_Balance_Hierarchy.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Balance_Hierarchy.parent IS '- (required) The name of the parent of the member to be updated'
;
COMMENT ON COLUMN HS_Balance_Hierarchy.child IS '- (required) The name of the member to be updated'
;
COMMENT ON COLUMN HS_Balance_Hierarchy.isprimary IS '- If this field is included, it is used to indicate whether the parent/child relationship is primary or not'
;
COMMENT ON COLUMN HS_Balance_Hierarchy.sortorder IS '- (optional) A number indicating the order in which this member should appear among all of its sibling members'
;
COMMENT ON TABLE HS_Balance_Property IS '- The name of the property for the dimension association'
;
COMMENT ON COLUMN HS_Balance_Property.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Balance_Property.dimensionalias IS '- Used to store a property value for the "Dimension Alias" property'
;
COMMENT ON COLUMN HS_Balance_Property.asodimensiondatastorage IS '- Used to store a property value for the "ASO Dimension Data Storage" property'
;
COMMENT ON COLUMN HS_Balance_Property.asodimensionformula IS '- Used to store a property value for the "ASO Dimension Formula" property'
;
COMMENT ON COLUMN HS_Balance_Property.udaduplicate IS '- Used to store a property value for the "UDA" property'
;
COMMENT ON COLUMN HS_Balance_Property.dimensionsolveorder IS '- Used to store a property value for the "Dimension Solve Order" property'
;
COMMENT ON COLUMN HS_Balance_Property.dimensionhierarchytype IS '- Used to store a property value for the "Hierarchy Type" property'
;
COMMENT ON COLUMN HS_Balance_Property.dimensionsortorder IS '- (optional) A number indicating the order in which this dimension should appear among all of its sibling dimensions'
;
COMMENT ON TABLE HS_Balance_PropertyArray IS '- Sample table that contains property value for properties that use a dimension association for the Balance dimension'
;
COMMENT ON COLUMN HS_Balance_PropertyArray.key IS '- (required) The name of the member from the target dimension (the property being updated must use a dimension association)'
;
COMMENT ON COLUMN HS_Balance_PropertyArray.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Balance_PropertyArray.name IS '- (required) The name of the member whose properties are being updated'
;
COMMENT ON COLUMN HS_Balance_PropertyArray.property IS '- (required) The name of the property to update (it must be one which uses a dimension association)'
;
COMMENT ON COLUMN HS_Balance_PropertyArray.value IS '- (required for StringMap properties, such as Alias) The property value to set for the given key member name'
;
COMMENT ON TABLE HS_Rule_PropertyArray IS '- Sample table that contains property value for properties that use a dimension association for the Rule dimension'
;
COMMENT ON COLUMN HS_Rule_PropertyArray.key IS '- (required) The name of the member from the target dimension (the property being updated must use a dimension association)'
;
COMMENT ON COLUMN HS_Rule_PropertyArray.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Rule_PropertyArray.name IS '- (required) The name of the member whose properties are being updated'
;
COMMENT ON COLUMN HS_Rule_PropertyArray.property IS '- (required) The name of the property to update (it must be one which uses a dimension association)'
;
COMMENT ON COLUMN HS_Rule_PropertyArray.value IS '- (required for StringMap properties, such as Alias) The property value to set for the given key member name'
;
COMMENT ON COLUMN HS_Rule_Member.name IS '- (required) The name of the member to be added or updated'
;
COMMENT ON COLUMN HS_Rule_Member.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Rule_Member.name IS '- (required) The name of the member to be added or updated'
;
COMMENT ON COLUMN HS_Rule_Member.description IS '- Used to store a property value for the "Description" property'
;
COMMENT ON COLUMN HS_Rule_Member.uda IS '- Used to store a property value for the "UDA" property'
;
COMMENT ON COLUMN HS_Rule_Member.consolidation IS '- Used to store a property value for the "Consolidation" property'
;
COMMENT ON COLUMN HS_Rule_Member.fullyqualifiedsharedmember IS '- Used to store a property value for the "Fully Qualified Shared Member" property'
;
COMMENT ON COLUMN HS_Rule_Member.asomemberdatastorage IS '- Used to store a property value for the "ASO Member Data Storage" property'
;
COMMENT ON COLUMN HS_Rule_Member.asomemberformula IS '- Used to store a property value for the "ASO Member Formula" property'
;
COMMENT ON COLUMN HS_Rule_Member.membersolveorder IS '- Used to store a property value for the "Member Solve Order" property'
;
COMMENT ON COLUMN HS_Rule_Member.hierarchytype IS '- Used to store a property value for the "Hierarchy Type" property'
;
COMMENT ON COLUMN HS_Rule_Member.primarylevelweighting IS '- Used to store a property value for the "Level Usage for Aggregation" property'
;
COMMENT ON TABLE HS_Rule_Hierarchy IS '- Sample table that contains parent/child relationships for the Rule dimension, along with property values'
;
COMMENT ON COLUMN HS_Rule_Hierarchy.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Rule_Hierarchy.parent IS '- (required) The name of the parent of the member to be updated'
;
COMMENT ON COLUMN HS_Rule_Hierarchy.child IS '- (required) The name of the member to be updated'
;
COMMENT ON COLUMN HS_Rule_Hierarchy.isprimary IS '- If this field is included, it is used to indicate whether the parent/child relationship is primary or not'
;
COMMENT ON COLUMN HS_Rule_Hierarchy.sortorder IS '- (optional) A number indicating the order in which this member should appear among all of its sibling members'
;
COMMENT ON TABLE HS_Rule_Property IS '- The name of the property for the dimension association'
;
COMMENT ON COLUMN HS_Rule_Property.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Rule_Property.dimensionalias IS '- Used to store a property value for the "Dimension Alias" property'
;
COMMENT ON COLUMN HS_Rule_Property.asodimensiondatastorage IS '- Used to store a property value for the "ASO Dimension Data Storage" property'
;
COMMENT ON COLUMN HS_Rule_Property.asodimensionformula IS '- Used to store a property value for the "ASO Dimension Formula" property'
;
COMMENT ON COLUMN HS_Rule_Property.udaduplicate IS '- Used to store a property value for the "UDA" property'
;
COMMENT ON COLUMN HS_Rule_Property.dimensionsolveorder IS '- Used to store a property value for the "Dimension Solve Order" property'
;
COMMENT ON COLUMN HS_Rule_Property.dimensionhierarchytype IS '- Used to store a property value for the "Hierarchy Type" property'
;
COMMENT ON COLUMN HS_Rule_Property.dimensionsortorder IS '- (optional) A number indicating the order in which this dimension should appear among all of its sibling dimensions'
;
COMMENT ON TABLE HS_ConsolMethod_Hierarchy IS '- Sample table that contains parent/child relationships for the Consolidation dimension, along with property values'
;
COMMENT ON COLUMN HS_ConsolMethod_Hierarchy.child IS '- (required) The name of the member to be updated'
;
COMMENT ON COLUMN HS_ConsolMethod_Hierarchy.isprimary IS '- If this field is included, it is used to indicate whether the parent/child relationship is primary or not'
;
COMMENT ON COLUMN HS_ConsolMethod_Hierarchy.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_ConsolMethod_Hierarchy.parent IS '- (required) The name of the parent of the member to be updated'
;
COMMENT ON COLUMN HS_ConsolMethod_Hierarchy.sortorder IS '- (optional) A number indicating the order in which this member should appear among all of its sibling members'
;
COMMENT ON TABLE HS_ConsolMethod_Member IS '- Sample table that contains members for the ConsolidationMethod dimension'
;
COMMENT ON COLUMN HS_ConsolMethod_Member.control IS '- Used to store a property value for the "Control" property'
;
COMMENT ON COLUMN HS_ConsolMethod_Member.description IS '- Used to store a property value for the "Description" property'
;
COMMENT ON COLUMN HS_ConsolMethod_Member.isholdingmethod IS '- Used to store a property value for the "Is Holding Method" property'
;
COMMENT ON COLUMN HS_ConsolMethod_Member.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_ConsolMethod_Member.name IS '- (required) The name of the member to be added or updated'
;
COMMENT ON COLUMN HS_ConsolMethod_Member.percentconsol IS '- Used to store a property value for the "Percent Consol" property'
;
COMMENT ON COLUMN HS_ConsolMethod_Member.percentconsolvalue IS '- Used to store a property value for the "Percent Consol Value" property'
;
COMMENT ON COLUMN HS_ConsolMethod_Member.topercentcontrol IS '- Used to store a property value for the "To Percent Control" property'
;
COMMENT ON COLUMN HS_ConsolMethod_Member.topercentcontrolcomp IS '- Used to store a property value for the "To Percent Control Compare" property'
;
COMMENT ON COLUMN HS_ConsolMethod_Member.usedbycalcroutine IS '- Used to store a property value for the "Used By Calc Routine" property'
;
COMMENT ON TABLE HS_ConsolMethod_Property IS '- Sample table that contains dimension-level property values for the ConsolidationMethod dimension'
;
COMMENT ON COLUMN HS_ConsolMethod_Property.dimensionalias IS '- Used to store a property value for the "Dimension Alias" property'
;
COMMENT ON COLUMN HS_ConsolMethod_Property.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON TABLE HS_ConsolMethod_PropertyArray IS '- Sample table that contains property value for properties that use a dimension association for the ConsolidationMethod dimension'
;
COMMENT ON COLUMN HS_ConsolMethod_PropertyArray.key IS '- (required) The name of the member from the target dimension (the property being updated must use a dimension association)'
;
COMMENT ON COLUMN HS_ConsolMethod_PropertyArray.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_ConsolMethod_PropertyArray.name IS '- (required) The name of the member whose properties are being updated'
;
COMMENT ON COLUMN HS_ConsolMethod_PropertyArray.property IS '- (required) The name of the property to update (it must be one which uses a dimension association)'
;
COMMENT ON COLUMN HS_ConsolMethod_PropertyArray.value IS '- (required for StringMap properties, such as Alias) The property value to set for the given key member name'
;
COMMENT ON TABLE HS_Country_Hierarchy IS '- Sample table that contains parent/child relationships for the Country dimension, along with property values'
;
COMMENT ON COLUMN HS_Country_Hierarchy.child IS '- (required) The name of the member to be updated'
;
COMMENT ON COLUMN HS_Country_Hierarchy.datastorage IS '- Used to store a property value for the "Data Storage" property'
;
COMMENT ON COLUMN HS_Country_Hierarchy.isprimary IS '- If this field is included, it is used to indicate whether the parent/child relationship is primary or not'
;
COMMENT ON COLUMN HS_Country_Hierarchy.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Country_Hierarchy.parent IS '- (required) The name of the parent of the member to be updated'
;
COMMENT ON COLUMN HS_Country_Hierarchy.sortorder IS '- (optional) A number indicating the order in which this member should appear among all of its sibling members'
;
COMMENT ON TABLE HS_Country_Member IS '- Sample table that contains members for the Country dimension'
;
COMMENT ON COLUMN HS_Country_Member.bsomemberformula IS '- Used to store a property value for the "Member Formula(BSO)" property'
;
COMMENT ON COLUMN HS_Country_Member.currencyname IS '- Used to store a property value for the "Currency Name" property'
;
COMMENT ON COLUMN HS_Country_Member.description IS '- Used to store a property value for the "Description" property'
;
COMMENT ON COLUMN HS_Country_Member.fullyqualifiedsharedmember IS '- Used to store a property value for the "Fully Qualified Shared Member" property'
;
COMMENT ON COLUMN HS_Country_Member.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Country_Member.name IS '- (required) The name of the member to be added or updated'
;
COMMENT ON COLUMN HS_Country_Member.twopasscalc IS '- Used to store a property value for the "Two Pass Calculation" property'
;
COMMENT ON COLUMN HS_Country_Member.uda IS '- Used to store a property value for the "UDA" property'
;
COMMENT ON TABLE HS_Country_Property IS '- Sample table that contains dimension-level property values for the Country dimension'
;
COMMENT ON COLUMN HS_Country_Property.bsomemberformuladuplicate IS '- Used to store a property value for the "BSO Member Formula" property'
;
COMMENT ON COLUMN HS_Country_Property.commentduplicate IS '- Used to store a property value for the "Comment" property'
;
COMMENT ON COLUMN HS_Country_Property.consolidationduplicate IS '- Used to store a property value for the "Consolidation" property'
;
COMMENT ON COLUMN HS_Country_Property.currencynameduplicate IS '- Used to store a property value for the "Currency Name" property'
;
COMMENT ON COLUMN HS_Country_Property.dimdatastorage IS '- Used to store a property value for the "Data Storage" property'
;
COMMENT ON COLUMN HS_Country_Property.dimensionalias IS '- Used to store a property value for the "Dimension Alias" property'
;
COMMENT ON COLUMN HS_Country_Property.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Country_Property.twopasscalcduplicate IS '- Used to store a property value for the "Two Pass Calculation" property'
;
COMMENT ON COLUMN HS_Country_Property.udaduplicate IS '- Used to store a property value for the "UDA" property'
;
COMMENT ON TABLE HS_Country_PropertyArray IS '- Sample table that contains property value for properties that use a dimension association for the Country dimension'
;
COMMENT ON COLUMN HS_Country_PropertyArray.key IS '- (required) The name of the member from the target dimension (the property being updated must use a dimension association)'
;
COMMENT ON COLUMN HS_Country_PropertyArray.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Country_PropertyArray.name IS '- (required) The name of the member whose properties are being updated'
;
COMMENT ON COLUMN HS_Country_PropertyArray.property IS '- (required) The name of the property to update (it must be one which uses a dimension association)'
;
COMMENT ON COLUMN HS_Country_PropertyArray.value IS '- (required for StringMap properties, such as Alias) The property value to set for the given key member name'
;
COMMENT ON TABLE HS_Currency_Hierarchy IS '- Sample table that contains parent/child relationships for the Currency dimension, along with property values'
;
COMMENT ON COLUMN HS_Currency_Hierarchy.child IS '- (required) The name of the member to be updated'
;
COMMENT ON COLUMN HS_Currency_Hierarchy.datastorage IS '- Used to store a property value for the "Data Storage" property'
;
COMMENT ON COLUMN HS_Currency_Hierarchy.isprimary IS '- If this field is included, it is used to indicate whether the parent/child relationship is primary or not'
;
COMMENT ON COLUMN HS_Currency_Hierarchy.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Currency_Hierarchy.membervalidforcapex IS '- Used to store a property value for the "Valid For Capital Asset Plan" property'
;
COMMENT ON COLUMN HS_Currency_Hierarchy.membervalidforplan1 IS '- Used to store a property value for the "Valid For Plan1" property'
;
COMMENT ON COLUMN HS_Currency_Hierarchy.membervalidforplan2 IS '- Used to store a property value for the "Valid For Plan2" property'
;
COMMENT ON COLUMN HS_Currency_Hierarchy.membervalidforplan3 IS '- Used to store a property value for the "Valid For Plan3" property'
;
COMMENT ON COLUMN HS_Currency_Hierarchy.membervalidforworkforce IS '- Used to store a property value for the "Valid For Workforce" property'
;
COMMENT ON COLUMN HS_Currency_Hierarchy.parent IS '- (required) The name of the parent of the member to be updated'
;
COMMENT ON COLUMN HS_Currency_Hierarchy.sortorder IS '- (optional) A number indicating the order in which this member should appear among all of its sibling members'
;
COMMENT ON TABLE HS_Currency_Member IS '- Sample table that contains members for the Currency dimension'
;
COMMENT ON COLUMN HS_Currency_Member.bsomemberformula IS '- Used to store a property value for the "Member Formula(BSO)" property'
;
COMMENT ON COLUMN HS_Currency_Member.currencycode IS '- Used to store a property value for the "Currency Code" property'
;
COMMENT ON COLUMN HS_Currency_Member.datatype IS '- Used to store a property value for the "Data Type" property'
;
COMMENT ON COLUMN HS_Currency_Member.decimalsep IS '- Used to store a property value for the "Decimal Separator" property'
;
COMMENT ON COLUMN HS_Currency_Member.description IS '- Used to store a property value for the "Description" property'
;
COMMENT ON COLUMN HS_Currency_Member.displayinict IS '- Used to store a property value for the "Display In ICT" property'
;
COMMENT ON COLUMN HS_Currency_Member.fullyqualifiedsharedmember IS '- Used to store a property value for the "Fully Qualified Shared Member" property'
;
COMMENT ON COLUMN HS_Currency_Member.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Currency_Member.name IS '- (required) The name of the member to be added or updated'
;
COMMENT ON COLUMN HS_Currency_Member.negativecolor IS '- Used to store a property value for the "Negative Color" property'
;
COMMENT ON COLUMN HS_Currency_Member.negativesign IS '- Used to store a property value for the "Negative Sign" property'
;
COMMENT ON COLUMN HS_Currency_Member.reptcurrency IS '- Used to store a property value for the "Reporting Currency" property'
;
COMMENT ON COLUMN HS_Currency_Member.scale IS '- Used to store a property value for the "Scale" property'
;
COMMENT ON COLUMN HS_Currency_Member.smartlist IS '- Used to store a property value for the "Smart List" property'
;
COMMENT ON COLUMN HS_Currency_Member.symbol IS '- Used to store a property value for the "Symbol" property'
;
COMMENT ON COLUMN HS_Currency_Member.thousandsep IS '- Used to store a property value for the "Thousands Separator" property'
;
COMMENT ON COLUMN HS_Currency_Member.translationoperator IS '- Used to store a property value for the "Translation Operator" property'
;
COMMENT ON COLUMN HS_Currency_Member.triangulationcurrency IS '- Used to store a property value for the "Triangulation Currency" property'
;
COMMENT ON COLUMN HS_Currency_Member.twopasscalc IS '- Used to store a property value for the "Two Pass Calculation" property'
;
COMMENT ON COLUMN HS_Currency_Member.uda IS '- Used to store a property value for the "UDA" property'
;
COMMENT ON TABLE HS_Currency_Property IS '- Sample table that contains dimension-level property values for the Currency dimension'
;
COMMENT ON COLUMN HS_Currency_Property.allowduplicatesindimension IS '- Used to store a property value for the "Allow Duplicates In Dimension" property'
;
COMMENT ON COLUMN HS_Currency_Property.bsomemberformuladuplicate IS '- Used to store a property value for the "BSO Member Formula" property'
;
COMMENT ON COLUMN HS_Currency_Property.capexdensity IS '- Used to store a property value for the "Capital Asset Plan Density" property'
;
COMMENT ON COLUMN HS_Currency_Property.commentduplicate IS '- Used to store a property value for the "Comment" property'
;
COMMENT ON COLUMN HS_Currency_Property.consolidationduplicate IS '- Used to store a property value for the "Consolidation" property'
;
COMMENT ON COLUMN HS_Currency_Property.dimdatastorage IS '- Used to store a property value for the "Data Storage" property'
;
COMMENT ON COLUMN HS_Currency_Property.dimensionalias IS '- Used to store a property value for the "Dimension Alias" property'
;
COMMENT ON COLUMN HS_Currency_Property.dimvalidforcapex IS '- Used to store a property value for the "Valid For Capital Asset Plan" property'
;
COMMENT ON COLUMN HS_Currency_Property.dimvalidforplan1 IS '- Used to store a property value for the "Valid For Plan1" property'
;
COMMENT ON COLUMN HS_Currency_Property.dimvalidforplan2 IS '- Used to store a property value for the "Valid For Plan2" property'
;
COMMENT ON COLUMN HS_Currency_Property.dimvalidforplan3 IS '- Used to store a property value for the "Valid For Plan3" property'
;
COMMENT ON COLUMN HS_Currency_Property.dimvalidforworkforce IS '- Used to store a property value for the "Valid For Workforce" property'
;
COMMENT ON COLUMN HS_Currency_Property.enumorder1 IS '- Used to store a property value for the "Plan1 Evaluation Order" property'
;
COMMENT ON COLUMN HS_Currency_Property.enumorder2 IS '- Used to store a property value for the "Plan2 Evaluation Order" property'
;
COMMENT ON COLUMN HS_Currency_Property.enumorder3 IS '- Used to store a property value for the "Plan3 Evaluation Order" property'
;
COMMENT ON COLUMN HS_Currency_Property.enumordercapex IS '- Used to store a property value for the "Capital Asset Plan Evaluation Order" property'
;
COMMENT ON COLUMN HS_Currency_Property.enumorderwf IS '- Used to store a property value for the "Workforce Evaluation Order" property'
;
COMMENT ON COLUMN HS_Currency_Property.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Currency_Property.plan1density IS '- Used to store a property value for the "Plan1 Density" property'
;
COMMENT ON COLUMN HS_Currency_Property.plan2density IS '- Used to store a property value for the "Plan2 Density" property'
;
COMMENT ON COLUMN HS_Currency_Property.plan3density IS '- Used to store a property value for the "Plan3 Density" property'
;
COMMENT ON COLUMN HS_Currency_Property.twopasscalcduplicate IS '- Used to store a property value for the "Two Pass Calculation" property'
;
COMMENT ON COLUMN HS_Currency_Property.udaduplicate IS '- Used to store a property value for the "UDA" property'
;
COMMENT ON COLUMN HS_Currency_Property.workforcedensity IS '- Used to store a property value for the "Workforce Density" property'
;
COMMENT ON TABLE HS_Currency_PropertyArray IS '- Sample table that contains property value for properties that use a dimension association for the Currency dimension'
;
COMMENT ON COLUMN HS_Currency_PropertyArray.key IS '- (required) The name of the member from the target dimension (the property being updated must use a dimension association)'
;
COMMENT ON COLUMN HS_Currency_PropertyArray.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Currency_PropertyArray.name IS '- (required) The name of the member whose properties are being updated'
;
COMMENT ON COLUMN HS_Currency_PropertyArray.property IS '- (required) The name of the property to update (it must be one which uses a dimension association)'
;
COMMENT ON COLUMN HS_Currency_PropertyArray.value IS '- (required for StringMap properties, such as Alias) The property value to set for the given key member name'
;
COMMENT ON TABLE HS_Entity_Hierarchy IS '- Sample table that contains parent/child relationships for the Account dimension, along with property values'
;
COMMENT ON COLUMN HS_Entity_Hierarchy.capexaggregation IS '- Used to store a property value for the "Aggregation For Capital Asset Plan" property'
;
COMMENT ON COLUMN HS_Entity_Hierarchy.child IS '- (required) The name of the member to be updated'
;
COMMENT ON COLUMN HS_Entity_Hierarchy.datastorage IS '- Used to store a property value for the "Data Storage" property'
;
COMMENT ON COLUMN HS_Entity_Hierarchy.isprimary IS '- If this field is included, it is used to indicate whether the parent/child relationship is primary or not'
;
COMMENT ON COLUMN HS_Entity_Hierarchy.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Entity_Hierarchy.membervalidforcapex IS '- Used to store a property value for the "Valid For Capital Asset Plan" property'
;
COMMENT ON COLUMN HS_Entity_Hierarchy.membervalidforplan1 IS '- Used to store a property value for the "Valid For Plan1" property'
;
COMMENT ON COLUMN HS_Entity_Hierarchy.membervalidforplan2 IS '- Used to store a property value for the "Valid For Plan2" property'
;
COMMENT ON COLUMN HS_Entity_Hierarchy.membervalidforplan3 IS '- Used to store a property value for the "Valid For Plan3" property'
;
COMMENT ON COLUMN HS_Entity_Hierarchy.membervalidforworkforce IS '- Used to store a property value for the "Valid For Workforce" property'
;
COMMENT ON COLUMN HS_Entity_Hierarchy.parent IS '- (required) The name of the parent of the member to be updated'
;
COMMENT ON COLUMN HS_Entity_Hierarchy.plan1aggregation IS '- Used to store a property value for the "Aggregation For Plan1" property'
;
COMMENT ON COLUMN HS_Entity_Hierarchy.plan2aggregation IS '- Used to store a property value for the "Aggregation For Plan2" property'
;
COMMENT ON COLUMN HS_Entity_Hierarchy.plan3aggregation IS '- Used to store a property value for the "Aggregation For Plan3" property'
;
COMMENT ON COLUMN HS_Entity_Hierarchy.sortorder IS '- (optional) A number indicating the order in which this member should appear among all of its sibling members'
;
COMMENT ON COLUMN HS_Entity_Hierarchy.workforceaggregation IS '- Used to store a property value for the "Aggregation For Workforce" property'
;
COMMENT ON TABLE HS_Entity_Member IS '- Sample table that contains members for the Entity dimension'
;
COMMENT ON COLUMN HS_Entity_Member.allowadjfromchildren IS '- Used to store a property value for the "Allow Adjustments From Children" property'
;
COMMENT ON COLUMN HS_Entity_Member.allowadjs IS '- Used to store a property value for the "Allow Adjustments" property'
;
COMMENT ON COLUMN HS_Entity_Member.bsomemberformula IS '- Used to store a property value for the "Member Formula(BSO)" property'
;
COMMENT ON COLUMN HS_Entity_Member.currency IS '- Used to store a property value for the "Currency" property'
;
COMMENT ON COLUMN HS_Entity_Member.datatype IS '- Used to store a property value for the "Data Type" property'
;
COMMENT ON COLUMN HS_Entity_Member.defaultparent IS '- Used to store a property value for the "Default Parent" property'
;
COMMENT ON COLUMN HS_Entity_Member.description IS '- Used to store a property value for the "Description" property'
;
COMMENT ON COLUMN HS_Entity_Member.holdingcompany IS '- Used to store a property value for the "Holding Company" property'
;
COMMENT ON COLUMN HS_Entity_Member.isicp IS '- Used to store a property value for the "Is ICP" property'
;
COMMENT ON COLUMN HS_Entity_Member.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Entity_Member.name IS '- (required) The name of the member to be added or updated'
;
COMMENT ON COLUMN HS_Entity_Member.securityaspartner IS '- Used to store a property value for the "Security As Partner" property'
;
COMMENT ON COLUMN HS_Entity_Member.securityclass IS '- Used to store a property value for the "Security Class" property'
;
COMMENT ON COLUMN HS_Entity_Member.smartlist IS '- Used to store a property value for the "Smart List" property'
;
COMMENT ON COLUMN HS_Entity_Member.twopasscalc IS '- Used to store a property value for the "Two Pass Calculation" property'
;
COMMENT ON COLUMN HS_Entity_Member.uda IS '- Used to store a property value for the "UDA" property'
;
COMMENT ON COLUMN HS_Entity_Member.userdefined1 IS '- Used to store a property value for the "User Defined 1" property'
;
COMMENT ON COLUMN HS_Entity_Member.userdefined2 IS '- Used to store a property value for the "User Defined 2" property'
;
COMMENT ON COLUMN HS_Entity_Member.userdefined3 IS '- Used to store a property value for the "User Defined 3" property'
;
COMMENT ON TABLE HS_Entity_Property IS '- Sample table that contains dimension-level property values for the Entity dimension'
;
COMMENT ON COLUMN HS_Entity_Property.capexdensity IS '- Used to store a property value for the "Capital Asset Plan Density" property'
;
COMMENT ON COLUMN HS_Entity_Property.dimdatastorage IS '- Used to store a property value for the "Data Storage" property'
;
COMMENT ON COLUMN HS_Entity_Property.dimensionalias IS '- Used to store a property value for the "Dimension Alias" property'
;
COMMENT ON COLUMN HS_Entity_Property.dimvalidforcapex IS '- Used to store a property value for the "Valid For Capital Asset Plan" property'
;
COMMENT ON COLUMN HS_Entity_Property.dimvalidforplan1 IS '- Used to store a property value for the "Valid For Plan1" property'
;
COMMENT ON COLUMN HS_Entity_Property.dimvalidforplan2 IS '- Used to store a property value for the "Valid For Plan2" property'
;
COMMENT ON COLUMN HS_Entity_Property.dimvalidforplan3 IS '- Used to store a property value for the "Valid For Plan3" property'
;
COMMENT ON COLUMN HS_Entity_Property.dimvalidforworkforce IS '- Used to store a property value for the "Valid For Workforce" property'
;
COMMENT ON COLUMN HS_Entity_Property.enumorder1 IS '- Used to store a property value for the "Plan1 Evaluation Order" property'
;
COMMENT ON COLUMN HS_Entity_Property.enumorder2 IS '- Used to store a property value for the "Plan2 Evaluation Order" property'
;
COMMENT ON COLUMN HS_Entity_Property.enumorder3 IS '- Used to store a property value for the "Plan3 Evaluation Order" property'
;
COMMENT ON COLUMN HS_Entity_Property.enumordercapex IS '- Used to store a property value for the "Capital Asset Plan Evaluation Order" property'
;
COMMENT ON COLUMN HS_Entity_Property.enumorderwf IS '- Used to store a property value for the "Workforce Evaluation Order" property'
;
COMMENT ON COLUMN HS_Entity_Property.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Entity_Property.plan1density IS '- Used to store a property value for the "Plan1 Density" property'
;
COMMENT ON COLUMN HS_Entity_Property.plan2density IS '- Used to store a property value for the "Plan2 Density" property'
;
COMMENT ON COLUMN HS_Entity_Property.plan3density IS '- Used to store a property value for the "Plan3 Density" property'
;
COMMENT ON COLUMN HS_Entity_Property.workforcedensity IS '- Used to store a property value for the "Workforce Density" property'
;
COMMENT ON TABLE HS_Entity_PropertyArray IS '- Sample table that contains property value for properties that use a dimension association for the Entity dimension'
;
COMMENT ON COLUMN HS_Entity_PropertyArray.key IS '- (required) The name of the member from the target dimension (the property being updated must use a dimension association)'
;
COMMENT ON COLUMN HS_Entity_PropertyArray.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Entity_PropertyArray.name IS '- (required) The name of the member whose properties are being updated'
;
COMMENT ON COLUMN HS_Entity_PropertyArray.property IS '- (required) The name of the property to update (it must be one which uses a dimension association)'
;
COMMENT ON COLUMN HS_Entity_PropertyArray.value IS '- (required for StringMap properties, such as Alias) The property value to set for the given key member name'
;
COMMENT ON TABLE HS_Generic_Hierarchy IS '- Sample table that contains parent/child relationships for a Generic dimension, along with property values'
;
COMMENT ON COLUMN HS_Generic_Hierarchy.aggregationweight IS '- Used to store a property value for the "Aggregation Weight" property'
;
COMMENT ON COLUMN HS_Generic_Hierarchy.capexaggregation IS '- Used to store a property value for the "Aggregation For Capital Asset Plan" property'
;
COMMENT ON COLUMN HS_Generic_Hierarchy.child IS '- (required) The name of the member to be updated'
;
COMMENT ON COLUMN HS_Generic_Hierarchy.datastorage IS '- Used to store a property value for the "Data Storage" property'
;
COMMENT ON COLUMN HS_Generic_Hierarchy.isprimary IS '- If this field is included, it is used to indicate whether the parent/child relationship is primary or not'
;
COMMENT ON COLUMN HS_Generic_Hierarchy.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Generic_Hierarchy.membervalidforcapex IS '- Used to store a property value for the "Valid For Capital Asset Plan" property'
;
COMMENT ON COLUMN HS_Generic_Hierarchy.membervalidforplan1 IS '- Used to store a property value for the "Valid For Plan1" property'
;
COMMENT ON COLUMN HS_Generic_Hierarchy.membervalidforplan2 IS '- Used to store a property value for the "Valid For Plan2" property'
;
COMMENT ON COLUMN HS_Generic_Hierarchy.membervalidforplan3 IS '- Used to store a property value for the "Valid For Plan3" property'
;
COMMENT ON COLUMN HS_Generic_Hierarchy.membervalidforworkforce IS '- Used to store a property value for the "Valid For Workforce" property'
;
COMMENT ON COLUMN HS_Generic_Hierarchy.parent IS '- (required) The name of the parent of the member to be updated'
;
COMMENT ON COLUMN HS_Generic_Hierarchy.plan1aggregation IS '- Used to store a property value for the "Aggregation For Plan1" property'
;
COMMENT ON COLUMN HS_Generic_Hierarchy.plan2aggregation IS '- Used to store a property value for the "Aggregation For Plan2" property'
;
COMMENT ON COLUMN HS_Generic_Hierarchy.plan3aggregation IS '- Used to store a property value for the "Aggregation For Plan3" property'
;
COMMENT ON COLUMN HS_Generic_Hierarchy.sortorder IS '- (optional) A number indicating the order in which this member should appear among all of its sibling members'
;
COMMENT ON COLUMN HS_Generic_Hierarchy.workforceaggregation IS '- Used to store a property value for the "Aggregation For Workforce" property'
;
COMMENT ON TABLE HS_Generic_Member IS '- Sample table that contains members for a Generic dimension'
;
COMMENT ON COLUMN HS_Generic_Member.bsomemberformula IS '- Used to store a property value for the "Member Formula(BSO)" property'
;
COMMENT ON COLUMN HS_Generic_Member.consolidation IS '- Used to store a property value for the "Consolidation" property'
;
COMMENT ON COLUMN HS_Generic_Member.datatype IS '- Used to store a property value for the "Data Type" property'
;
COMMENT ON COLUMN HS_Generic_Member.defaultparent IS '- Used to store a property value for the "Default Parent" property'
;
COMMENT ON COLUMN HS_Generic_Member.description IS '- Used to store a property value for the "Description" property'
;
COMMENT ON COLUMN HS_Generic_Member.fullyqualifiedsharedmember IS '- Used to store a property value for the "Fully Qualified Shared Member" property'
;
COMMENT ON COLUMN HS_Generic_Member.hierarchytype IS '- Used to store a property value for the "Hierarchy Type" property'
;
COMMENT ON COLUMN HS_Generic_Member.iscalculated IS '- Used to store a property value for the "Is Calculated" property'
;
COMMENT ON COLUMN HS_Generic_Member.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Generic_Member.membersolveorder IS '- Used to store a property value for the "Member Solve Order" property'
;
COMMENT ON COLUMN HS_Generic_Member.name IS '- (required) The name of the member to be added or updated'
;
COMMENT ON COLUMN HS_Generic_Member.primarylevelweighting IS '- Used to store a property value for the "Level Usage for Aggregation" property'
;
COMMENT ON COLUMN HS_Generic_Member.securityclass IS '- Used to store a property value for the "Security Class" property'
;
COMMENT ON COLUMN HS_Generic_Member.smartlist IS '- Used to store a property value for the "Smart List" property'
;
COMMENT ON COLUMN HS_Generic_Member.submissiongroup IS '- Used to store a property value for the "Submission Group" property'
;
COMMENT ON COLUMN HS_Generic_Member.switchsignforflow IS '- Used to store a property value for the "Switch Sign For Flow" property'
;
COMMENT ON COLUMN HS_Generic_Member.switchtypeforflow IS '- Used to store a property value for the "Switch Type For Flow" property'
;
COMMENT ON COLUMN HS_Generic_Member.twopasscalc IS '- Used to store a property value for the "Two Pass Calculation" property'
;
COMMENT ON COLUMN HS_Generic_Member.uda IS '- Used to store a property value for the "UDA" property'
;
COMMENT ON COLUMN HS_Generic_Member.userdefined1 IS '- Used to store a property value for the "User Defined 1" property'
;
COMMENT ON COLUMN HS_Generic_Member.userdefined2 IS '- Used to store a property value for the "User Defined 2" property'
;
COMMENT ON COLUMN HS_Generic_Member.userdefined3 IS '- Used to store a property value for the "User Defined 3" property'
;
COMMENT ON TABLE HS_Generic_Property IS '- Sample table that contains dimension-level property values for a Generic dimension'
;
COMMENT ON COLUMN HS_Generic_Property.allowduplicatesindimension IS '- Used to store a property value for the "Allow Duplicates In Dimension" property'
;
COMMENT ON COLUMN HS_Generic_Property.applysecurity IS '- Used to store a property value for the "Apply Security" property'
;
COMMENT ON COLUMN HS_Generic_Property.bsomemberformuladuplicate IS '- Used to store a property value for the "BSO Member Formula" property'
;
COMMENT ON COLUMN HS_Generic_Property.capexdensity IS '- Used to store a property value for the "Capital Asset Plan Density" property'
;
COMMENT ON COLUMN HS_Generic_Property.commentduplicate IS '- Used to store a property value for the "Comment" property'
;
COMMENT ON COLUMN HS_Generic_Property.consolidationduplicate IS '- Used to store a property value for the "Consolidation" property'
;
COMMENT ON COLUMN HS_Generic_Property.customdimensionid IS '- Used to store a property value for the "Custom Dimension" property'
;
COMMENT ON COLUMN HS_Generic_Property.dimdatastorage IS '- Used to store a property value for the "Data Storage" property'
;
COMMENT ON COLUMN HS_Generic_Property.dimensionalias IS '- Used to store a property value for the "Dimension Alias" property'
;
COMMENT ON COLUMN HS_Generic_Property.dimensionhierarchytype IS '- Used to store a property value for the "Hierarchy Type" property'
;
COMMENT ON COLUMN HS_Generic_Property.dimensionsolveorder IS '- Used to store a property value for the "Dimension Solve Order" property'
;
COMMENT ON COLUMN HS_Generic_Property.dimvalidforcapex IS '- Used to store a property value for the "Valid For Capital Asset Plan" property'
;
COMMENT ON COLUMN HS_Generic_Property.dimvalidforplan1 IS '- Used to store a property value for the "Valid For Plan1" property'
;
COMMENT ON COLUMN HS_Generic_Property.dimvalidforplan2 IS '- Used to store a property value for the "Valid For Plan2" property'
;
COMMENT ON COLUMN HS_Generic_Property.dimvalidforplan3 IS '- Used to store a property value for the "Valid For Plan3" property'
;
COMMENT ON COLUMN HS_Generic_Property.dimvalidforworkforce IS '- Used to store a property value for the "Valid For Workforce" property'
;
COMMENT ON COLUMN HS_Generic_Property.enumorder1 IS '- Used to store a property value for the "Plan1 Evaluation Order" property'
;
COMMENT ON COLUMN HS_Generic_Property.enumorder2 IS '- Used to store a property value for the "Plan2 Evaluation Order" property'
;
COMMENT ON COLUMN HS_Generic_Property.enumorder3 IS '- Used to store a property value for the "Plan3 Evaluation Order" property'
;
COMMENT ON COLUMN HS_Generic_Property.enumordercapex IS '- Used to store a property value for the "Capital Asset Plan Evaluation Order" property'
;
COMMENT ON COLUMN HS_Generic_Property.enumorderwf IS '- Used to store a property value for the "Workforce Evaluation Order" property'
;
COMMENT ON COLUMN HS_Generic_Property.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Generic_Property.plan1density IS '- Used to store a property value for the "Plan1 Density" property'
;
COMMENT ON COLUMN HS_Generic_Property.plan2density IS '- Used to store a property value for the "Plan2 Density" property'
;
COMMENT ON COLUMN HS_Generic_Property.plan3density IS '- Used to store a property value for the "Plan3 Density" property'
;
COMMENT ON COLUMN HS_Generic_Property.twopasscalcduplicate IS '- Used to store a property value for the "Two Pass Calculation" property'
;
COMMENT ON COLUMN HS_Generic_Property.udaduplicate IS '- Used to store a property value for the "UDA" property'
;
COMMENT ON COLUMN HS_Generic_Property.workforcedensity IS '- Used to store a property value for the "Workforce Density" property'
;
COMMENT ON TABLE HS_Generic_PropertyArray IS '- Sample table that contains property value for properties that use a dimension association for a Generic dimension'
;
COMMENT ON COLUMN HS_Generic_PropertyArray.key IS '- (required) The name of the member from the target dimension (the property being updated must use a dimension association)'
;
COMMENT ON COLUMN HS_Generic_PropertyArray.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Generic_PropertyArray.name IS '- (required) The name of the member whose properties are being updated'
;
COMMENT ON COLUMN HS_Generic_PropertyArray.property IS '- (required) The name of the property to update (it must be one which uses a dimension association)'
;
COMMENT ON COLUMN HS_Generic_PropertyArray.value IS '- (required for StringMap properties, such as Alias) The property value to set for the given key member name'
;
COMMENT ON TABLE HS_ICP_Hierarchy IS '- Sample table that contains parent/child relationships for the ICP dimension, along with property values'
;
COMMENT ON COLUMN HS_ICP_Hierarchy.child IS '- (required) The name of the member to be updated'
;
COMMENT ON COLUMN HS_ICP_Hierarchy.isprimary IS '- If this field is included, it is used to indicate whether the parent/child relationship is primary or not'
;
COMMENT ON COLUMN HS_ICP_Hierarchy.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_ICP_Hierarchy.parent IS '- (required) The name of the parent of the member to be updated'
;
COMMENT ON COLUMN HS_ICP_Hierarchy.sortorder IS '- (optional) A number indicating the order in which this member should appear among all of its sibling members'
;
COMMENT ON TABLE HS_ICP_Member IS '- Sample table that contains members for the ICP dimension'
;
COMMENT ON COLUMN HS_ICP_Member.defaultparent IS '- Used to store a property value for the "Default Parent" property'
;
COMMENT ON COLUMN HS_ICP_Member.description IS '- Used to store a property value for the "Description" property'
;
COMMENT ON COLUMN HS_ICP_Member.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_ICP_Member.name IS '- (required) The name of the member to be added or updated'
;
COMMENT ON COLUMN HS_ICP_Member.securityclass IS '- Used to store a property value for the "Security Class" property'
;
COMMENT ON COLUMN HS_ICP_Member.submissiongroup IS '- Used to store a property value for the "Submission Group" property'
;
COMMENT ON TABLE HS_ICP_Property IS '- Sample table that contains dimension-level property values for the ICP dimension'
;
COMMENT ON COLUMN HS_ICP_Property.dimensionalias IS '- Used to store a property value for the "Dimension Alias" property'
;
COMMENT ON COLUMN HS_ICP_Property.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON TABLE HS_ICP_PropertyArray IS '- Sample table that contains property value for properties that use a dimension association for the ICP dimension'
;
COMMENT ON COLUMN HS_ICP_PropertyArray.key IS '- (required) The name of the member from the target dimension (the property being updated must use a dimension association)'
;
COMMENT ON COLUMN HS_ICP_PropertyArray.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_ICP_PropertyArray.name IS '- (required) The name of the member whose properties are being updated'
;
COMMENT ON COLUMN HS_ICP_PropertyArray.property IS '- (required) The name of the property to update (it must be one which uses a dimension association)'
;
COMMENT ON COLUMN HS_ICP_PropertyArray.value IS '- (required for StringMap properties, such as Alias) The property value to set for the given key member name'
;
COMMENT ON TABLE HS_Period_Hierarchy IS '- Sample table that contains parent/child relationships for the Period dimension, along with property values'
;
COMMENT ON COLUMN HS_Period_Hierarchy.capexaggregation IS '- Used to store a property value for the "Aggregation For Capital Asset Plan" property'
;
COMMENT ON COLUMN HS_Period_Hierarchy.child IS '- (required) The name of the member to be updated'
;
COMMENT ON COLUMN HS_Period_Hierarchy.datastorage IS '- Used to store a property value for the "Data Storage" property'
;
COMMENT ON COLUMN HS_Period_Hierarchy.isprimary IS '- If this field is included, it is used to indicate whether the parent/child relationship is primary or not'
;
COMMENT ON COLUMN HS_Period_Hierarchy.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Period_Hierarchy.membervalidforcapex IS '- Used to store a property value for the "Valid For Capital Asset Plan" property'
;
COMMENT ON COLUMN HS_Period_Hierarchy.membervalidforplan1 IS '- Used to store a property value for the "Valid For Plan1" property'
;
COMMENT ON COLUMN HS_Period_Hierarchy.membervalidforplan2 IS '- Used to store a property value for the "Valid For Plan2" property'
;
COMMENT ON COLUMN HS_Period_Hierarchy.membervalidforplan3 IS '- Used to store a property value for the "Valid For Plan3" property'
;
COMMENT ON COLUMN HS_Period_Hierarchy.membervalidforworkforce IS '- Used to store a property value for the "Valid For Workforce" property'
;
COMMENT ON COLUMN HS_Period_Hierarchy.parent IS '- (required) The name of the parent of the member to be updated'
;
COMMENT ON COLUMN HS_Period_Hierarchy.periodtype IS '- Used to store a property value for the "Period Type" property'
;
COMMENT ON COLUMN HS_Period_Hierarchy.plan1aggregation IS '- Used to store a property value for the "Aggregation For Plan1" property'
;
COMMENT ON COLUMN HS_Period_Hierarchy.plan2aggregation IS '- Used to store a property value for the "Aggregation For Plan2" property'
;
COMMENT ON COLUMN HS_Period_Hierarchy.plan3aggregation IS '- Used to store a property value for the "Aggregation For Plan3" property'
;
COMMENT ON COLUMN HS_Period_Hierarchy.sortorder IS '- (optional) A number indicating the order in which this member should appear among all of its sibling members'
;
COMMENT ON COLUMN HS_Period_Hierarchy.workforceaggregation IS '- Used to store a property value for the "Aggregation For Workforce" property'
;
COMMENT ON TABLE HS_Period_Member IS '- Sample table that contains members for the Period dimension'
;
COMMENT ON COLUMN HS_Period_Member.bsomemberformula IS '- Used to store a property value for the "Member Formula(BSO)" property'
;
COMMENT ON COLUMN HS_Period_Member.datatype IS '- Used to store a property value for the "Data Type" property'
;
COMMENT ON COLUMN HS_Period_Member.defaultparent IS '- Used to store a property value for the "Default Parent" property'
;
COMMENT ON COLUMN HS_Period_Member.description IS '- Used to store a property value for the "Description" property'
;
COMMENT ON COLUMN HS_Period_Member.dtsenabled IS '- Used to store a property value for the "DTSEnabled" property'
;
COMMENT ON COLUMN HS_Period_Member.dtsgeneration IS '- Used to store a property value for the "DTS Generation" property'
;
COMMENT ON COLUMN HS_Period_Member.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Period_Member.name IS '- (required) The name of the member to be added or updated'
;
COMMENT ON COLUMN HS_Period_Member.smartlist IS '- Used to store a property value for the "Smart List" property'
;
COMMENT ON COLUMN HS_Period_Member.twopasscalc IS '- Used to store a property value for the "Two Pass Calculation" property'
;
COMMENT ON COLUMN HS_Period_Member.uda IS '- Used to store a property value for the "UDA" property'
;
COMMENT ON TABLE HS_Period_Property IS '- Sample table that contains dimension-level property values for the Period dimension'
;
COMMENT ON COLUMN HS_Period_Property.capexdensity IS '- Used to store a property value for the "Capital Asset Plan Density" property'
;
COMMENT ON COLUMN HS_Period_Property.dimdatastorage IS '- Used to store a property value for the "Data Storage" property'
;
COMMENT ON COLUMN HS_Period_Property.dimensionalias IS '- Used to store a property value for the "Dimension Alias" property'
;
COMMENT ON COLUMN HS_Period_Property.dimvalidforcapex IS '- Used to store a property value for the "Valid For Capital Asset Plan" property'
;
COMMENT ON COLUMN HS_Period_Property.dimvalidforplan1 IS '- Used to store a property value for the "Valid For Plan1" property'
;
COMMENT ON COLUMN HS_Period_Property.dimvalidforplan2 IS '- Used to store a property value for the "Valid For Plan2" property'
;
COMMENT ON COLUMN HS_Period_Property.dimvalidforplan3 IS '- Used to store a property value for the "Valid For Plan3" property'
;
COMMENT ON COLUMN HS_Period_Property.dimvalidforworkforce IS '- Used to store a property value for the "Valid For Workforce" property'
;
COMMENT ON COLUMN HS_Period_Property.enumorder1 IS '- Used to store a property value for the "Plan1 Evaluation Order" property'
;
COMMENT ON COLUMN HS_Period_Property.enumorder2 IS '- Used to store a property value for the "Plan2 Evaluation Order" property'
;
COMMENT ON COLUMN HS_Period_Property.enumorder3 IS '- Used to store a property value for the "Plan3 Evaluation Order" property'
;
COMMENT ON COLUMN HS_Period_Property.enumordercapex IS '- Used to store a property value for the "Capital Asset Plan Evaluation Order" property'
;
COMMENT ON COLUMN HS_Period_Property.enumorderwf IS '- Used to store a property value for the "Workforce Evaluation Order" property'
;
COMMENT ON COLUMN HS_Period_Property.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Period_Property.plan1density IS '- Used to store a property value for the "Plan1 Density" property'
;
COMMENT ON COLUMN HS_Period_Property.plan2density IS '- Used to store a property value for the "Plan2 Density" property'
;
COMMENT ON COLUMN HS_Period_Property.plan3density IS '- Used to store a property value for the "Plan3 Density" property'
;
COMMENT ON COLUMN HS_Period_Property.workforcedensity IS '- Used to store a property value for the "Workforce Density" property'
;
COMMENT ON TABLE HS_Period_PropertyArray IS '- Sample table that contains property value for properties that use a dimension association for the Period dimension'
;
COMMENT ON COLUMN HS_Period_PropertyArray.key IS '- (required) The name of the member from the target dimension (the property being updated must use a dimension association)'
;
COMMENT ON COLUMN HS_Period_PropertyArray.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Period_PropertyArray.name IS '- (required) The name of the member whose properties are being updated'
;
COMMENT ON COLUMN HS_Period_PropertyArray.property IS '- (required) The name of the property to update (it must be one which uses a dimension association)'
;
COMMENT ON COLUMN HS_Period_PropertyArray.value IS '- (required for StringMap properties, such as Alias) The property value to set for the given key member name'
;
COMMENT ON TABLE HS_Scenario_Hierarchy IS '- Sample table that contains parent/child relationships for the Scenario dimension, along with property values'
;
COMMENT ON COLUMN HS_Scenario_Hierarchy.child IS '- (required) The name of the member to be updated'
;
COMMENT ON COLUMN HS_Scenario_Hierarchy.datastorage IS '- Used to store a property value for the "Data Storage" property'
;
COMMENT ON COLUMN HS_Scenario_Hierarchy.isprimary IS '- If this field is included, it is used to indicate whether the parent/child relationship is primary or not'
;
COMMENT ON COLUMN HS_Scenario_Hierarchy.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Scenario_Hierarchy.membervalidforcapex IS '- Used to store a property value for the "Valid For Capital Asset Plan" property'
;
COMMENT ON COLUMN HS_Scenario_Hierarchy.membervalidforplan1 IS '- Used to store a property value for the "Valid For Plan1" property'
;
COMMENT ON COLUMN HS_Scenario_Hierarchy.membervalidforplan2 IS '- Used to store a property value for the "Valid For Plan2" property'
;
COMMENT ON COLUMN HS_Scenario_Hierarchy.membervalidforplan3 IS '- Used to store a property value for the "Valid For Plan3" property'
;
COMMENT ON COLUMN HS_Scenario_Hierarchy.membervalidforworkforce IS '- Used to store a property value for the "Valid For Workforce" property'
;
COMMENT ON COLUMN HS_Scenario_Hierarchy.parent IS '- (required) The name of the parent of the member to be updated'
;
COMMENT ON COLUMN HS_Scenario_Hierarchy.sortorder IS '- (optional) A number indicating the order in which this member should appear among all of its sibling members'
;
COMMENT ON TABLE HS_Scenario_Property IS '- Sample table that contains dimension-level property values for the Scenario dimension'
;
COMMENT ON COLUMN HS_Scenario_Property.capexdensity IS '- Used to store a property value for the "Capital Asset Plan Density" property'
;
COMMENT ON COLUMN HS_Scenario_Property.dimdatastorage IS '- Used to store a property value for the "Data Storage" property'
;
COMMENT ON COLUMN HS_Scenario_Property.dimensionalias IS '- Used to store a property value for the "Dimension Alias" property'
;
COMMENT ON COLUMN HS_Scenario_Property.dimvalidforcapex IS '- Used to store a property value for the "Valid For Capital Asset Plan" property'
;
COMMENT ON COLUMN HS_Scenario_Property.dimvalidforplan1 IS '- Used to store a property value for the "Valid For Plan1" property'
;
COMMENT ON COLUMN HS_Scenario_Property.dimvalidforplan2 IS '- Used to store a property value for the "Valid For Plan2" property'
;
COMMENT ON COLUMN HS_Scenario_Property.dimvalidforplan3 IS '- Used to store a property value for the "Valid For Plan3" property'
;
COMMENT ON COLUMN HS_Scenario_Property.dimvalidforworkforce IS '- Used to store a property value for the "Valid For Workforce" property'
;
COMMENT ON COLUMN HS_Scenario_Property.enumorder1 IS '- Used to store a property value for the "Plan1 Evaluation Order" property'
;
COMMENT ON COLUMN HS_Scenario_Property.enumorder2 IS '- Used to store a property value for the "Plan2 Evaluation Order" property'
;
COMMENT ON COLUMN HS_Scenario_Property.enumorder3 IS '- Used to store a property value for the "Plan3 Evaluation Order" property'
;
COMMENT ON COLUMN HS_Scenario_Property.enumordercapex IS '- Used to store a property value for the "Capital Asset Plan Evaluation Order" property'
;
COMMENT ON COLUMN HS_Scenario_Property.enumorderwf IS '- Used to store a property value for the "Workforce Evaluation Order" property'
;
COMMENT ON COLUMN HS_Scenario_Property.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Scenario_Property.plan1density IS '- Used to store a property value for the "Plan1 Density" property'
;
COMMENT ON COLUMN HS_Scenario_Property.plan2density IS '- Used to store a property value for the "Plan2 Density" property'
;
COMMENT ON COLUMN HS_Scenario_Property.plan3density IS '- Used to store a property value for the "Plan3 Density" property'
;
COMMENT ON COLUMN HS_Scenario_Property.workforcedensity IS '- Used to store a property value for the "Workforce Density" property'
;
COMMENT ON TABLE HS_Scenario_PropertyArray IS '- Sample table that contains property value for properties that use a dimension association for the Scenario dimension'
;
COMMENT ON COLUMN HS_Scenario_PropertyArray.key IS '- (required) The name of the member from the target dimension (the property being updated must use a dimension association)'
;
COMMENT ON COLUMN HS_Scenario_PropertyArray.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Scenario_PropertyArray.name IS '- (required) The name of the member whose properties are being updated'
;
COMMENT ON COLUMN HS_Scenario_PropertyArray.property IS '- (required) The name of the property to update (it must be one which uses a dimension association)'
;
COMMENT ON COLUMN HS_Scenario_PropertyArray.value IS '- (required for StringMap properties, such as Alias) The property value to set for the given key member name'
;
COMMENT ON TABLE HS_SecurityClass_Hierarchy IS '- Sample table that contains parent/child relationships for the SecurityClass dimension, along with property values'
;
COMMENT ON COLUMN HS_SecurityClass_Hierarchy.child IS '- (required) The name of the member to be updated'
;
COMMENT ON COLUMN HS_SecurityClass_Hierarchy.isprimary IS '- If this field is included, it is used to indicate whether the parent/child relationship is primary or not'
;
COMMENT ON COLUMN HS_SecurityClass_Hierarchy.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_SecurityClass_Hierarchy.parent IS '- (required) The name of the parent of the member to be updated'
;
COMMENT ON COLUMN HS_SecurityClass_Hierarchy.sortorder IS '- (optional) A number indicating the order in which this member should appear among all of its sibling members'
;
COMMENT ON TABLE HS_SecurityClass_Member IS '- Sample table that contains members for the SecurityClass dimension'
;
COMMENT ON COLUMN HS_SecurityClass_Member.description IS '- Used to store a property value for the "Description" property'
;
COMMENT ON COLUMN HS_SecurityClass_Member.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_SecurityClass_Member.name IS '- (required) The name of the member to be added or updated'
;
COMMENT ON TABLE HS_SecurityClass_Property IS '- Sample table that contains dimension-level property values for the SecurityClass dimension'
;
COMMENT ON COLUMN HS_SecurityClass_Property.dimensionalias IS '- Used to store a property value for the "Dimension Alias" property'
;
COMMENT ON COLUMN HS_SecurityClass_Property.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON TABLE HS_SecurityClass_PropertyArray IS '- Sample table that contains property value for properties that use a dimension association for the SecurityClass dimension'
;
COMMENT ON COLUMN HS_SecurityClass_PropertyArray.key IS '- (required) The name of the member from the target dimension (the property being updated must use a dimension association)'
;
COMMENT ON COLUMN HS_SecurityClass_PropertyArray.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_SecurityClass_PropertyArray.name IS '- (required) The name of the member whose properties are being updated'
;
COMMENT ON COLUMN HS_SecurityClass_PropertyArray.property IS '- (required) The name of the property to update (it must be one which uses a dimension association)'
;
COMMENT ON COLUMN HS_SecurityClass_PropertyArray.value IS '- (required for StringMap properties, such as Alias) The property value to set for the given key member name'
;
COMMENT ON TABLE HS_SmartList_Hierarchy IS '- Sample table that contains parent/child relationships for a SmartList dimension, along with property values'
;
COMMENT ON COLUMN HS_SmartList_Hierarchy.child IS '- (required) The name of the member to be updated'
;
COMMENT ON COLUMN HS_SmartList_Hierarchy.isprimary IS '- If this field is included, it is used to indicate whether the parent/child relationship is primary or not'
;
COMMENT ON COLUMN HS_SmartList_Hierarchy.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_SmartList_Hierarchy.parent IS '- (required) The name of the parent of the member to be updated'
;
COMMENT ON COLUMN HS_SmartList_Hierarchy.sortorder IS '- (optional) A number indicating the order in which this member should appear among all of its sibling members'
;
COMMENT ON TABLE HS_SmartList_Member IS '- Sample table that contains members for a SmartList dimension'
;
COMMENT ON COLUMN HS_SmartList_Member.description IS '- Used to store a property value for the "Description" property'
;
COMMENT ON COLUMN HS_SmartList_Member.itemvalue IS '- Used to store a property value for the "Value" property'
;
COMMENT ON COLUMN HS_SmartList_Member.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_SmartList_Member.name IS '- (required) The name of the member to be added or updated'
;
COMMENT ON COLUMN HS_SmartList_Member.smartlistentrylabel IS '- Used to store a property value for the "Label" property'
;
COMMENT ON TABLE HS_SmartList_Property IS '- Sample table that contains dimension-level property values for the SmartList dimension'
;
COMMENT ON COLUMN HS_SmartList_Property.dimensionalias IS '- Used to store a property value for the "Dimension Alias" property'
;
COMMENT ON COLUMN HS_SmartList_Property.displayorder IS '- Used to store a property value for the "Display Order" property'
;
COMMENT ON COLUMN HS_SmartList_Property.gridmissinglabeltype IS '- Used to store a property value for the "#Missing Data Form Label" property'
;
COMMENT ON COLUMN HS_SmartList_Property.increments IS '- Used to store a property value for the "Increment" property'
;
COMMENT ON COLUMN HS_SmartList_Property.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_SmartList_Property.missinglabel IS '- Used to store a property value for the "#Missing Drop Down Label" property'
;
COMMENT ON COLUMN HS_SmartList_Property.smartlistlabel IS '- Used to store a property value for the "Label" property'
;
COMMENT ON COLUMN HS_SmartList_Property.startvalue IS '- Used to store a property value for the "Start Value" property'
;
COMMENT ON TABLE HS_SmartList_PropertyArray IS '- Sample table that contains property value for properties that use a dimension association for a SmartList dimension'
;
COMMENT ON COLUMN HS_SmartList_PropertyArray.key IS '- (required) The name of the member from the target dimension (the property being updated must use a dimension association)'
;
COMMENT ON COLUMN HS_SmartList_PropertyArray.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_SmartList_PropertyArray.name IS '- (required) The name of the member whose properties are being updated'
;
COMMENT ON COLUMN HS_SmartList_PropertyArray.property IS '- (required) The name of the property to update (it must be one which uses a dimension association)'
;
COMMENT ON COLUMN HS_SmartList_PropertyArray.value IS '- (required for StringMap properties, such as Alias) The property value to set for the given key member name'
;
COMMENT ON TABLE HS_Time_Hierarchy IS '- Sample table that contains parent/child relationships for the Time dimension, along with property values'
;
COMMENT ON COLUMN HS_Time_Hierarchy.child IS '- (required) The name of the member to be updated'
;
COMMENT ON COLUMN HS_Time_Hierarchy.datastorage IS '- Used to store a property value for the "Data Storage" property'
;
COMMENT ON COLUMN HS_Time_Hierarchy.isprimary IS '- If this field is included, it is used to indicate whether the parent/child relationship is primary or not'
;
COMMENT ON COLUMN HS_Time_Hierarchy.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Time_Hierarchy.parent IS '- (required) The name of the parent of the member to be updated'
;
COMMENT ON COLUMN HS_Time_Hierarchy.sortorder IS '- (optional) A number indicating the order in which this member should appear among all of its sibling members'
;
COMMENT ON TABLE HS_Time_Member IS '- Sample table that contains members for the Time dimension'
;
COMMENT ON COLUMN HS_Time_Member.bsomemberformula IS '- Used to store a property value for the "Member Formula(BSO)" property'
;
COMMENT ON COLUMN HS_Time_Member.consolidation IS '- Used to store a property value for the "Consolidation" property'
;
COMMENT ON COLUMN HS_Time_Member.description IS '- Used to store a property value for the "Description" property'
;
COMMENT ON COLUMN HS_Time_Member.fullyqualifiedsharedmember IS '- Used to store a property value for the "Fully Qualified Shared Member" property'
;
COMMENT ON COLUMN HS_Time_Member.hierarchytype IS '- Used to store a property value for the "Hierarchy Type" property'
;
COMMENT ON COLUMN HS_Time_Member.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Time_Member.membersolveorder IS '- Used to store a property value for the "Member Solve Order" property'
;
COMMENT ON COLUMN HS_Time_Member.name IS '- (required) The name of the member to be added or updated'
;
COMMENT ON COLUMN HS_Time_Member.primarylevelweighting IS '- Used to store a property value for the "Level Usage for Aggregation" property'
;
COMMENT ON COLUMN HS_Time_Member.twopasscalc IS '- Used to store a property value for the "Two Pass Calculation" property'
;
COMMENT ON COLUMN HS_Time_Member.uda IS '- Used to store a property value for the "UDA" property'
;
COMMENT ON TABLE HS_Time_Property IS '- Sample table that contains dimension-level property values for the Time dimension'
;
COMMENT ON COLUMN HS_Time_Property.allowduplicatesindimension IS '- Used to store a property value for the "Allow Duplicates In Dimension" property'
;
COMMENT ON COLUMN HS_Time_Property.bsomemberformuladuplicate IS '- Used to store a property value for the "BSO Member Formula" property'
;
COMMENT ON COLUMN HS_Time_Property.commentduplicate IS '- Used to store a property value for the "Comment" property'
;
COMMENT ON COLUMN HS_Time_Property.consolidationduplicate IS '- Used to store a property value for the "Consolidation" property'
;
COMMENT ON COLUMN HS_Time_Property.dimdatastorage IS '- Used to store a property value for the "Data Storage" property'
;
COMMENT ON COLUMN HS_Time_Property.dimensionalias IS '- Used to store a property value for the "Dimension Alias" property'
;
COMMENT ON COLUMN HS_Time_Property.dimensionhierarchytype IS '- Used to store a property value for the "Hierarchy Type" property'
;
COMMENT ON COLUMN HS_Time_Property.dimensionsolveorder IS '- Used to store a property value for the "Dimension Solve Order" property'
;
COMMENT ON COLUMN HS_Time_Property.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Time_Property.membersolveorderduplicate IS '- Used to store a property value for the "Member Solve Order" property'
;
COMMENT ON COLUMN HS_Time_Property.twopasscalcduplicate IS '- Used to store a property value for the "Two Pass Calculation" property'
;
COMMENT ON COLUMN HS_Time_Property.udaduplicate IS '- Used to store a property value for the "UDA" property'
;
COMMENT ON TABLE HS_Time_PropertyArray IS '- Sample table that contains property value for properties that use a dimension association for the Time dimension'
;
COMMENT ON COLUMN HS_Time_PropertyArray.key IS '- (required) The name of the member from the target dimension (the property being updated must use a dimension association)'
;
COMMENT ON COLUMN HS_Time_PropertyArray.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Time_PropertyArray.name IS '- (required) The name of the member whose properties are being updated'
;
COMMENT ON COLUMN HS_Time_PropertyArray.property IS '- (required) The name of the property to update (it must be one which uses a dimension association)'
;
COMMENT ON COLUMN HS_Time_PropertyArray.value IS '- (required for StringMap properties, such as Alias) The property value to set for the given key member name'
;
COMMENT ON TABLE HS_UDA_Hierarchy IS '- Sample table that contains parent/child relationships for a UDA dimension, along with property values'
;
COMMENT ON COLUMN HS_UDA_Hierarchy.child IS '- (required) The name of the member to be updated'
;
COMMENT ON COLUMN HS_UDA_Hierarchy.isprimary IS '- If this field is included, it is used to indicate whether the parent/child relationship is primary or not'
;
COMMENT ON COLUMN HS_UDA_Hierarchy.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_UDA_Hierarchy.parent IS '- (required) The name of the parent of the member to be updated'
;
COMMENT ON COLUMN HS_UDA_Hierarchy.sortorder IS '- (optional) A number indicating the order in which this member should appear among all of its sibling members'
;
COMMENT ON TABLE HS_UDA_Member IS '- Sample table that contains members for the UDA dimension'
;
COMMENT ON COLUMN HS_UDA_Member.description IS '- Used to store a property value for the "Description" property'
;
COMMENT ON COLUMN HS_UDA_Member.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_UDA_Member.name IS '- (required) The name of the member to be added or updated'
;
COMMENT ON TABLE HS_UDA_Property IS '- Sample table that contains dimension-level property values for a UDA dimension'
;
COMMENT ON COLUMN HS_UDA_Property.dimensionalias IS '- Used to store a property value for the "Dimension Alias" property'
;
COMMENT ON COLUMN HS_UDA_Property.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON TABLE HS_Value_Hierarchy IS '- Sample table that contains parent/child relationships for the Value dimension, along with property values'
;
COMMENT ON COLUMN HS_Value_Hierarchy.child IS '- (required) The name of the member to be updated'
;
COMMENT ON COLUMN HS_Value_Hierarchy.isprimary IS '- If this field is included, it is used to indicate whether the parent/child relationship is primary or not'
;
COMMENT ON COLUMN HS_Value_Hierarchy.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Value_Hierarchy.parent IS '- (required) The name of the parent of the member to be updated'
;
COMMENT ON COLUMN HS_Value_Hierarchy.sortorder IS '- (optional) A number indicating the order in which this member should appear among all of its sibling members'
;
COMMENT ON TABLE HS_Value_Member IS '- Sample table that contains members for the Value dimension'
;
COMMENT ON COLUMN HS_Value_Member.defaultparent IS '- Used to store a property value for the "Default Parent" property'
;
COMMENT ON COLUMN HS_Value_Member.description IS '- Used to store a property value for the "Description" property'
;
COMMENT ON COLUMN HS_Value_Member.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Value_Member.name IS '- (required) The name of the member to be added or updated'
;
COMMENT ON TABLE HS_Value_Property IS '- Sample table that contains dimension-level property values for the Value dimension'
;
COMMENT ON COLUMN HS_Value_Property.dimensionalias IS '- Used to store a property value for the "Dimension Alias" property'
;
COMMENT ON COLUMN HS_Value_Property.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON TABLE HS_Value_PropertyArray IS '- Sample table that contains property value for properties that use a dimension association for the Value dimension'
;
COMMENT ON COLUMN HS_Value_PropertyArray.key IS '- (required) The name of the member from the target dimension (the property being updated must use a dimension association)'
;
COMMENT ON COLUMN HS_Value_PropertyArray.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Value_PropertyArray.name IS '- (required) The name of the member whose properties are being updated'
;
COMMENT ON COLUMN HS_Value_PropertyArray.property IS '- (required) The name of the property to update (it must be one which uses a dimension association)'
;
COMMENT ON COLUMN HS_Value_PropertyArray.value IS '- (required for StringMap properties, such as Alias) The property value to set for the given key member name'
;
COMMENT ON TABLE HS_Version_Hierarchy IS '- Sample table that contains parent/child relationships for the Version dimension, along with property values'
;
COMMENT ON COLUMN HS_Version_Hierarchy.child IS '- (required) The name of the member to be updated'
;
COMMENT ON COLUMN HS_Version_Hierarchy.datastorage IS '- Used to store a property value for the "Data Storage" property'
;
COMMENT ON COLUMN HS_Version_Hierarchy.isprimary IS '- If this field is included, it is used to indicate whether the parent/child relationship is primary or not'
;
COMMENT ON COLUMN HS_Version_Hierarchy.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Version_Hierarchy.membervalidforcapex IS '- Used to store a property value for the "Valid For Capital Asset Plan" property'
;
COMMENT ON COLUMN HS_Version_Hierarchy.membervalidforplan1 IS '- Used to store a property value for the "Valid For Plan1" property'
;
COMMENT ON COLUMN HS_Version_Hierarchy.membervalidforplan2 IS '- Used to store a property value for the "Valid For Plan2" property'
;
COMMENT ON COLUMN HS_Version_Hierarchy.membervalidforplan3 IS '- Used to store a property value for the "Valid For Plan3" property'
;
COMMENT ON COLUMN HS_Version_Hierarchy.membervalidforworkforce IS '- Used to store a property value for the "Valid For Workforce" property'
;
COMMENT ON COLUMN HS_Version_Hierarchy.parent IS '- (required) The name of the parent of the member to be updated'
;
COMMENT ON COLUMN HS_Version_Hierarchy.sortorder IS '- (optional) A number indicating the order in which this member should appear among all of its sibling members'
;
COMMENT ON TABLE HS_Version_Member IS '- Sample table that contains members for the Version dimension'
;
COMMENT ON COLUMN HS_Version_Member.bsomemberformula IS '- Used to store a property value for the "Member Formula(BSO)" property'
;
COMMENT ON COLUMN HS_Version_Member.datatype IS '- Used to store a property value for the "Data Type" property'
;
COMMENT ON COLUMN HS_Version_Member.description IS '- Used to store a property value for the "Description" property'
;
COMMENT ON COLUMN HS_Version_Member.enableprocessmanagement IS '- Used to store a property value for the "Enable Process Management" property'
;
COMMENT ON COLUMN HS_Version_Member.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Version_Member.name IS '- (required) The name of the member to be added or updated'
;
COMMENT ON COLUMN HS_Version_Member.smartlist IS '- Used to store a property value for the "Smart List" property'
;
COMMENT ON COLUMN HS_Version_Member.uda IS '- Used to store a property value for the "UDA" property'
;
COMMENT ON COLUMN HS_Version_Member.versiontype IS '- Used to store a property value for the "Version Type" property'
;
COMMENT ON TABLE HS_Version_Property IS '- Sample table that contains dimension-level property values for the Version dimension'
;
COMMENT ON COLUMN HS_Version_Property.capexdensity IS '- Used to store a property value for the "Capital Asset Plan Density" property'
;
COMMENT ON COLUMN HS_Version_Property.dimdatastorage IS '- Used to store a property value for the "Data Storage" property'
;
COMMENT ON COLUMN HS_Version_Property.dimensionalias IS '- Used to store a property value for the "Dimension Alias" property'
;
COMMENT ON COLUMN HS_Version_Property.dimvalidforcapex IS '- Used to store a property value for the "Valid For Capital Asset Plan" property'
;
COMMENT ON COLUMN HS_Version_Property.dimvalidforplan1 IS '- Used to store a property value for the "Valid For Plan1" property'
;
COMMENT ON COLUMN HS_Version_Property.dimvalidforplan2 IS '- Used to store a property value for the "Valid For Plan2" property'
;
COMMENT ON COLUMN HS_Version_Property.dimvalidforplan3 IS '- Used to store a property value for the "Valid For Plan3" property'
;
COMMENT ON COLUMN HS_Version_Property.dimvalidforworkforce IS '- Used to store a property value for the "Valid For Workforce" property'
;
COMMENT ON COLUMN HS_Version_Property.enumorder1 IS '- Used to store a property value for the "Plan1 Evaluation Order" property'
;
COMMENT ON COLUMN HS_Version_Property.enumorder2 IS '- Used to store a property value for the "Plan2 Evaluation Order" property'
;
COMMENT ON COLUMN HS_Version_Property.enumorder3 IS '- Used to store a property value for the "Plan3 Evaluation Order" property'
;
COMMENT ON COLUMN HS_Version_Property.enumordercapex IS '- Used to store a property value for the "Capital Asset Plan Evaluation Order" property'
;
COMMENT ON COLUMN HS_Version_Property.enumorderwf IS '- Used to store a property value for the "Workforce Evaluation Order" property'
;
COMMENT ON COLUMN HS_Version_Property.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Version_Property.plan1density IS '- Used to store a property value for the "Plan1 Density" property'
;
COMMENT ON COLUMN HS_Version_Property.plan2density IS '- Used to store a property value for the "Plan2 Density" property'
;
COMMENT ON COLUMN HS_Version_Property.plan3density IS '- Used to store a property value for the "Plan3 Density" property'
;
COMMENT ON COLUMN HS_Version_Property.workforcedensity IS '- Used to store a property value for the "Workforce Density" property'
;
COMMENT ON TABLE HS_Version_PropertyArray IS '- Sample table that contains property value for properties that use a dimension association for the Version dimension'
;
COMMENT ON COLUMN HS_Version_PropertyArray.key IS '- (required) The name of the member from the target dimension (the property being updated must use a dimension association)'
;
COMMENT ON COLUMN HS_Version_PropertyArray.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Version_PropertyArray.name IS '- (required) The name of the member whose properties are being updated'
;
COMMENT ON COLUMN HS_Version_PropertyArray.property IS '- (required) The name of the property to update (it must be one which uses a dimension association)'
;
COMMENT ON COLUMN HS_Version_PropertyArray.value IS '- (required for StringMap properties, such as Alias) The property value to set for the given key member name'
;
COMMENT ON TABLE HS_View_Hierarchy IS '- Sample table that contains parent/child relationships for the View dimension, along with property values'
;
COMMENT ON COLUMN HS_View_Hierarchy.child IS '- (required) The name of the member to be updated'
;
COMMENT ON COLUMN HS_View_Hierarchy.isprimary IS '- If this field is included, it is used to indicate whether the parent/child relationship is primary or not'
;
COMMENT ON COLUMN HS_View_Hierarchy.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_View_Hierarchy.parent IS '- (required) The name of the parent of the member to be updated'
;
COMMENT ON COLUMN HS_View_Hierarchy.sortorder IS '- (optional) A number indicating the order in which this member should appear among all of its sibling members'
;
COMMENT ON TABLE HS_View_Member IS '- Sample table that contains members for the View dimension'
;
COMMENT ON COLUMN HS_View_Member.description IS '- Used to store a property value for the "Description" property'
;
COMMENT ON COLUMN HS_View_Member.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_View_Member.name IS '- (required) The name of the member to be added or updated'
;
COMMENT ON TABLE HS_View_Property IS '- Sample table that contains dimension-level property values for the View dimension'
;
COMMENT ON COLUMN HS_View_Property.dimensionalias IS '- Used to store a property value for the "Dimension Alias" property'
;
COMMENT ON COLUMN HS_View_Property.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON TABLE HS_View_PropertyArray IS '- Sample table that contains property value for properties that use a dimension association for the View dimension'
;
COMMENT ON COLUMN HS_View_PropertyArray.key IS '- (required) The name of the member from the target dimension (the property being updated must use a dimension association)'
;
COMMENT ON COLUMN HS_View_PropertyArray.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_View_PropertyArray.name IS '- (required) The name of the member whose properties are being updated'
;
COMMENT ON COLUMN HS_View_PropertyArray.property IS '- (required) The name of the property to update (it must be one which uses a dimension association)'
;
COMMENT ON COLUMN HS_View_PropertyArray.value IS '- (required for StringMap properties, such as Alias) The property value to set for the given key member name'
;
COMMENT ON TABLE HS_Year_Hierarchy IS '- Sample table that contains parent/child relationships for the Year dimension, along with property values'
;
COMMENT ON COLUMN HS_Year_Hierarchy.child IS '- (required) The name of the member to be updated'
;
COMMENT ON COLUMN HS_Year_Hierarchy.datastorage IS '- Used to store a property value for the "Data Storage" property'
;
COMMENT ON COLUMN HS_Year_Hierarchy.isprimary IS '- If this field is included, it is used to indicate whether the parent/child relationship is primary or not'
;
COMMENT ON COLUMN HS_Year_Hierarchy.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Year_Hierarchy.membervalidforcapex IS '- Used to store a property value for the "Valid For Capital Asset Plan" property'
;
COMMENT ON COLUMN HS_Year_Hierarchy.membervalidforplan1 IS '- Used to store a property value for the "Valid For Plan1" property'
;
COMMENT ON COLUMN HS_Year_Hierarchy.membervalidforplan2 IS '- Used to store a property value for the "Valid For Plan2" property'
;
COMMENT ON COLUMN HS_Year_Hierarchy.membervalidforplan3 IS '- Used to store a property value for the "Valid For Plan3" property'
;
COMMENT ON COLUMN HS_Year_Hierarchy.membervalidforworkforce IS '- Used to store a property value for the "Valid For Workforce" property'
;
COMMENT ON COLUMN HS_Year_Hierarchy.parent IS '- (required) The name of the parent of the member to be updated'
;
COMMENT ON COLUMN HS_Year_Hierarchy.sortorder IS '- (optional) A number indicating the order in which this member should appear among all of its sibling members'
;
COMMENT ON TABLE HS_Year_Member IS '- Sample table that contains members for the Year dimension'
;
COMMENT ON COLUMN HS_Year_Member.bsomemberformula IS '- Used to store a property value for the "Member Formula(BSO)" property'
;
COMMENT ON COLUMN HS_Year_Member.datatype IS '- Used to store a property value for the "Data Type" property'
;
COMMENT ON COLUMN HS_Year_Member.description IS '- Used to store a property value for the "Description" property'
;
COMMENT ON COLUMN HS_Year_Member.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Year_Member.name IS '- (required) The name of the member to be added or updated'
;
COMMENT ON COLUMN HS_Year_Member.smartlist IS '- Used to store a property value for the "Smart List" property'
;
COMMENT ON COLUMN HS_Year_Member.uda IS '- Used to store a property value for the "UDA" property'
;
COMMENT ON TABLE HS_Year_Property IS '- Sample table that contains dimension-level property values for the Year dimension'
;
COMMENT ON COLUMN HS_Year_Property.capexdensity IS '- Used to store a property value for the "Capital Asset Plan Density" property'
;
COMMENT ON COLUMN HS_Year_Property.dimdatastorage IS '- Used to store a property value for the "Data Storage" property'
;
COMMENT ON COLUMN HS_Year_Property.dimensionalias IS '- Used to store a property value for the "Dimension Alias" property'
;
COMMENT ON COLUMN HS_Year_Property.dimvalidforcapex IS '- Used to store a property value for the "Valid For Capital Asset Plan" property'
;
COMMENT ON COLUMN HS_Year_Property.dimvalidforplan1 IS '- Used to store a property value for the "Valid For Plan1" property'
;
COMMENT ON COLUMN HS_Year_Property.dimvalidforplan2 IS '- Used to store a property value for the "Valid For Plan2" property'
;
COMMENT ON COLUMN HS_Year_Property.dimvalidforplan3 IS '- Used to store a property value for the "Valid For Plan3" property'
;
COMMENT ON COLUMN HS_Year_Property.dimvalidforworkforce IS '- Used to store a property value for the "Valid For Workforce" property'
;
COMMENT ON COLUMN HS_Year_Property.enumorder1 IS '- Used to store a property value for the "Plan1 Evaluation Order" property'
;
COMMENT ON COLUMN HS_Year_Property.enumorder2 IS '- Used to store a property value for the "Plan2 Evaluation Order" property'
;
COMMENT ON COLUMN HS_Year_Property.enumorder3 IS '- Used to store a property value for the "Plan3 Evaluation Order" property'
;
COMMENT ON COLUMN HS_Year_Property.enumordercapex IS '- Used to store a property value for the "Capital Asset Plan Evaluation Order" property'
;
COMMENT ON COLUMN HS_Year_Property.enumorderwf IS '- Used to store a property value for the "Workforce Evaluation Order" property'
;
COMMENT ON COLUMN HS_Year_Property.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Year_Property.plan1density IS '- Used to store a property value for the "Plan1 Density" property'
;
COMMENT ON COLUMN HS_Year_Property.plan2density IS '- Used to store a property value for the "Plan2 Density" property'
;
COMMENT ON COLUMN HS_Year_Property.plan3density IS '- Used to store a property value for the "Plan3 Density" property'
;
COMMENT ON COLUMN HS_Year_Property.workforcedensity IS '- Used to store a property value for the "Workforce Density" property'
;
COMMENT ON TABLE HS_Year_PropertyArray IS '- Sample table that contains property value for properties that use a dimension association for the Year dimension'
;
COMMENT ON COLUMN HS_Year_PropertyArray.key IS '- (required) The name of the member from the target dimension (the property being updated must use a dimension association)'
;
COMMENT ON COLUMN HS_Year_PropertyArray.loadid IS '- (optional) The ID of the load group this dimension association belongs to, if any'
;
COMMENT ON COLUMN HS_Year_PropertyArray.name IS '- (required) The name of the member whose properties are being updated'
;
COMMENT ON COLUMN HS_Year_PropertyArray.property IS '- (required) The name of the property to update (it must be one which uses a dimension association)'
;
COMMENT ON COLUMN HS_Year_PropertyArray.value IS '- (required for StringMap properties, such as Alias) The property value to set for the given key member name'
;
COMMENT ON TABLE HS_Data_CapExTemplate IS '- Sample table to hold the data for a Capex Planning Application'
;
COMMENT ON COLUMN HS_Data_CapExTemplate.account IS '- the categorization of a capex budget planner data'
;
COMMENT ON COLUMN HS_Data_CapExTemplate.assetclass IS '- a type of asset category in account'
;
COMMENT ON COLUMN HS_Data_CapExTemplate.currency IS '- the reporting currency of this application '
;
COMMENT ON COLUMN HS_Data_CapExTemplate.data IS '- the data for this intersection'
;
COMMENT ON COLUMN HS_Data_CapExTemplate.entity IS '- the flow of Planning information through the organization of user'
;
COMMENT ON COLUMN HS_Data_CapExTemplate.lineitem IS '- the lowest level of detail in an account'
;
COMMENT ON COLUMN HS_Data_CapExTemplate.loadid IS '- an identifier provided by the user for filtering during import process'
;
COMMENT ON COLUMN HS_Data_CapExTemplate.period IS '- the specific time period of capital expenditure planning'
;
COMMENT ON COLUMN HS_Data_CapExTemplate.scenario IS '- the data category in this capital expenditure planning application'
;
COMMENT ON COLUMN HS_Data_CapExTemplate.version IS '- the possible outcome used within the context of a scenario of data.'
;
COMMENT ON COLUMN HS_Data_CapExTemplate.year IS '- the calendar year of planning'
;
COMMENT ON TABLE HS_Data_Consolidation IS '- Sample table to hold the data for a Consolidation Application'
;
COMMENT ON COLUMN HS_Data_Consolidation.account IS '- the hierarchy of natural accounts'
;
COMMENT ON COLUMN HS_Data_Consolidation.custom1 IS '- a user specified for analysis of detailed data'
;
COMMENT ON COLUMN HS_Data_Consolidation.custom2 IS '- a user specified for analysis of detailed data'
;
COMMENT ON COLUMN HS_Data_Consolidation.custom3 IS '- a user specified for analysis of detailed data'
;
COMMENT ON COLUMN HS_Data_Consolidation.custom4 IS '- a user specified for analysis of detailed data'
;
COMMENT ON COLUMN HS_Data_Consolidation.data IS '- the data for this intersection'
;
COMMENT ON COLUMN HS_Data_Consolidation.entity IS '- the organizational structure of the company for which consolidation'
;
COMMENT ON COLUMN HS_Data_Consolidation.icp IS '- the intercompany balances for an existing account'
;
COMMENT ON COLUMN HS_Data_Consolidation.loadid IS '- an identifier provided by the user for filtering during import process'
;
COMMENT ON COLUMN HS_Data_Consolidation.period IS '- the time period of consolidation'
;
COMMENT ON COLUMN HS_Data_Consolidation.scenario IS '- the scenario of the set of data for consolidation'
;
COMMENT ON COLUMN HS_Data_Consolidation.value IS '- the different types of values stored in the consolidation application'
;
COMMENT ON COLUMN HS_Data_Consolidation.viewdimension IS '- the mode of calendar intelligence for consolidation'
;
COMMENT ON COLUMN HS_Data_Consolidation.year IS '- the fiscal calendar year of consolidation'
;
COMMENT ON TABLE HS_Data_CurrencyRates IS '- Sample table to hold exchange rates'
;
COMMENT ON COLUMN HS_Data_CurrencyRates.exchangerate IS '- the value of conversion'
;
COMMENT ON COLUMN HS_Data_CurrencyRates.fromcurrency IS '- the currency source from which conversion is to happen'
;
COMMENT ON COLUMN HS_Data_CurrencyRates.loadid IS '- an identifier provided by the user for filtering during import process '
;
COMMENT ON COLUMN HS_Data_CurrencyRates.period IS '- the time period of exchange '
;
COMMENT ON COLUMN HS_Data_CurrencyRates.tocurrency IS '- the currency to which conversion needs to be done'
;
COMMENT ON COLUMN HS_Data_CurrencyRates.year IS '- the year of exchange'
;
COMMENT ON TABLE HS_Data_Sales IS '- Sample table to hold the sales data'
;
COMMENT ON COLUMN HS_Data_Sales.account IS '- the natural account for which sales data holds good'
;
COMMENT ON COLUMN HS_Data_Sales.amount IS '- the data in the sales transaction'
;
COMMENT ON COLUMN HS_Data_Sales.customer IS '- the customer who is involved in the transaction'
;
COMMENT ON COLUMN HS_Data_Sales.entity IS '- the entity for which sales data holds good'
;
COMMENT ON COLUMN HS_Data_Sales.loadid IS '- an identifier provided by the user for filtering during import process '
;
COMMENT ON COLUMN HS_Data_Sales.period IS '- the time period of sales'
;
COMMENT ON COLUMN HS_Data_Sales.product IS '- the product for which sales data holds good'
;
扫一扫
934
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
