Properties
| Properties |
UI equivalent |
|---|---|
| ActivityMeasure |
Measure property sheet, Rollup tab, Activity Measure box (when measure type is Category Count) Access: Read/Write |
| Aggregate |
Special Category property sheet, Relative Time tab, Basic Approach box Access: Read/Write |
| AllocationMeasure |
Dimension, Level, or Category property sheet, Allocation tab Access: Read |
| AllocationType |
Dimension, Level, or Category property sheet, Allocation tab Access: Read |
| AllowCurrencyConversion |
Measure property sheet, General tab, Allow Currency Conversion check box Access: Read/Write |
| AllowDrillThrough |
Object property sheet, Drill Through tab, Allow Drill Through For This Measure check box Access: Read/Write |
| AlternateQueryPath |
PowerCube property sheet, General tab, Source File box Access: Read/Write |
| Apex |
Diagram menu, Apex command (when a category in a view is selected) Access: Read/Write |
| Application |
Transformer user interface Access: Read |
| AssociationRole |
Dimension property sheet, General tab, External Rollup Column box (when the Contains Externally Rolled Up Measure Values check box is selected in the General tab of the Data Source property sheet) Level property sheet, Source tab Measure property sheet, Type tab (when Type option is set to Column) Currency Table property sheet, Base Table Columns box (when Use An External Currency Data Source check box is selected) Access: Read/Write |
| Associations |
Dimension property sheet, General tab, External Rollup Column box (when the Contains Externally Rolled Up Measure Values check box is selected in the General tab of the Data Source property sheet) Level property sheet, Source tab Measure property sheet, Type tab (when Type set to Column) Currency Table property sheet, Base Table Columns box (when Use An External Currency Data Source check box is selected) Access: Read |
| AssociationType |
Dimension property sheet, General tab, External Rollup Column box (when the Contains Externally Rolled Up Measure Values check box is selected in the General tab of the Data Source property sheet) Level property sheet, Source tab Measure property sheet, Type tab (when Type set to Column) Currency Table property sheet, Base Table Columns box (when Use An External Currency Data Source check box is selected) Access: Read/Write |
| BlankSubstitute |
Level property sheet, General tab, Blank Substitution box Access: Read/Write |
| BlockParentTotals |
PowerCube property sheet, Processing tab, Block totals for parents with excluded children check box Access: Read/Write |
| CacheCrossTabs |
PowerCube property sheet, Processing tab, Enable Crosstab Caching check box Access: Read/Write |
| CalculationDefinitions |
Dimension property sheet, Calculation tab Access: Read |
| CanAllocate |
Dimension, Level, Category property sheets (when Allocation tab is visible) Access: Read |
| CanAllocateByMeasure |
Object property sheet, Allocation tab, Select a Measure box Access: Read |
| CanAllocateMeasure |
Dimension, Level, Category property sheets, Allocation tab Access: Read |
| Categories |
Dimension diagram, category viewer Access: Read |
| Category |
Dimension diagram, category viewer Access: Read/Write |
| CategoryCount |
Edit menu, Show Counts command Access: Read |
| CategoryCountLevel |
Measure property sheet, Type tab, Dimension box and Level box (when Category Count button is selected) Access: Read/Write |
| CategorySets |
Dimension Category Calculation dialog box (accessed through Dimension property sheet, Calculation tab) Access: Read |
| CharacterType |
Data Source property sheet, Source tab, Character Set box Access: Read/Write |
| ChildCategories |
dimension diagram, category viewer Access: Read |
| ChildCubes |
PowerCubes list Access: Read |
| ChildCustomViews |
Custom Views list and Categories Viewer, Custom View tab |
| Code |
Category property sheet, General tab, Category Code box Access: Read/Write |
| Columns |
Data Sources list Access: Read |
| ColumnsLoaded |
Data Sources list Access: Read |
| Consolidate |
PowerCube property sheet, General tab, Consolidate box Access: Read/Write |
| Context |
Level property sheet, Order By tab, Drill-Down list Access: Read/Write |
| ContextLevel |
Special Category property sheet, Relative Time tab, Context Period box Access: Read/Write |
| ContextOffset |
Special Category property sheet, Relative Time tab, Context Offset box Access: Read/Write |
| ConvergenceLevel |
In the dimension map, the level at which two or more alternate drill-down paths meet Access: Read |
| Count |
None Access: Read |
| CountryCode |
Currency property sheet, Country Code role, or Currency Record dialog box, Country Code box Access: Read/Write |
| CubeCreation |
PowerCube property sheet, Processing tab, Cube Creation box, one of: Enabled, Disabled Access: Read/Write |
| Cubes |
PowerCubes list Access: Read |
| CubeStamp |
None |
| CurrencyDecimals |
Currency property sheet, Currency Record dialog box, Decimals box Access: Read/Write |
| CurrencyFormatOverride |
Currency property sheet, Currency Record dialog box, Override the Country Code check box Access: Read/Write |
| CurrencyIsEMU |
Currency property sheet, Currency Record dialog box, Member of the Economic and Monetary Union (EMU) check box Access: Read/Write |
| CurrencyIsEuro |
None Access: Read/Write |
| CurrencyRates |
Currency Table property sheet Access: Read |
| CurrencyRecord |
Currency property sheet, Currency Record dialog box Access: Read |
| CurrencyRecords |
Currency Table property sheet Access: Read |
| CurrencySymbol |
Currency property sheet, Currency Record dialog box, Currency Symbol box Access: Read/Write |
| CurrencyTable |
File menu, Currency Table command, Currency Table property sheet Access: Read |
| CurrencyTables |
File menu, Currency Table command, Currency Table property sheet Access: Read |
| CurrencyTableType |
Currency Table property sheet, Base Table or Euro Table Access: Read/Write |
| CurrentModel |
Help menu, About <model file name> command, File Name Access: Read |
| CustomViews |
CustomViews list and Categories Viewer, Custom View tab |
| DataCharacterSet |
Preferences property sheet, General tab, Data Character Set box Access: Read/Write |
| DataClass |
Object property sheet, General tab, Data Class box Access: Read/Write |
| DataRange |
New Data Source wizard or New Model wizard, Table or Range box Data Source property sheet, Source tab, Table or Range box Access: Read/Write |
| DataSourcePath |
Preferences property sheet, Directories tab, Data Source box Access: Read/Write |
| DataSources |
Data Sources list Access: Read |
| DataTemporaryFilesPath |
Preferences property sheet, Directories tab, Data Temporary Files (Dir1;Dir2) box Access: Read/Write |
| DateDegreeofDetail |
Column property sheet, Time tab, Degree of Detail box Access: Read/Write |
| DateDegreeofDetailLevelName |
Column property sheet, General tab, Degree of Detail box (when the Contains Externally Rolled Up Measure Values check box is selected in the General tab of the Data Source property sheet) Access: Read/Write |
| DateFormat |
Level property sheet (Date), Time tab, Date Format box Access: Read/Write |
| DateFunction |
Level property sheet (Date), Time tab, Date Function box Access: Read/Write |
| DateInputFormat |
Column property sheet, Time tab, Date Input Format box Access: Read/Write |
| DateLevel |
Currency Table property sheet, Currency Record dialog box, Date Level box Access: Read/Write |
| DateWizard |
Tools menu, Date Wizard command Access: Read |
| DecimalPoint |
Data Source property sheet (flat file data source type), General tab, Decimal Separator box Access: Read/Write |
| Decimals |
Column Object: None Access: Read |
| DefaultDateFormat |
Preferences property sheet, General tab, Default Date Format box Access: Read/Write |
| Description |
Object property sheet, Description tab Access: Read/Write |
| DesiredPartitionSize |
PowerCube property sheet, Auto-Partition tab, Desired Partition Size box Access: Read/Write |
| DetachDataSource |
Preferences property sheet, Files tab, Detach the Data Source after Generating Categories check box Access: Read/Write |
| DetailLevel |
PowerCube property sheet (Cube Group), Cube Group tab, Lowest Detail of Categories in the Level box Access: Read/Write |
| DimensionInclude |
Dimension diagram, left pane, User Class tab Access: Read/Write |
| DimensionLevels |
Dimension Map Access: Read |
| DimensionName |
Date Wizard Access: Write |
| Dimensions |
Dimension Map Access: Read |
| DimensionView |
Dimension diagram, User Class tab Access: Read |
| DimensionViewType |
PowerCube property sheet, Dimensions tab (when you right-click a dimension) Access: Read/Write |
| DrillCode |
Drill Category property sheet, Category Code box Access: Read/Write |
| DrillDowns |
Dimension Map Access: Read |
| DrillInclusion |
Drill Category property sheet, General tab, Inclusion box Access: Read/Write |
| DrillThroughTargets |
PowerCube property sheet, Drill Through tab, Custom Reports box Access: Read |
| DuplicateRollup |
Measure property sheet, Rollup tab, Duplicates Rollup box Access: Read/Write |
| DuplicateWeight |
Measure property sheet, Rollup tab, Duplicate Weight box Access: Read/Write |
| EarliestDate |
Date Wizard Dimension property sheet (Date), Time tab, Earliest Date box Run menu, Generate Date Categories command, Starting box Access: Write (Date Wizard) Read/Write (DateDimension) |
| EMUEntryDate |
Currency Table property sheet, Currency Record dialog box, Entry Date in the EMU (YYYYMMDD) box Access: Read/Write |
| EnableMessageLogging |
Preferences property sheet, Logging tab, Enable Message Logging check box Access: Read/Write |
| EnableTimePeriod |
Date Wizard Access: Write |
| EstimatedRows |
PowerCube property sheet, Auto-Partition tab, Estimated Number of Consolidated Records box Access: Read/Write |
| ExcludeAutoPartition |
Dimension property sheet, General tab, Exclude the Dimension from Auto-Partitioning check box Access: Read/Write |
| ExpressionText |
Column property sheet, General tab, Calculated option, Calculation button, Column Calculation box Dimension property sheet, Calculation tab, Add button, Calculation button, Dimension Category Calculation box Measure property sheet, Type tab, Calculated option, Calculation button, Measure Calculation box Access: Read/Write |
| External |
Data Source property sheet, General tab, Contains Externally Rolled Up Measure Values check box Access: Read/Write |
| FieldSeparator |
Data Source property sheet (flat file data source type), Source tab, Field Delimiter box Access: Read/Write |
| FileName |
Windows Explorer Access: Read/Write |
| Format |
Object property sheet, Format tab Access: Read/Write |
| FormatDecimals |
Measure property sheet, Format tab, Decimal Places box Access: Read/Write |
| FullName |
Windows Explorer Access: Read |
| GenerateCategories |
Data Source property sheet, General tab, Generate Categories check box Access: Read/Write |
| GenerateDateCategories |
Level property sheet (Date), Time tab, Generate All Categories in the Period check box (enabled when set to trGenerateDatesAll) Access: Read/Write |
| GeneratePowerCube |
Data Source property sheet, General tab, PowerCube Creation check box Access: Read/Write |
| GenerateTimePeriod |
Run menu, Generate Date Categories (when a time dimension is selected) Access: Read/Write |
| Group |
Calculation Definition box, Group Calculated Categories Together check box Access: Read/Write |
| GroupLevel |
PowerCube property sheet, Cube Group tab, Level box Access: Read/Write |
| HasSubdimension |
In the dimension map, a level that contains a subdimension has an ellipsis (...) next to its name Access: Read |
| Inclusion |
Object property sheet, General tab, Inclusion box Access: Read/Write |
| IncrementalUpdate |
PowerCube property sheet, Processing tab, This Cube is Incrementally Updated check box Access: Read/Write |
| InputScale |
Column property sheet, General tab, Input Scale box Access: Read/Write |
| IsAnyColumnMismatched |
Tools menu, Check Columns command Access: Read |
| IsBad |
File menu, View Suspended Models command Access: Read |
| IsExpressionValid |
OK button for Dimension property sheet, Calculation tab, Add or Modify button, Dimension Category Calculation dialog box Column property sheet, General tab, Calculation button, Column Calculation dialog box (when Column Type is set to Calculated) Measure property sheet, Type tab, Calculation button, Measure Calculation dialog box (when Measure Type is set to Calculated) Access: Read |
| IsManual |
In the dimension map, manual levels appear with a hand icon Access: Read |
| IsolationLevel |
Data Source property sheet, Source tab, Isolation Level box (when the data source is an IQD) New Model wizard Access: Read/Write |
| IsPrimary |
Object property sheet, General tab, Primary Drill Category check box Access: Read/Write (DateDrillDown and DrillDown) Read (Category) |
| KeyName |
Category property sheet, General tab, Source Value box Access: Read/Write |
| Label |
Object property sheet, General tab, <object> Label box Access: Read/Write |
| LastUseDate |
Object property sheet, General tab, Last Used On box Access: Read |
| LatestDate |
Date Wizard Date Dimension property sheet, Time tab, Latest Date box Run menu, Generate Date Categories command, Ending box Access: Write (DateWizard) Read/Write (DateDimension) |
| LevelDrillDowns |
Dimension Map, view of alternate drill-down paths Access: Read |
| Levels |
Dimension Map, view of levels in a dimension Access: Read |
| LocalPath |
Data Source property sheet, Source tab, Local Data File box Access: Read/Write |
| LogErrorLevel |
Preferences property sheet, Logging tab, one of four options: Severe Errors, Errors and Above, Warnings and Above, or Informational and Above Access: Read/Write |
| LogFileAppend |
Preferences property sheet, Logging tab, Append Logging Information check box Access: Read/Write |
| LogFileName |
Preferences property sheet, Logging tab, Log File Name box Access: Read/Write |
| LogFilesPath |
Preferences property sheet, Directories tab, Log Files box Access: Read/Write |
| Lunar |
none (use the Level property sheet, Time tab, Date Function box to determine the value) Access: Read/Write |
| ManualCurrentPeriod |
Dimension property sheet, Time tab, Automatically Set the Current® Time Period check box Access: Read/Write |
| MaximizeSpeed |
Data Source property sheet, General Tab, Uniqueness Verification box Access: Read/Write |
| MaxNumPartLevels |
PowerCube property sheet, Auto-Partition tab, Maximum Number of Passes box Access: Read/Write |
| MaxTransactionNumber |
Preferences property sheet, General tab, Maximum Number of Transactions per Commit box Access: Read/Write |
| MDCFile |
PowerCube property sheet, Output tab, PowerCube File Name box Access: Read/Write |
| MeasureInclude |
PowerCube property sheet, Measures tab Access: Read/Write |
| MeasureName |
PowerCube property sheet, General tab, Measure Name box Access: Read/Write |
| Measures |
Measures list Access: Read |
| MeasureType |
Measure property sheet, Type tab, one of Column, Calculated, or Category Count Access: Read |
| MissingValue |
Measure property sheet, General tab, Missing Value box Access: Read/Write |
| ModelName |
File menu, View Suspended Models command, Select Suspended Model box Access: Read/Write |
| ModelsPath |
Preferences property sheet, Directories tab, Models box Access: Read/Write |
| ModelTemporaryFilesPath |
Preferences property sheet, Directories tab, Model Temporary Files box Access: Read/Write |
| ModelType |
Windows Explorer Access: Read |
| MonthType |
Date Wizard Level property sheet (Date), Time tab, Date Function box Access: Write |
| Name |
Object property sheet, <object> Name box Object property sheet, <object> Label box Access: Read/Write Read (Application, Name, Report) |
| NewCatsLocked |
Object property sheet, General tab, Prohibit Automatic Creation of New Categories check box Access: Read/Write |
| Optimize |
PowerCube property sheet, Processing tab, Optimization box Access: Read/Write |
| OrderByDescending |
Level property sheet, Order By tab, Sort Order box Access: Read/Write |
| OrderByStorageType |
Level property sheet, Order By tab, Sort As box Access: Read/Write |
| Origin |
None Access: Read |
| OriginalName |
Object property sheet, General tab, Original Name box Access: Read |
| Orphanage |
Category property sheet, Orphanage check box Access: Read/Write |
| OutputScale |
Measure property sheet, General tab, Output Scale box Access: Read/Write |
| Parent |
Any hierarchical view in Transformer Access: Read |
| ParentCategories |
Dimension diagram, category viewer Access: Read |
| Partition |
Object property sheet, General tab, Partition Number box Access: Read/Write |
| Password |
PowerCube property sheet, Output tab, Password box Signon property sheet, General tab, Password box Access: Write |
| Path |
Windows Explorer Access: Read |
| PopulateByDataSource |
None Access: Read/Write |
| Position |
Column property sheet, General tab, Position box Access: Read/Write |
| PowerCubesPath |
Preferences property sheet, Directories tab, PowerCubes box Access: Read/Write |
| Precision |
Measure property sheet, Format tab, Precision box Access: Read/Write |
| QualifiedName |
Dimension map Access: Read |
| QuarterType |
Date Wizard Level property sheet (Date), Time tab, Date Function box Access: Write |
| QyPath |
Preferences property sheet, Directories tab, Model Temporary Files box Access: Read |
| Rate |
Currency Table property sheet Access: Read/Write |
| RefreshDescription |
Level property sheet, Source tab, Description Refresh check box Access: Read/Write |
| RefreshLabel |
Level property sheet, Source tab, Label Refresh check box Access: Read/Write |
| RefreshShortName |
Level property sheet, Source tab, Tag Refresh check box Access: Read/Write |
| RegularRollup |
Measure property sheet, Rollup tab Access: Read/Write |
| RegularWeight |
Measure property sheet, Rollup tab, Regular Weight box Access: Read/Write |
| ReverseSign |
Object property sheet, General tab, Reverse the Sign check box Access: Read/Write |
| Rollup |
Special Category property sheet, General tab, Category Rollup check box Access: Read/Write |
| RollupTiming |
Measure property sheet, Rollup tab, Regular Timing box (for a calculated measure) Access: Read/Write |
| RowsAsSample |
Preferences property sheet, AutoDesign tab, Number of Rows Used as a Sample box Access: Read/Write |
| RowsChecked |
Preferences property sheet, AutoDesign tab, Number of Rows Checked box Access: Read/Write |
| RunningPeriods |
Special Category property sheet, Relative Time tab, Number of Periods box (when Relative Time is set to Custom and Basic Approach is set to a running total) Access: Read/Write |
| Server |
PowerCube property sheet, Processing tab, Processed box Access: Read/Write |
| ServerModelPath |
Model property sheet, Server tab, Model Path box Access: Read/Write |
| ServerPath |
Data Source property sheet, Source tab, Server Data File box (when Data Source Location is set to Server) Access: Read/Write |
| ServerQuery |
Data Source property sheet, Source tab, Data Source Location box Access: Read/Write |
| ServicesBuildNumber |
About box Access: Read |
| ServicesVersionText |
About box Access: Read |
| SetsCurrentPeriod |
Data Sources property sheet, General tab, Sets the Current Period check box Access: Read/Write |
| ShortName |
Object property sheet, General tab, Short Name box Access: Read/Write |
| Signon |
PowerCube property sheet, Output tab, Signon box (when database type is set to a value other than Local) Access: Read/Write |
| Signons |
Signons list Access: Read |
| Size |
Column property sheet, General tab, Size box Access: Read/Write |
| Size (Model) |
Windows Explorer Access: Read |
| SortComparisonRule |
Preferences property sheet, General tab, Sort Comparison Rules box Access: Read/Write |
| SourceType |
Data Source property sheet, Source tab, Source Type box Access: Read/Write |
| SpecialCategoryCount |
Dimension map (second figure in brackets under the dimension name) Access: Read |
| SQLExpression |
Data Source property sheet, SQL View tab Access: Read |
| Status |
PowerCube property sheet, Processing tab, Status box Access: Read |
| StorageType |
Measure property sheet, General tab, Storage Type box Access: Read/Write |
| SummaryLevel |
PowerCube property sheet, Cube Group tab, Summarize All External Categories in the Level box Access: Read/Write |
| SuspendedModels |
File menu, View Suspended Models command, Select Suspended Model box Access: Read |
| TargetLevel |
Special Category property sheet, Relative Time tab, Target Period box (when Relative Time is set to Custom) Access: Read/Write |
| TargetOffset |
Special Category property sheet, Relative Time tab, Target Offset box (when Relative Time is set to Custom) Access: Read/Write |
| ThousandPoint |
Data Source property sheet, General tab, 1000 Separator box (for flat file data sources) Access: Read/Write |
| Time |
Windows Explorer Access: Read |
| TimeArrayColumn |
Column property sheet, Column Name box Access: Read/Write |
| TimeArrayStartMonth |
Column property sheet, Array tab, Start Month box Access: Read/Write |
| TimeArrayType |
Column property sheet, Array tab, Array Type box Access: Read/Write |
| TimeRank |
Level property sheet (Date), Time tab, Time Level Ranking box Access: Read/Write |
| TimeStateRollup |
Measure property sheet, Rollup tab, Time State Rollup box Access: Read/Write |
| TimeStateWeight |
Measure property sheet, Rollup tab, Time State Weight box Access: Read/Write |
| ToDateLevel |
Special Category property sheet, Relative Time tab, To-date Period box (when Relative Time is set to Custom) Access: Read/Write |
| Type |
None Access: Read |
| Unique |
Level property sheet, Source tab, Unique check box Access: Read/Write |
| UniqueMove |
Level property sheet, Source tab, Move check box Access: Read/Write |
| UserID |
Signon property sheet, General tab, User ID box Access: Read/Write |
| Version |
Help menu, About IBM® Cognos® PowerPlay® Transformer command, About Transformer box Access: Read |
| Views |
dimension diagram, Dimension tab or User Class tab Access: Read |
| ViewStatus |
Diagram menu, one of; Exclude, Cloak, Suppress, Summarize or Apex command (when a category in a view is selected) Access: Read/Write |
| ViewType |
PowerCube property sheet, Dimensions tab (right-click a selection) Access: Read/Write |
| WeekAdd |
Date Wizard Drill Category property sheet (Date), Time tab, Add an Extra Week box Access: Write (DateWizard) Read/Write (DateDrillDown) |
| WeekSpan |
Date Wizard Drill Category property sheet (Date), Time tab, Partial Weeks box Access: Write (DateWizard) Read/Write (DateDrillDown) |
| WeekStart |
Drill Category property sheet (Date), Time tab, Week Begins On box Access: Read/Write |
| WeekStartDay |
Date Wizard Access: Write |
| WorkingDay |
Date Wizard Dimension property sheet (Date), Time tab, Days in Week box Access: Write (DateWizard) Read/Write (DateDimension) |
| WorkingDays |
Date Wizard Dimension property sheet (Date), Time tab, Days in Week box Access: Write (DateWizard) Read/Write (DateDimension) |
| YearStartDay |
Date Wizard Drill Category property sheet (Date), Time tab, Year Begins box Access: Write (DateWizard) Read/Write (DateDrillDown) |
| YearType |
Date Wizard Level property sheet (Date), Time tab, Date Function box Access: Write |