PerformancePoint 2007 Validate Measure Group

When loading data into PerformancePoint you need to validate dimensions, models, etc.

Here is the SQL syntax for validating a Measure Group.

DECLARE @return_value int
EXEC @return_value = [dbo].[bsp_DI_ValidateMeasureGroup]
@ModelName = N'<ModelSite Name>:<Measure Group Name>’,
@MeasureGroupTableName = N'<MeasureGroup TableName>‘,
@IncludeAnnotation = N’F’
SELECT ‘Return Value’ = @return_value

You can get the ModelSite Name from the Site Summary page in Planning Business Modeler.

PerformancePoint Validate Dimension syntax

When loading data into PerformancePoint you need to validate dimensions, models, etc.

Here is the SQL syntax for validating a dimension.

DECLARE @return_value int
EXEC @return_value = [dbo].[bsp_DI_ValidateDimension]
@DimensionName = N'<ModelSite Name>:<Dimension Name>’,
@CurrentSiteName = N'<ModelSite Name>’
SELECT ‘Return Value’ = @return_value
GO

You can get the ModelSite Name from the Site Summary page in Planning Business Modeler.

image

 

What does that PerformancePoint error code mean

When you validating your label tables in PerformanePoint, any errors are reported by  their error codes (ex 930).

If you would like a little more detail about what the error codes mean, then check out the dbo.SystemErrorDetails table.

It contains a list of error codes and descriptions.

This was a big help for me to determine what I doing wrong when trying to validate my data.

PerfomancePoint Server 2007, want to create dimensions from a csv file

When you create dimensions in PerformancePoint Server you have an option to create a dimension from a csv file.

This sounds like a great way to kick start your dimensions because you can take a csv file with data and upload it to create a dimension and  have it populated with some data.

Great idea, but only if you know the format of the csv file.
The first 2 rows are header records that must be there to define the dimension and hierarchy before you list the column headers.

See the screen shot below.

image
If you have data, go ahead and add it in, so you create the dimension you can also have it import your data to give you a head start.

PerformancePoint Server 2007, why can’t I synchronize dimensions/models

If you create an application in Performance Point and start creating dimensions/models and you notice Synchronize all dimensions to Staging Area.. is grayed out, you wonder what it is going on.

The problem is that your user is not in the Modeler Role.  Once your user is added to the role you will have no problem synchronizing.

I find this to be weird behavior since you just created the application (and app and staging database).  I would assume you be in the correct role to synchronize by default, but apparently that is not the case.

This through me for a loop because I was able to open other applications that I created and would have no trouble synchronizing.  I have to dig through the PerformancePoint Server Operations Guide.

I do also have SP3 installed.

Want to learn Performance Point Server 2007

If you’re interested in learning about Performance Point Server 2007, here are some links to start with.

Technet white papers (go ahead and read or skim over them).
http://technet.microsoft.com/en-us/library/bb794633.aspx

Video Tutorials on creating dashboards.
http://www.microsoft.com/business/performancepoint/learning/training.aspx

List of books that MS recommends as resources.
http://www.microsoft.com/business/performancepoint/learning/books.aspx

Performance Point Server, approval’s don’t work

When you create an approval workflow in Performance Point, it appears to work.  Unfortunately it doesn’t.  When a user submits an excel template, to an approval it actually save the data to the database.  You can the record in your fact table to see what happens.

This is too bad that doesn’t work.  This one of those easy pieces of functionality. that sells the whole product..

Performance Point BizSystemFlag and what they mean

My last blog focuses on what the BizSystemFlag field and what it needs to be to get data into the Application database.  So I figured I should mention what other values it can be and what they mean.

Here are the options:

0 – Do nothing with this record
100 – Record is already in the database
200 – New record to move to app database
300 – Updated record
400 – Record will be deleted
900+ – Error Code