Skip Ribbon Commands
Skip to main content
SharePoint
Last modified at 8/31/2015 10:04 AM by Peter Scordamaglia

​​​[back to Pulse BI Wiki]

 

Configuration


This page describes the configuration of the data warehouse.  This page contains following sections:

  1. Settings.  This section describes to the generic settings.
  2. Marts.  This section describes the data mart configuration.
  3. Cubes.  This section describes the cube configuration.
  4. Cube Partitions.  This section describes cube partition configuration.
  5. Dimensions.  This section describes dimension configuration.
  6. Dimension Partitions.  This section describes dimension partition configuration.​
  7. Files.  This section describes staging file configuration.​​​
  8. Dictionary.  This section describes the data dictionary - attributes and measures.
  9. Lookups.  This section describes lookup value configuration.

 

Settings


This section describes the generic settings.  The settings are placed into the XML file, and the following tags are used for configuration:

 

​<?xml version="1.0"?>
​<Settings>
​<SQL>
​<SQLServer>BIDEV</SQLServer>​The name of the SQL Server that holds the data warehouse database, e.g. "BIDEV".
​<SQLDatabase>PulseBI</SQLDatabase>​The name of the SQL Server database for data warehouse, e.g. "PulseBI".
​</SQL>
​<SSAS>
​<SSASServer>BIDEV</SSASServer>​The name of the SSAS Server that holds the data mart database, e.g. "BIDEV".
​<SSASDatabase>PulseBI</SSASDatabase>​The name of the SSAS database, e.g. "PulseBI".
​</ErrorHandling>
​<From>Name@EMailAddress1</From>​The Email Address that any error messages will appear to come from.

​​<CCTo>Name@EmailAddress1,2</CCTo>​The Email Address(es) that any error messages will be sent to.​

​<BCCTo>Name@EmailAddress1,2</BCCTo>​​The Email Address(es) that any error messages will be blind copied to.
​<SMTPServer>SMTPServer1</SMTPServer>​The Simple Mail Transport Server Addres that the account that is running
Pulse BI is allowed to relay through. 
​</ErrorHandling>
​</Settings>
​                                  
Note 1: Format can be one of fully formated ("Name <Name@EmailAddress>") or Name@EmailAddress.
Note 2: Multiple Email Addresses can be used, but MUST be comma seperated AND enclosed in quotes. e.g. "Name1.EmailAddress","NiceName <Name2@EmailAddress>".

This section describes the data mart configuration.  The settings are maintained in the Pulse_BI_Data_Dictionary.xlsx spreadsheet, and are saved to the PulseBI\cfg\Mart.csv configuration file.  PulseBI tool loads the configuration into the data warehouse.  The configuration items are provided in the table below:

 

​Configuration Item​Description
​Data Mart Group​The data mart group.
Data Mart​The name of the data mart, e.g. "Enrollment".
​Data Mart Description​The description of the data mart.
 

 

Cubes


This section describes the cube configuration.  The settings are maintained in the Pulse_BI_Data_Dictionary.xlsx spreadsheet, and are saved to the PulseBI\cfg\Cube.csv configuration file.  PulseBI tool loads the configuration into the data warehouse.  The configuration items are provided in the table below:

 

​Configuration Item​Description
​Data Mart​The name of the data mart, e.g. "Enrollment".  It should match with the Data Mart item in Mart.csv configuration file.
​Cube​The name of the cube in the data mart, e.g. "Enrollment".  A data mart might have multiple cubes.
​Cube Description​The description of the cube.
​Refresh​A flag indicating whether the cube should be refreshed, can be "Y" or "N".
  

 

Cube Partitions


This section describes the partition configuration.  The settings are maintained in the Pulse_BI_Data_Dictionary.xlsx spreadsheet, and are saved to the PulseBI\cfg\CubePartition.csv configuration file.  PulseBI tool loads the configuration into the data warehouse.  The configuration items are provided in the table below:

 

​Configuration Item​Description
​Data Mart​The name of the data mart, e.g. "Enrollment"
​Cube​The name of the cube, e.g. "Enrollment"
​Measure Group​The name of the measure group in the cube, e.g. "Student Term"
​Partition​The name of the partition of the measure group, e.g. "Student Term 2014-2015"
​Refresh​Whether the partition should be refreshed, can be "Y" or "N"
 

 

 

Dimensions


