Add UniversityID and the AdvisorEmailAddress to Stage.DimAdvisor and Final.DimAdvisor

File uploaded by cb0044644 on Feb 6, 2018Last modified by timothyharfield on Feb 6, 2018
Version 2Show Document
  • View in full screen mode

Customization Overview:


This customization adds two additional fields to the Stage.DimAdvisor and Final.DimAdvisor and provides both the UniversityID and the AdvisorEmailAddress columns. This modification along with the supporting stage procedures to update and maintain this data in the DimAdvisor tables via the ETL, enables a customization inside the SSAS cube exposing the two elements in a way that enables the Email from hierarchy feature within Pyramid publications.


Customization Contents:


  •   Custom.Sources
    • CustomSource.GOXEXCH
  •   Custom.Scripts
    • Alter.DimAdvisor.EmailAddress
    • Alter.DimAdvisor.UniversityID
  •   Custom.StoredProcedures
    • CustomStage.HelperDimAdvisorStage
  • readme.txt
  • DimAdvisor_Email.ppsx (PowerPoint Presentation covering SSAS customization)


  NOTE: The scripts in this file were generated by the following templates.


  •   Common.Create Custom Source Table.sql
  •   Common.Add Attribute to Dimension Table.sql