Radosław's profileRadoslaw Lebkowski's Blo...PhotosBlogListsMore  |  Tools Help |
|
|
April 08 Service Pack 1 for Microsoft SQL Server 2008 is now availableService Pack 1 for Microsoft SQL Server 2008 is now available.
More details are available here:
Setup files you can download from the following site:
http://www.microsoft.com/downloads/en/default.aspx January 25 PerformancePoint 2007 to become part of Microsoft Office SharePoint Server 2007 EnterpriseMicrosoft is announcing an update to its Microsoft Business Intelligence roadmap. Microsoft’s strategy is to deliver BI to everyone in the organization through the broadly adopted tools of Microsoft Office SharePoint Server and Microsoft Office Excel, and built on the scalable Microsoft SQL Server BI platform. PerformancePoint Server 2007 will no longer be a standalone item on the Microsoft price list as of April 1, 2009. For organizations interested in PerformancePoint Server, it can be obtained by purchasing SharePoint Server 2007 Enterprise CAL with Software Assurance. In the future, the monitoring and analytics capabilities will be included in the next release of SharePoint Server (PerformancePoint Services) and will be available to SharePoint Enterprise CAL customers. In mid 2009, will be released PerformancePoint Server 2007 “service pack 3” which will include updates to the current product’s planning module. If you want more details watch the video with Guy Weismantel, Director of Microsoft BI:
Microsoft BI roadmap update January 20 PerformancePoint Server 2007 SP2 available in polish languageService Pack 2 for PerformancePoint server 2007 is now available also in polish language.
Setup files you can download from the following sites:
Dodatek Service Pack 2 do programu PerformancePoint Server 2007 (x64) Dodatek Service Pack 2 do programu PerformancePoint Server 2007 (x86) December 09 PerformancePoint Server 2007 Service Pack 2 now availableI would like to announce that Service Pack 2 for PerformancePoint Server 2007 is ready for download. With this new Service Pack, customers will see improved query performance in PerformancePoint Server scorecards, support for SQL Server 2008, increased compatibility with Windows Server 2008, including support for Windows Server 2008 Hyper-V, and more filtering capabilities for PerformancePoint Server dashboards. These enhancements boost the already robust capabilities of PerformancePoint Server 2007, enabling organizations to effectively monitor, analyze, and plan their business.
For more information on Service Pack 2, see Microsoft Office PerformancePoint Server 2007 on TechNet.
More details about SP2 you can find here: Download SP2:
December 04 Another articles about Microsoft Office PerformancePoint Server on polish Microsoft Technet
November 28 Invalid Member Property names in PerformancePoint Server 2007 Planning and Budgeting
Total time elapsed: 13.23 seconds November 24 SQL Server 2008 Analysis Services Performance Guide now availableI would like to announce that is now available updated version of whitepaper about performance optimization techniques for SQL Server 2008 Analysis Services.
This white paper describes how application developers can apply query and processing performance-tuning techniques to their SQL Server 2008 Analysis Services OLAP solutions, e.g. enhancing MDX query performance, enhancing processing performance and tunning SSAS server resources.
November 03 B.I. the way...A few days ago Norm Warren started new blog about technical issues in PerformancePoint Server 2007 - "B.I. the way..." PerformancePoint Server documentation team Blog. The Blog is available here:
September 21 PerformancePoint Server version numbersIf you are not sure what version of PerformancePoint Server do you use (with SP1 installed or without it), you can resolve your problem by visiting the following web sites. It’s very useful and timesaving way to have all version numbers gathered in one place. Tim Kent did this great work on his Blog. So, if you know that your PPS version is 3.0.3520.00, but you would like to know some other details about it, just refer to the following page: PerformancePoint Version Numbers - Tim Kent's Blog There is also one other place, where are listed PerformancePoint earlier versions (before CTP3). http://technet.microsoft.com/en-us/library/cc298347.aspx I hope you will find this information useful. July 24 New series of my articles about Microsoft Office PerformancePoint Server on Microsoft Technet
July 17 Updating PerformancePoint Server 2007 with SP1 – step by step instructions
July 12 Installing Service Pack 1 for PerformancePoint Server 2007 on Domain ControllersI reviewed log files and server’s event log, but I didn’t find any additional information. To install PerformancePoint Server on domain controllers you need to use some additional settings while running installation (SKIPOSCHECK=true in command line).
http://bimvp.com/blogs/bsm/archive/2008/04/23/installing-pps-on-a-domain-controller.aspx
The same restriction concerns to SP1 for PerformancePoint Server.
If you want to upgrade your PerformancePoint Server installed on domain controller, you need to run setup from command line with parameter SKIPOSCHECK=True.
Install the Planning server MSP using this command line:
PPLSrv.msp SKIPOSCHECK=true
Install the Monitoring server MSP using this command line:
PSCSrv.msp SKIPOSCHECK=true
After using above commands installing SP1 on my demo environment (Business Intelligence VPC Release 6) was successful.
And please note that installing PerformancePoint Server 2007 on domain controllers July 09 The PPS Monitor & Analyze UDF Project (MAUDF)Microsoft Office PerformancePoint Server 2007 M&A stores all objects in it's metadata database (named PPSMonitoring in default configuration). Many of these objects are stored in SerializedXML column of the FCObjects table. So, it is very inconvenient to retrieve and search objects with criteria based od particular attributes (XPath / XQuery expressions would be necessary to perform the search). But fortunately Nick Barclay has created great solution, which makes these operations much easier and straightforward.
This solution is called The PPS Monitor & Analyze UDF Project (MAUDF) and it is the project which delivers a set of useful views and UDF functions, which allow to access and retrieve metadata from PPSMonitoring database with using simple T-SQL queries.
Great idea and very useful tool, specially for creating advanced and customized reports using other technology (like scorecards in Reporting Services based od metadata read directly from PPSMonitoring database).
Here is a sample query how we can use it.
This simple query returns metadata for all objects with a display folder of "Sale Results".
Very short and easy, don't you think ?
More details about this project you can find on Nick Barclay's Blog.
The MAUDF setup instructions, source code, binaries, samples and documentation can be downloaded from MAUDF Codeplex project.
July 04 How to replace NULL values in Dashboard Designer (MS Office PerformancePoint Server) ?
One of users had a problem with replacing empty values on his dashboard, which were created in Dashboard Designer. As it later turned out, replacing empty values in Dashboard Designer is available only in Scorecard component. Unfortunately other components like Analytic Grid does not support this functionality. In this article I would like to present how to solve problem with NULL values by preparing respectively MDX queries or with using calculated measures in your queries.
But firstly let’s start with an easier case – the Scorecard component. Replacing empty values in Scorecard component PerformancePoint Server M&A allows to replace all empty values with text which is provided by user.
Here is an example. In Figure 1 is shown the Sale Scorecard with empty values in two columns (Bikes and Components). Let assume that we want to replace all empty cells with „Empty” caption.
To achieve this you need to configure the following options in Dashboard Designer.
While editing your scorecard object go to the Edit tab on the Ribbon. Then select View Options depicted in Figure 1 (this button is enabled only if you place your cursor in any of scorecard’s cells).
Figure 1. The scorecard with empty values – View Options menu.
When you chose this option the View Options dialog box will appear (see Figure 2).
This dialog box enables you to specify how you want a scorecard to appear in a deployed dashboard.
The Messages section enables you to specify how empty cells and errors are displayed in the scorecard. The View section enables you to specify display options, such as whether a scorecard allows for comments, is hidden from view in the dashboard, includes row expansion options, or shows gridlines, details, and headers.
If you want to replace your empty values you need to check option Indicate empty cells and put your caption in textbox below (see Figure 2).
Figure 2. View options in Dashboard Designer.
When you change these settings all empty values on your scorecard will be replaced with provided caption. The final result you can see on Figure 3. Figure 3. Scorecard with replaced empty values.
So, in the scorecard component there is dedicated option for replacing empty values. But this option is unavailable for Analytic Grid. How to achieve this functionality ? Here is a little workaround.
Replacing empty values in Analytic Grid component
Unfortunately Dasboard Designer does not provide any option to replace empty cells in your Analytic Grid. So we need to use other clever way to solve problem with replacing empty values. Below will be presented two equivalent ways: - preparing calculated measures in your Analysis Services (SSAS) cube. - preparing MDX query and use it in your Analytic Grid.
Preparing calculated measures in your Analysis Services (SSAS) cube.
In our example let assume that we want to replace all empty values of [Measures].[Order Count] measure. The sample MDX query is presented below.
Result of executing this query is shown below in Figure 4.
As you can see, we have two columns (Bikes and Componets) with empty cells. So, the goal is to replace these cells with other nonempty values. Let assume that we want to replace them with zero value. We can achieve this by provide a new calculated measure directly in the cube. Here is an example of MDX code, which you need to use in your MDX script in BIDS project:
After deploying and processing the cube, we need to modify our MDX query by provide new measure in SELECT statement.
In Figure 5 is depicted the final result, where all empty cells are replaced with 0 value. Figure 5. Analytic Grid with replaced empty values.
Preparing MDX query and use it in your Analytic Grid
The same result we can achieve by preparing MDX query and without need to do any modifications in the source OLAP cube. Here is the sample MDX query with calculated measure [Order Count 2].
After using this query in the Analytic Grid component, the result will be similar to that presented previously in Figure 5.
More details about handling null values in MDX queries you can find in this very good article written by Mosha Pasumansky: http://www.sqljunkies.com/WebLog/mosha/archive/2005/06/30/mdx_is_empty.aspxReplacing empty values with text value in MDX queries
In the previous example we were replacing empty values with numeric value. But in many cases we want to replace empty cell with some text value, like „EMPTY VALUE”. How to achieve this? That is quite simple. We need to modify our MDX query by adding one technical measure which will provide string value, which will be used in replace operation. Here is sample code of this MDX query.
As you can see in the query is present one measure [Measures].[Empty value] with any value (in this case it is 1). We use only the name of this measure, which will be presented in our Analytic Grid. Another measure [Measures].[Order Count 3] is similar to measures presented in previous part of this article (IIF statement which replaces empty value with [Measures].[Empty value].Name) After using this query we will get the following report presented in Figure 6.
As you can see, all empty values are replaced with „Empty value” string. June 08 Heroes {Community} Launch in Wrocław - materialsI have added some materials (slides in PDF file format) from my presentations I gave last week at Heroes Community Launch conference in Wrocław. You can download them by clicking on the following links:
June 05 Microsoft Office PerformancePoint Server 2007 Service Pack 1 now availableI would like to to annouce that SP1 for PerformancePoint Server 2007 is now available. You can download SP1 from the following locations:
PerformancePoint Server 2007 Service Pack 1 (x86): http://www.microsoft.com/downloads/details.aspx?FamilyId=28B1F86B-B7F2-4215-8BC9-8F8507FF8831&displaylang=en PerformancePoint Server 2007 Service Pack 1 (x64): http://www.microsoft.com/downloads/details.aspx?FamilyId=6245C354-9191-4C4D-8C0C-C10D6C778AF8&displaylang=en PerformancePoint Server 2007 Evaluation Version (x86): http://www.microsoft.com/downloads/details.aspx?FamilyId=6372C24F-67DD-42DD-B034-748907B23420&displaylang=en PerformancePoint Server 2007 Evaluation Version (x64): http://www.microsoft.com/downloads/details.aspx?FamilyId=3ADAC793-DEF0-4BA8-A9AB-228979B8DB40&displaylang=en
New features and fixes available with SP 1 are listed here: May 19 Heroes {Community} Launch in Wrocław
April 30 Bonair is Poland's first Microsoft Performance Management PartnerIt is worth to announce that Bonair has achieved Performance Management competency within the Microsoft Certified Partner program. We are the first company in Poland with competency in this area. Bonair leverage skills, experience and knowledge to deliver for our customers BI and CPM solutions which allow achieving their all key business needs. Our systems are based on Microsoft technologies such as Microsoft SQL Server and PerformancePoint Server 2007. April 21 New LinkedIn Group for PerformancePoint Server Professionals
A few days ago I decided to start a new group on LinkedIn portal. February 26 Gartner's Magic Quadrant for Business Intelligence Platforms, 2008
|
|
|
