MSDN Blog Postings » Blog Archive » PerformancePoint Server SP2: Hyper-V is supported

 

It is good to know that PerformancePoint Server (PPS) Service Pack 2 will support Hyper-V. The news is located on a Microsoft server software and supported virtualization environment list.

This article discusses the support policy for running Microsoft server software in the following supported virtualization environments:

• Windows Server 2008 with Hyper-V
• Microsoft Hyper-V Server 2008
• Server Virtualization Validation Program (SVVP)

MSDN Blog Postings » Blog Archive » PerformancePoint Server SP2: Hyper-V is supported

Availability of the Changelist field of Submissions table. - TechNet Forums

Tip from the forums:

From Planning Business Modeler | Process Management | Cycle Instance | Form | Select the Assignment on the Tasks you can Export the Change list as CSV files.   The exported file can be accessed outside the application.

Availability of the Changelist field of Submissions table. - TechNet Forums

The NAV/SQL Performance Field Guide - 3rd Edition - Dynamics NAV Performance on SQL - My Two Cents

 

While struggling with NAV/SQL performance issues for many years I scribbled down countless pages about various issues, learned by own experience or from colleagues, taken from numerous knowledgebase articles, whitepapers, etc. or heard in several webcasts.

In 2006 I started to put all this into a structured document, one I could use more straight in my optimization workshops - so "The NAV/SQL Performance Field Guide" was born. It's not a replacement of any official NAV/SQL documentation and requires some pre-knowledge about certain issues, but this "braindump" should give feasible advice and practical hints for the daily work with NAV and SQL.

The NAV/SQL Performance Field Guide - 3rd Edition - Dynamics NAV Performance on SQL - My Two Cents

Preprocessor commands for native code rules

System constants (preprocessor commands) within PerformancePoint rules are available here.

Preprocessor commands for native code rules

Kevin White's PerformancePoint Blog : A brief overview of PerformancePoint Planning business rules

Kevin talks about the different types of business rules in PerformancePoint.

I have described the behavior of PPS rule sets below. Any rules that are added in these rule sets follows the described behavior.

Kevin White's PerformancePoint Blog : A brief overview of PerformancePoint Planning business rules

Developing for Dynamics GP : Microsoft Dynamics GP Blogs

 

This page contains links to blogs relating to Microsoft Dynamics GP

Developing for Dynamics GP : Microsoft Dynamics GP Blogs

The Microsoft PerformancePoint Team Blog : Working with the Monitoring CSS Files to Adjust Settings in Deployed Dashboards

 

PerformancePoint Monitoring server has a few style sheets that can be adjusted in order to modify settings in your deployed dashboards.

The Microsoft PerformancePoint Team Blog : Working with the Monitoring CSS Files to Adjust Settings in Deployed Dashboards

Snatched Moments - Create a NativeSQL Business Rule

It is usually recommended that all rules be written in PerformancePoint Expression Language (PEL) in to ensure upgrade compatibility.

However, some rules (either throwaway or complex) need to be driven by either Native SQL or MDX code.

Here is a blog posting outlining how to write a Native SQL rule.

In some difficult situations you might want to use NativeSQL to implement a business rule. It gives you the full power of SQL Server.

First you need to create the rule in the Business Modeler to host the NativeSQL business rule. You can use parametres and even use members of dimensions as parameters. When it is time to execute the business rule the user gets a nice interface where the user is able to select the parameter in the dimension.

In the SQL it is the memberId of the dimension that is passed into the function and they are of the type int. A start of an implementation can be seen here:

create proc Calc.[sp$procedure] @entity int, @scenario int, @startTimePeriod int, @endTimePeriod int as

It looks almost as a normal stored procedure in SQL. The only difference is that the name is a preprocessor commands and the Performancepoint translate this to a real stored procedure name, when it is created by the Performancepoint in the SQL Server. The rest of the parametres is just like a normal stored procedure.

Snatched Moments - Create a NativeSQL Business Rule