File Library


Practical SQL for EPM Practitioners
Topic: EPM Foundations & Data Management
Owner: Cameron Lackpour
Date: 2013-05-26
Subtopic: Best Practices

Why am I not picking a tool?
_Techniques are universal
_Studio, EAS, ODI, EPMA, whatever are not
_Apply the concepts to your tool of choice
Building dimensions
_Level
_Generation
_Parent/Child
_Finding orphaned data
Loading data
_Normalizing the denormal with JOINS galore
_Ignoring the unloadable
_Dynamic loading through Essbase Substitution Variables
_Mapping, SUMming, and calculating
Extracting
_Common Essbase data and metadata extraction techniques
_Mining EPM repositories for precious data
Integrating
_Use a common meta data source for heterogeneous targets


Download File   CLackpour.PracticalSQLForEPMDevelopers.pdf
Download File   Grand Ballroom E Session 08.mp4

Become a member of ODTUG to gain access to more than 12,500 files in our technical database.

  • Not a member? Click through to the topic of interest to browse a list of available presentations.
  • Already a member? Log-in here to access the full database


Click here to see the Full Techincal Resource Database