Following lists contains reserved Profitbase Studio 6x definitions that may come in conflict with user modifications in upgraded PS 5x solutions.
Data Types are stored in the pbDataType table. User added definitions should have a DataTypeID >= 1000.
Data types 0-17 is reserved and continued from PS 52 SP5 solutions. PS6 adds reserved types from 18-31.
From PS 6.2 (january 2017 build) these are set back as owned by Profitbase with $PB in CreatedBy.
|
DataTypeID |
Name |
Description |
Definition |
|
0 |
NA |
Used as type for definitions that does not require a type. |
|
|
1 |
ID |
Used for all identifiers and properties, length supports dim.key |
nvarchar(50) |
|
2 |
DateTime |
Used for dates and timestamps |
datetime |
|
3 |
PBKey |
Used for numeric key |
int |
|
4 |
Standard Measure |
Number format for standard measure; normally for monetary values. Aggregate in cube |
decimal(18,2) |
|
5 |
Description String |
Type for description string |
nvarchar(100) |
|
7 |
Dimension |
Type for dimension name |
nvarchar(50) |
|
8 |
Float |
Float data type. Aggregate in cube |
float |
|
9 |
Percent |
Percent is defined as 18.25% = 18.25. Does not aggregate in cube |
float |
|
10 |
Ratio |
Ratio is factor as regular number. Does not aggregate in cube. |
float |
|
11 |
IntID |
Integer Dimension ID |
bigint |
|
12 |
Small Date |
Small DateTime to Time Dimension |
smalldatetime |
|
13 |
Small IntID |
Small Int Dim ID |
smallint |
|
14 |
Tiny IntID |
Tiny Int Dim ID |
tinyint |
|
15 |
Bool |
Boolean/Flag |
bit |
|
16 |
Expression |
Expression |
nvarchar(1000) |
|
17 |
Extended decimals |
Number format when needed extended number of decimals in calculations |
decimal(19,8) |
|
18 |
Unary Operator, Mod.Type |
Type for Unary Operator, Mod.Type |
varchar(10) |
|
19 |
Member Formula |
Type for Member Formula |
varchar(4096) |
|
20 |
Meta Data Type |
Meta Data Type |
nvarchar(256) |
|
21 |
Long Text |
Long Text |
nvarchar(1000) |
|
22 |
Decimal |
Decimal |
decimal(18,9) |
|
23 |
Integer |
Integer |
int |
|
24 |
DateTime |
DateTime |
datetime |
|
25 |
Date |
Date |
date |
|
26 |
TextID |
Text |
nvarchar(50) |
|
27 |
Text |
Text |
nvarchar(max) |
|
28 |
Boolean |
Boolean |
bit |
|
29 |
Money |
Money |
money |
|
30 |
Decimal3 |
decimal(18,3) |
decimal(18,3) |
|
31 |
Decimal9 |
decimal(18,9) |
decimal(18,9) |
Profitbase Studio uses Name Definitons for defining columns and enumerations. A Name Definition can have both an attached data type and translations.
Reserved 6x names in category 67 – P/C Dimensions, SKEY and system generated columns:
SolutionID, DataSourceID, DataSourceTableID, DimSourceTableID, DimTreeID, FactSourceTableID, Created, CreatedBy, LastChanged, LastChangedBy, LngID, NameDefinitionID, PBRowIdentity, RequiredColumn, ActiveFromDate, ActiveToDate, Changed, Expression, IsHoliday, WhereExpression.
SCDFromDate, SCDToDate, SKEY, SkeyVersionID, SkeyVersionRangeFrom, SkeyVersionRangeTo, ToSKEY
PCItemID, ItemID_basis, ItemID_SKEY, ParentItemID, ParentItemID_SKEY, Description_basis, AllowTrans, UnaryOperator, MemberFormula, ModifyType, InheritedParent, InUse, LevelNum, Rank, FromSKEYInvalidParent
Reserved 6x names in category 75- Time dimensions:
DateNo, DayNo, WeekNo, MonthNo, QuarterNo, TriAnnualNo, YearNo, WeekDay, WeekDayNo, WeekYearNo, DayOfYearNo, DayTypeHoliday, DayTypeID, DayTypeWEnd, DayTypeWork, MonthDays, YearMonthDayNo, YearMonthNo, YearWeekDayNo, YearWeekNo.
FI_DayNo, FI_WeekNo, FI_MonthNo, FI_QuarterNo, FI_TriAnnualNo, FI_YearNo, FI_WeekDay, FI_WeekDayNo, FI_WeekYearNo.
TR_DayNo, TR_WeekNo, TR_MonthNo, TR_QuarterNo, TR_TriAnnualNo, TR_YearNo, TR_WeekDay, TR_WeekDayNo, TR_WeekYearNo.