Business Intelligence VPC Release 6.0 Download


We can download the fully configured VPC with loads of sample applications (by Vertical e.g. Government, Retail, Finance etc…) from the below link. This will really be useful for users who are in the process of evaluating the features of the complete Microsoft BI stack and how each component integrates with each other. I am in the process of downloading it and have not reviewed yet. However by seeing the list of items which are pre-configured it really seems worth exploring.

image

http://www.microsoft.com/sverige/partner/market/marknadskampanjer/dbp.mspx

image

I will keep posting the useful information from this VPC for the reference.

– Ajay Singh

Advertisements

Alpine Ski House sample application OLAP Databases not visible in Dashboard Designer


After installing the Alpine Ski House sample application I deployed all the Model Sites and I was able to see the corresponding OLAP databases created in SQL Server Management Studio.

image

However when I went into Dashboard Designer I was not able to see any of these OLAP databases. After some research I found that we need to give role permission to ‘NETWORK SERVICE’ account in order to make it available for Scorecard Setup.

I did this for ‘Alpine_Ski_House_ASH_Corporate’ database.

image

And after that this database was available in Dashboard Designer.

image

Need to further check on this why it is needed, however if anyone is facing this issue then this is the solution I have as of now.

– Ajay Singh

Deleting Application in PPS


Deleting an application in PerformancePoint Server from Planning Business Modeler or Administration Consol will not delete the underlying Relational Databases and OLAP Databases. We have to manually delete these using SQL Server Management Studio.

Recently I installed ‘Alpine Ski House‘ sample application and then deleted this application from ‘Planning Business Modeler‘. However the relational Databases and OLAP Databases were still there.

image

image

– Ajay Singh