Google
 

Monday, August 11, 2008

PerformancePoint Server Consulting > Home

Rather than this approach, I would recommend creating an AppName_SourceDB SQL database for your application data and loading the CSV files into this source database.  The cut-paste method works, linked tables from Access, or the more robust SSIS ETL or your favourite ETL tool.

After the source database is created and tables populated, they can be added to the model by creating a Source Data connection in Planning Administrator.  Views in this SourceDB could be created to point directly to the source database, using linked servers and even synonyms for increased abstraction.  These views can be added to the Source Data connection.  The SourceDB acts as mapping warehouse and allows for ease of rerunning data and reuse for other purposes.

When the connection has been created, it can be loaded from the modeler by using the Load from Source Data

Dimensions

Load dimensions via .csv files:

The .csv file must adhere to the following format.

  • Cell a1 = ! dimension = dimension name
  • Cell a2 = ! hierarchy = All Members
  • Cell a3 = Label (value required)
  • Cell b3 = Name (value required)
  • Cell c3 = Description (value optional)

Values in the Label and Name columns are required. Values in the Description column are optional, but the header is required in the template.

PerformancePoint Server Consulting > Home

No comments: