A Name Definition is a definition for types and objects in Profitbase Studio and other Profitbase systems. It can e.g. be a column definition for a measure or dimension, or it can be a system name like language, module type etc.
Name Definitions consist of a unique ID (name like e.g. AccountID), a Name and a Description.
Items are grouped in categories for different use. Only items in some of these categories can be edited by the user, while others are for internal use.
All items Name and Description can be translated to different languages (although not all changes will be used). The language code itself has its own category and definition.
Each item can also be associated with a data type. This only applies if the item is used as a column in a data table, and when it is not a reserved system column.
Profitbase supplies a set of standard Name Definition Items. These cannot be deleted, but the name and description can be changed for editable categories. These will have $PB in the Created by field.
Item IDs are referenced through the data model in Profitbase Studio. This means that items that are in use, cannot be deleted.
Click the <Templates, Name Definitions> section and select Name Definitions to view the list of Name Definitions and Data Types.
The default tab selected is the Name Definition builder where all categories are displayed. When the "All" Category is selected, you may only add Language Definitions to some of the Name Definitions.
To define a new Name Definition, select a Category using the pull down menu.
Items in the following categories can be edited.
Calculated Cube Dimension Member |
This contains definitions for BL Columns for use in Cubes. |
Description |
By default this contains the standard Description Column. |
Dimension ID |
This contains definitions for Dimension IDs. It will be used as a Column Type in tables and in model definitions like Dimension Trees and BL. |
Dimension Name |
This contains names for Dimension IDs, Dimension Integer IDs and Dimension Properties in Data Source Dimension Tables. These names has a certain pattern using underscore(_) to separate id, name and language i.e. DimensionID_Name_EN-US. |
Dimension Property |
This contains definitions for Dimension Property IDs. It will be used as a Column Type in tables and in model definitions like Dimension Trees and BL. |
Dimension Type |
This is used for categorizing Dimension Tree types (in templates and solutions). |
Display Folder |
Predefine name of Display Folders for use in BL/Cubes. |
Item Not Found |
Define text used for item ids with no description. |
KPI |
This contains definitions for KPI IDs. It will be used in BL definitions for Cubes. |
Language |
This contains definitions for Language Codes. These codes must be official Microsoft Language Codes, e.g. EN for English, EN-US for US-English or FR for French (2 or 5 chars). |
Measure |
This contains definitions for Measures. It will be used as a Column Type in tables and in model definitions. Data Type can be changed to optimize solution. |
Module |
This defines Module Types used in templates and in Cube Measure Groups / Module Definitions. |
Named Set |
This contains definitions for Named Sets used in Cube scripts. |
Profitbase Reserved Keyword |
This is keywords used by the system. User can change data type. |
Solution Tag Placeholder |
This defines SQL placeholder tags used in Data Sources and Scripts. |
System |
This contains definitions for special items (system items) critical for the solution. It e.g. contains dimension id Company ID that is used in Dim.Keys, it contains Transdate that is required in fact tables etc. |
Time Dimension Attribute |
This contains Time Dimension Attributes |
Time Dimension Hierarchy | This contains Time Dimension Hierarchy |
Time Dimension Item | This contains Time Dimension Item |
Time Dimension Level Text | This contains Time Dimension Level Text |
Time Dimension Property | This contains Time Dimension Property |
Unknown from Fact Folder |
This contains definitions for Folders where ‘unknown from Fact’ items are stored in Dimension Trees after Cube processing. |
These are system definitions provided by Profitbase.
Aggregate Function |
This contains system definitions for Cube Measure Aggregate Functions used in Cube BL. |
Business Logic Type |
This contains categories for available business logic types used in BL. |
Calculated Cube Measure |
This contains predefined system definitions for Calculated Cube Measures. |
Calculated Fact Dimension |
This contains predefined system definitions for Calculated Fact Dimensions. |
Calculated Fact Measure |
This contains predefined system definitions for Calculated Fact Measures. |
Calendar Type |
This contains system definitions for supported Calendar Types. |
Connection Method |
This contains system definitions for how connections are handled, e.g. as SSIS, Linked Server or Direct. |
Connection Type |
This contains system definitions for Data Source Connection Types, e.g. MSSQL, File, Excel. |
CubeStorageMode |
This contains system definitions for supported Cube Partition Storage Modes. |
Data Warehouse Type |
This contains system definitions to support Teradata Data Warehouse databases. |
Day Formats |
This contains predefined system definitions for Day Formats. |
Dim Format |
This contains predefined system definitions for how dimension items are formatted (in dim trees). |
Dim Item Id |
This contains predefined system definitions for how dimension items is prefixed for uniqueness with Dimension Keys |
Dim Table Type |
NA - This contains system definitions for type of dimension tree. |
Dimension Mode |
This contains system definitions for supported Dimension Tree Modes, e.g. if Parent/Child, Level Based or Wide Dimension Tree. |
Dimension tag |
NA – reserved for Tags for use as place holders for Dimension Columns. |
Dimension Tree |
NA – reserved for Dimension Tree Type |
DW Process Group |
This contains system definitions for Data Warehouse Process Group Types. |
Expired |
System Items that are reserved but not in use/not supported are placed here. |
Fact Column Type |
This contains predefined system definitions for Indexes and Primary Keys used in Data Sources. |
Fact Function Types |
This contains predefined system definitions for Function Types used in Fact Management. |
Fact status update types |
This contains system definitions for dates used in fact table Reload and Update. |
Fact Table |
This contains system definitions for supported Fact Table Types |
Fact Update Mode |
This contains system definitions for supported fact table update modes (standard, incremental, full). |
Link Column Type |
This contains system definitions for Dimension Source mapping, e.g. if a column is ItemID, Description, ParentID or CompanyID. |
Module Group |
This contains system definitions for supported Module Group Types, e.g. if an OLAP, Sim or WebPlan module. |
Month Format |
This contains predefined system definitions for Month Formats. |
NA |
This contains the definition for the ‘Not in use’ item. |
Partition Boundary Type |
This contains system definitions for supported column types used for Partition Boundaries. |
Partition Type |
This contains predefined system definitions for supported Partitioning Types, e.g. Historic, Current |
Column Prefix and Suffix |
This contains predefined system definitions for Prefixes and Suffixes used on Name Definitions columns used in mostly Time Dimensions. |
Provider Type |
This contains system definitions for Provider Types, e.g. OLEDB, ODBC. |
Quarter Format |
This contains predefined system definitions for Quarter Formats. |
Sort Type |
This contains system definitions for supported Sort Types used in Dimension Trees. |
Staging Type |
This contains system definitions for supported Staging Types, e.g. 1 or 2 level staging types. |
Time Dimension Attribute Hierarchy |
This contains predefined system definitions for Time Dimension Attribute Hierarchies. |
Time Dimension Formatting |
This contains predefined system definitions for Time Dimension Formatting. |
Trade Calendar Week Type |
This contains predefined system definitions for Trade Calendar Week Types |
Week Format |
This contains predefined system definitions for Week Formats |
Weekday Format |
This contains predefined system definitions for Weekday Formats |
Select a Category. Click and enter the following information:
ID |
Enter a unique alpha and or numeric identification. No spaces and only alpha and numeric characters are allowed. |
Data Type |
Use the pull down list to select the Data Type. |
Name |
Define a Name for the item. |
Description |
Define a description for the item. |
Created |
The date the item was created. Date is automatically assigned by the system. |
Created by |
User who created the item; User name is automatically assigned by the system based on the User Login. |
Last Changed |
Date of last change. Date is automatically assigned by the system. |
Last Ch.By |
User who changed the item; User name is automatically assigned by the system based on the User Login. |
Below the Name Definition table is a section Language Settings.
When a row is selected in the Name Definition table, the language table will be filled with the selected item’s translations. Translations are applied to Names and Descriptions.
Click to define a new translation.
Language |
Select the language code. |
Name |
Translate the Name of the item. |
Description |
Translate the description of the item. |
Created |
The date the translation was created. Date is automatically assigned by the system. |
Created by |
User who created the translation; User name is automatically assigned by the system based on the User Login. |
Last Changed |
Date of last change. Date is automatically assigned by the system. |
Last Ch.By |
User who changed the translation; User name is automatically assigned by the system based on the User Login. |
Click on Save to save changes. Click on Delete to remove translation.
Next to the Select Category drop down list is a Translate button.
To translate Name Definitions, select a category from the Select Category drop down list and hit Translate. If you do not select a category, you will get a list of all the Name Definitions, which may be a very large list.
In the Name Definition Translation window, the Name Definition elements in the category you selected are displayed with their default Id, and optionally Name and Description.
For each of the languages defined in your Solution Database, the translated value for each Name Definition element is also displayed.
To translate an element, simply type a translation for each language and hit Save.
Using Excel to translate elements
You can copy and paste data between Excel and the Name Definition Translation window. By copying the Name Definitions which you want to translate into an excel sheet, you can send the sheet around the organization and then copy the result back into the Name Definition Translation window.
To copy data from the Name Definitions window to excel, select the records in the grid and hit Copy or Ctrl + C, and then paste into excel.
To copy data from excel to the Name Definitions window, do the following
Select the data you want to copy from excel.
Note that you cannot paste system defined values into the grid, meaning records with "System" in their column headers if you look in the Name Definition Translation window.
Put the caret in the field where you want the data to be copied into and hit Paste or Ctrl + V. This will copy the data record by record into the Name Definition Translation data grid.
Hit Save to save the translation definition to the database.
Select the Data Types tab to display the Data Types Builder. The following Data Types are defined:
NA |
Used as type for definitions that does not require a type. |
ID |
Used for all identifiers and properties. |
Date |
Used for Date and Time Stamp; Data is based on the ISO 8601 or US format where YYYY-MM-DD is the Date format and HH:MM:SS is the Time format, where HH is 0 to 24 hours and 00:00:00 is midnight. |
PBKey |
Used for numeric key. |
Standard Measure |
Number format for standard measure; normally for monetary values. Aggregate in cube. |
Description String |
Type for description string. |
Dimension |
Type for dimension name. |
Float |
Single-precision floating point - 32-bit. Aggregate in cube. |
Percent |
Percent defined as float. Does not aggregate in cube. |
Ratio |
Ratio is factor as regular number. Does not aggregate in cube. |
IntID |
Integer Dimension ID. Bigint data type by default. |
Clickand enter the following information to create a new Data Type:
ID |
The Data Type ID is automatically assigned by the system. |
Name |
Enter a unique Data Type name. This name will be used when defining Name Definitions. |
Description |
Enter a description if desired. |
Definition |
Enter a Data Type Definition. |
Created |
Date Data Type was created. Date is automatically assigned by the system. |
Created by |
User who created the Data Type; User name is automatically assigned by the system based on the User Login. |
Last Changed |
Date of last change. Date is automatically assigned by the system. |
Last Ch.By |
User who changed the Data Type; User name is automatically assigned by the system based on the User Login. |
Click onto save changes. Click onto remove Data Type.