This section describes the dimension configuration.  The settings are maintained in the Pulse_BI_Data_Dictionary.xlsx spreadsheet, and are saved to the PulseBI\cfg\Dimension.csv configuration file.  PulseBI tool loads the configuration into the data warehouse.  The configuration items are provided in the table below:

 

​Configuration Item​Description
Dimension​The name of the dimension, e.g. "Student"
​Dimension Description​The description of the dimension
​Refresh

​Whether the dimension should be refreshed, can be "Y" or "N"

​Update Type​The update type for the dimension, could be "None", Replace", or "Update"
​Partition Update​Whether the update will only be completed on the supplied partition, e.g. "Y" or "N".
Has History Whether the Dimension has a related History table, can be Y' or"N".
 


Dimension Partitions


This section describes the dimension partitoin configuration.  The settings are maintained in the Pulse_BI_Data_Dictionary.xlsx spreadsheet, and are saved to the PulseBI\cfg\DimensionPartition.csv configuration file.  PulseBI tool loads the configuration into the data warehouse.  The configuration items are provided in the table below:

 

​Configuration Item​Description
Datamart​The Datamart the Dimension Belongs to.
​DimensionThe name of the dimension, e.g. "Student"
​PartitionThe values the Dimension is partitioned on.
​Refresh​Which partition value should be refreshed, can be "Y" or "N"
 

​ 

Files​


This section describes the staging file configuration.  The settings are maintained in the Pulse_BI_Data_Dictionary.xlsx spreadsheet, and are saved to the PulseBI\cfg\files.csv configuration file.  PulseBI tool loads the configuration into the data warehouse.  The configuration items are provided in the table below:

 

​Configuration Item​Description
​DataMartThe name of the DataMart the dimension belongs to.​
Dimension​The name of the dimension, e.g. "Student"
Staging Base File Name​The beginning file name value for staging data. 
​IsPrimary

Declares the first, or Primary FileCode. Can be "Y" or "N". Only One FileCode should be listed as Primary.

​FileCode


 

Dictionary


This section describes the data dictionary - attributes and measures.  The settings are maintained in the Pulse_BI_Data_Dictionary.xlsx spreadsheet, and are saved to the PulseBI\cfg\Dictionary.csv configuration file.  PulseBI tool loads the configuration into the data warehouse.  The configuration items are provided in the table below:

 

​Configuration Item​Description
​Measure Group / Dimension​The name of the measure group or dimension, e.g. "Student"
​Category, Measure/Attribute​The name of the measure or attribute.  Categories are ignored.
​Measure/Attribute Description​The description of the measure or attribute.
​Database Field​Define a colum as taking input/receiveing data from another table (Overrides Attribute)
​Friendly/Displayed Name​Allow the Attribute Filed ot have a more Human-Friendly Display Name.
​Col​The column the attribute is in the data file.
​Req​Whether the attribute value is required or not, can be "Yes", "-", or "n/a" if not applicable.
​Data Type ​The data type of the attribute, e.g. "varchar(100)".  Can be "varchar(1)", "varchar(30)", "varchar(100)", "datetime", "integer", "numeric(18,3)"
​Type​The type of the column, can be "Attribute", "Deleted", "Foreign", "Hierarchy", "Lookup", "Measure", "Msr/Attr", "Partition", "Primary"
​FileCode​The FileCode a column 'belongs' to. This creates the mutiple staging tables.
​FileCode Col​Allows a Dimesion wiht MultipleFILEcodes ot have custom column Ordering (for inserts et al.).
​Ref1​Additional information about the column.  For "Foreign" type it is the name of the dimension to which the foreign key points to.  For "Lookup" it is the source field to use in the calculation.
​Ref2​Additional information about the column.  For "Lookup" it is the lookup reference to use in calculation.
 

 

 

Lookups


This section describes lookup value configuration.  The settings are maintained in the Pulse_BI_Data_Dictionary.xlsx spreadsheet, and are saved to the PulseBI\cfg\Lookup.csv configuration file.  PulseBI tool loads the configuration into the data warehouse.  The configuration items are provided in the table below:

 

​Configuration Item​Description
​Reference​The reference to use for the lookup conversion
​Comparison​The comparison to use, could be "Less Than", "Greater Than", "Between", or "NULL".
​From​Used as the first argument in the "Between" comparison, and as the argument in the "Greater Than" comparison.
​To​Used as the second argument in the "Between" comparison, and as the argument in the "Less Than" comparison.
​Value​The value to assign if the condition is satisfied.
  

​​