Name Definitions

About Definitions

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.

Note
Changing an Items definition may affect the system. If e.g. changing a data type, the system must be rebuilt for the change to take effect.

How to

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.

Categories

Editable categories

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.


Read-only/system categories

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.

Add / Delete Language

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.

Translate

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

  1. 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.

  2. 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.

Data Types

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.