- PerformancePoint Services and SharePoint Web Parts Play Well Together
-
One thing that I think is so powerful about PerformancePoint Services for SharePoint 2010 you might not find on the feature card. You might catch a reference to it in a demo or read it in a an article and not even notice it. The feature in question is web part connectivity.
When you see a nice PerformancePoint Dashboard, the thing you might not be aware of is that it’s not a PerformancePoint Dashboard. It’s a SharePoint Dashboard consisting of only PerformancePoint Web Parts. The obvious conclusion to draw from that statement is that you don’t have to use PerformancePoint Web Parts. More importantly is that you don’t have to use only PerformancePoint Web Parts.
Playing Well Together
One of the important focus points when we started moving PerformancePoint Server into a service of SharePoint was to be sure to leverage the infrastructure that was now available to us. One of these infrastructure pieces was the Web Part Connections that allow SharePoint developers to connect and pass data between parts on the same page.
Overview of Web Part Connections
Web Part Connections are a core technology to enhance your SharePoint pages. When you connect Web Parts, actions that you perform in Web Part A can change the contents of Web Part B. Look at the Diagram below:
- A Web Part connection is a way to pass data from one Web Part to another Web Part and synchronize their behavior.
- One Web Part provides the data.
- Data can be lists, rows, cells, or parameter values.
- The other Web Part gets the data.
It’s Not Just for Dashboard Designer
Previously you would have built your Dashboards in Dashboard Designer. On the Dashboard edit page, you would create all of your connections and publish your Dashboard.
Although that workflow still exists, now you can simply add a PerformancePoint Web Part to a SharePoint page in SharePoint Designer or even connect them by using the thin editing experience right in Internet Explorer (or your favorite browser!)
So What Does It All Mean?
What it means is you can create mash ups until you can’t see straight. If you were at the SharePoint Conference or SQL Pass Conference you saw our own Program Manager Scott Heimendinger create a web part that displayed SharePoint List Data, and allowed List Data Editing. The interesting part though, was that the SharePoint List Data to be edited was selected using Microsoft Analysis Services Cube Measures that were displayed as a Hierarchy on a PerformancePoint Scorecard. Now that’s putting your data to work for you.
The possibilities are endless. Connect to Reporting Services or Excel Services and pass parameters. Create custom web parts that act as filters. The big picture is you can start building full fledged Business Intelligence applications in SharePoint using PerformancePoint Web Parts in a truly dynamic way.
Jason Burns, Program Manager
PerformancePoint Services for SharePoint
- New Features in PerformancePoint Services 2010
-
Now that SharePoint 2010 is on the horizon, there have been a lot of questions about what the differences are between PerformancePoint Server 2007 and PerformancePoint Services 2010. While most of the feature upgrades surround architectural changes, several changes have been made to enhance the user experience. Below are some of the upgrades that you will see in 2010.
Enterprise Deployment Scenarios
The following list highlights the greater attention to enterprise scalability of PerformancePoint Services 2010 over PerformancePoint Server 2007.
- Scale Up
- Scale Out
- Common Dashboard Framework and Infrastructure
- MOSS Installer Framework
- Enterprise Management Scenarios
- Familiar Administration Environment
- Fail Over
- Logging
- Ease of Deployment
- PowerShell Management Scripting
SharePoint Repository
Objects created in PerformancePoint 2010 are now stored in SharePoint lists and libraries, not in a separate database. Because of this new location, these other features come along too.
- Single Security Model
- Single Security Administration Environment
- Enterprise Management Scenarios
- Backup and Restore
- Disaster Recovery
- The PPS administrator’s user experience is the SharePoint user experience
- PerformancePoint is a SharePoint site
Filters compatible with SharePoint filters (WSS Connection Framework)
You can now use SharePoint’s standard connection framework to hook up PerformancePoint filters to standard SharePoint web parts.
Foundation for more seamless integration
The SharePoint architecture provides the foundation to make these things possible.
- Search, Indexing, Workflows
- Excel Services, Visio Server, Project Server
- Custom security implementations
Supported environments
New supported environments make it possible for PerformancePoint to run on the latest hardware, making the most out of the latest and greatest in speed and reliability.
- PerformancePoint Services for SharePoint
- Windows Server 2008 64-bit
- SharePoint Server O14 Enterprise CAL
PerformancePoint 2010 Clients
These are the client browsers and operating systems that are now supported.
- Windows XP or greater
- Internet Explorer 7.0 or greater
- FireFox 3.5
- Safari 3.5 (Mac only)
Scorecards
Scorecards have undergone significant changes. The following list should contribute to some fantastic performance indications.
- Dynamic hierarchies with navigation
- Drill Down and Drill Up
- Dynamic Selections, such as Children and Descendants
- KPIs on Columns
- Multiple Actual Values
- New Time Intelligence Formula Support
- Variance
- Calculated Metrics
- Scorecard hierarchies available for filters
- Cube formatting applied to KPIs
- Time intelligence formula editing
- Improved filtering
- Sort and filter on non-numeric values
- Improved value filtering
- Improved status filters
- Filter empty rows or columns
New report (KPI details)
Find out the fine details for each KPI.
- Displays information about KPIs
- Applied filters
- KPI name, description, properties
- Metrics with trend
- Actual and target values
- Created and modified date
- Indicator and thresholds
- Calculation
- Variance
- Scoring method and distribution graph
- Comments
- Person Responsible
Pie charts
A pie chart, a highly-requested chart type, has been added for PerformancePoint 2010.
Analytic reports
- Value filtering in grids and charts
- Change measure on published reports
- Navigation on bottom axis
- Improved numeric formatting
- Per-measure or per-column
- Analysis Services conditional formatting
Analytic view designer
Notice the UDM organized cube layout inside the Details pane.
Filters
Filters have come a long way in this version. Here are some of the enhancements
- Reusable between dashboards
- Compatible with SharePoint filters (WSS Connection Framework)
- Time Intelligence filters for multiple data sources
Dashboard deploy
PerformancePoint now has on-click deployment to SharePoint
Accessibility and Globalization
- Accessibility meets SharePoint standard
- Scorecard Analysis Services KPIs honor client locale
- Dashboard accessibility now meets SharePoint's standard (WCAG 2.0 AA)
New Visualization
Much like the decomposition tree from ProClarity, the one in PerformancePoint 2010 also helps customers follow a line of data to its logical conclusion.
And that about wraps up most of the new features in PerformancePoint Services 2010. If others come to mind, I’ll be sure to add them!
Kevin Donovan, Program Manager
PerformancePoint Services
- New Business Intelligence Services in SharePoint Server 2010
-
The poster, Getting started with business intelligence in SharePoint Server 2010, is a review of all the business intelligence (BI) services in SharePoint Server 2010 (Beta) and can be downloaded in Visio, PDF, and XPS file formats. You will notice that PerformancePoint Server 2007 is integrated into SharePoint Server 2010 (Beta), to add business intelligence features such as dashboards, scorecards, KPIs, and more. The poster includes the following information.
- An overview of each business intelligence service and when you might use each service to surface reports, scorecards, KPIs, Excel files, and other features of BI.
- Architecture to show how the business intelligence services work together.
- A list of possible data sources for each business intelligence service.
Note that the term "Insights" in the poster refers to business intelligence.
From the poster:
The BI tools you use depend on the specific problems you are trying to solve. Your daily business activities have associated information and insights that emerge in three main areas of business intelligence: personal (and self-service), team or community, and organizational.
There will be overlap across these areas as seen in the diagram below. For example, in SharePoint Server 2010, a company’s employees may use Excel Services and Visio Services to make relevant business decisions at the corporate level.
By design, all Microsoft BI products inter-operate so that teams and individuals within an organization can move across the continuum of personal, team, and organizational BI and have all products work together. For example, SQL Server Reporting Services reports, Excel Services reports, or Visio diagrams can be published in a PerformancePoint Dashboard.
The following is a sample of the poster. It is small and can be better viewed in the download (Visio, PDF, and XPS).
- Creating Complex KPIs with Calculated Metrics
-
Many times, the metrics that make up your key performance indicators are not simple values from a data source. In PerformancePoint Server 2007 you could create two kinds of KPI metrics: Simple single value metrics from any supported data source or Complex multiple value metrics from a single Analysis Services data source using MDX.
When a user needed a calculation as simple as ‘Sales per Square Foot,’ both the sales value and the square footage values had to be available in an Analysis Services cube, and the calculation had to be written in complex MDX statements.
Luckily this is no longer the case in PerformancePoint Services for SharePoint 2010. This release we have introduced a new feature called “Calculated Metrics.” Calculated Metrics are powerful for several reasons:
- Can use multiple data sources in the same formula.
- Can use different data source types in the same formula.
- Is expressed in simple Excel-like formulas.
- Supports logic flow.
The possibilities are endless.
I quick view at the Calculated Metric dialog shows how simple the process really is. The grid at the top maps data sources to common names you can use in your formula. The Formula box contains the formula you have written and even uses simple code highlighting techniques to help you quickly understand what’s being calculated.
The formulas support all simple math operations as well as functions like MIN, MAX, SUM, AVG and ABS. You can create IF statements in your formulas to create logical operations and you can even use NULL to test for data or intentionally return a null result.
This topic gets much deeper and we will post examples of complex usage in the coming weeks. Until then, when you get your hands on the beta in November, use this feature and provide feedback. Enjoy!
Jason Burns, Program Manager
PerformancePoint Services
- Introduction to Time Intelligence
-
Welcome to the world of Time Intelligence for Microsoft Performance Point Services! Dynamically analyzing your data with respect to time has never been easier. From dissecting historic performance, to calculating Year over Year metrics, to analyzing Year to Date performance, Time intelligence puts time dependent data analysis at your fingertips.
Flexible Formulas
Specify almost any time period desired with a rich syntax and flexible formula language. Powerful “To Date” functions enable users to observe performance thus far. With these, creating seasonal adjusted metrics such as year over year (YoY) year to date sales have never been easier.
Compelling Analysis
Use time intelligence to study historic performance and detect persistent problem areas. Analyze historic snapshots to understand the effects of events and decisions.
Potent Filters
Link together your dashboard with potent Time Intelligence filters to dynamically change, explore, and analyze your data with respect to time. Drive change through trends discovered in time adjusted scorecards and analytic charts.
Stay Tuned over the next few weeks as we dive deeper into Flexible Formulas, Compelling Analysis and Potent Filters in detailed blogs on each topic.
- What is PerformancePoint Services for SharePoint 2010?
-
The PerformancePoint Blog’s design refresh is not a coincidence. A lot has been going on with PerformancePoint as we gear up to release Office 2010, specifically SharePoint 2010. Before we go into what is exciting about PerformancePoint Services for SharePoint 2010, let’s level set by taking a quick tour of what PerformancePoint is and why it’s important to you.
In Definition
The definition would be that it enables you to create rich, context-driven dashboards that aggregate data and content to provide a complete view of how your business is performing at all levels.
The quick elevator pitch would be that PerformancePoint Services is the easiest way to create and publish Business Intelligence Dashboards in SharePoint 2010.
The concept of a dashboard takes root where you might assume. It’s the pilot’s cockpit display, the driver’s car dashboard…basically how you gauge and monitor the success of any activity from driving a Formula 1 race car to running a Fortune 500 company.
In any business enterprise, monitoring that success means access to data. SharePoint 2010 is able to use many technologies to view data, but PerformancePoint lives and breathes data. We replace the fuel gauge and speedometer with KPIs, Scorecards and Data Visualizations that are connected to the data in a that allows you to dive in and answer questions.
In Practice
Now that you have heard the marketing lingo, what is PerformancePoint Services made of, and how can you get value out of it? PerformancePoint Services is part of SharePoint 2010 and surfaces itself in a web part page like a SharePoint savvy user might expect. The unique part is two fold.
PerformancePoint Services starts with it’s authoring experience. The Dashboard Designer application is your toolbox to create from the bottom up: Key Performance Indicators (KPIs), Scorecards, Analytic Charts and Grids, Reports, Filters and Dashboards. Each of these components are unique to PerformancePoint Services and provide functionality that interacts with a server component that handles the hard parts like data connectivity and security.
The Dashboard Designer is a WYSIWYG experience, the pieces you build will appear in the browser exactly how you created them. That brings us to the second part, the end-user experience. PerformancePoint Services is designed with sharing in mind. The pieces you build are bundled into a dashboard and presented in a SharePoint page that understands who is viewing it and what they are allowed to see. That means you design, you publish and they consume…no IT involvement, no complicated workflows.
- Business Intelligence is HOT at SharePoint Conference 2009
-
If this morning’s Dashboards as Easy as 1,2,3 is any indication, Business Intelligence and specifically PerformancePoint Services is high on the radar at the SharePoint Conference. After a quick poll, the audience indicated that very few of the over 1,000 in attendance were using PerformancePoint Server 2007. That means we had a huge crowd of new users interested in getting to know PerformancePoint Services.
After I went through a quick usage and build scenario, Wade Dorrell walked through a deeper dive of the end-user features of PerformancePoint Services. It was a great session but do not be fooled, Scott Heimendinger and Steve Handy have a ton more to show you at tomorrow’s Advanced Dashboard Design session. If you liked what you saw today, that’s a can’t miss.
If you were interested in providing these features to your end users, make sure to catch Josh Zimmerman’s Configuring PerformancePoint Services: An Administrator’s Guide to Delivering SharePoint Dashboards session.
Lastly, we had a lot of people asking about upgrading, check your session guide, we have a session dedicated to upgrading PerformancePoint Server 2007 content to PerformancePoint Services for SharePoint 2010.
Thank you for the fantastic attendance, the product team and I will be here the rest of the week and hope to see you at the product booth! Don’t forget, the top three scores in BI Racer win Windows 7 copies each day.
Jason Burns
Program Manager, PerformancePoint Services
- Welcome To SharePoint Conference 2009!
-
That's a wrap, the keynote is in the books. Hopefully you were in attendance and enjoyed Steve Ballmer and Jeff Teper's remarks as well as the special guests and demos. If you weren't able to attend in person, it should be available on the conference site very soon to stream.
There were quite a few things to take away from today's keynote, some highlights are:
- PowerPivot, the official name of project Gemini is out of the bag. Today's keynote showed instant sorting and filtering of more than 100 million rows! Look for more to come throughout the week.
- Visual Studio plays very well with SharePoint 2010. The developers will appreciate the end-to-end creation and deployment of SharePoint solutions.
- SharePoint 2010 has the ribbon and it allows context-sensitive editing right on the page.
- PerformancePoint Server 2007 is now PerformancePoint Services for SharePoint 2010 and it's in the box!
- SharePoint 2010 is more social than ever. Collaborative working in SharePoint gives you new power to communicate with the people you count on every day.
Of course that's just a small list of the things covered in the keynote, and there are hundreds of sessions planned this week to dive into each of these topics further. If you want to keep up with us and where we are, follow @sharepointbi on Twitter and of course stay tuned to this feed.
Lastly, there are many of the PerformancePoint Services product team on the ground here, come by the Microsoft Business Intelligence product kiosk, attend the sessions, check out the hands on labs, visit Ask The Experts and if you see us, don't be shy to stop us and say hi. It's only Monday and this has been a fantastic experience meeting with customers and partners. Thank you and I hope to see you on the floor.
Jason Burns, Program Manager
PerformancePoint Services for SharePoint
@philoking on Twitter
- PerformancePoint Services at the October SharePoint Conference in Vegas!
-
Hopefully you have already registered for the SharePoint Conference in Las Vegas this month. In addition to a keynote by Steve Ballmer himself and tons of great SharePoint sessions, PerformancePoint Services will be there to show off what we have to add to the SharePoint Business Intelligence story.
What to Look For
We have several sessions scheduled from introducing dashboards and PerformancePoint services, to building advanced dashboards, security and infrastructure. There is something for everyone.
Sessions:
- Creating Dashboards as easy as One, Two, Three – An Introduction to PerformancePoint Services
- Advanced Dashboard Creation with PerformancePoint Services 2010
- Configuring PerformancePoint Services: An Administrator’s Guide to Delivering SharePoint Dashboards
- Upgrading PerformancePoint 2007 to SharePoint 2010
We will have members from the product team in full force to show you what’s new in PerformancePoint Services for SharePoint 2010and how to put it to use.
The Full Story
It’s important to remember that PerformancePoint Services is only one piece of the Business Intelligence story at Microsoft. Be sure to check out additional sessions from Excel Services, Reporting Services and SQL Server.
For those twitter nuts out there, we will all be updating regularly at http://twitter.com/sharepointbi
See you at the booth!
Jason Burns, Program Manager
PerformancePoint Services
- Microsoft Office PerformancePoint Server 2007 Service Pack 3 is released!
-
Microsoft Office PerformancePoint Server 2007 Service Pack 3 hits RTM on schedule and is available for download from the Microsoft Download Center.
· Download sites: PerformancePoint Server 2007 SP3 (x86), PerformancePoint Server 2007 SP3 (x64)
· Documentation: Service Pack 3 for Microsoft Office PerformancePoint Server 2007, IW documentation is being published.
What’s New in SP3
Focused on the supportability of PerformancePoint Server 2007, Service Pack 3 offers not only a wide range of bug fixes but also a few new features and feature enhancements. For Planning customers, this release offers the following new features:
× Submitting line-item details with assignments. This new feature enables users to add, edit, view, and submit line item details. They can also view the submitted line-item details in reports.
× Adjusting security with the PPSCmd utility. This feature enables users to lower security changes within PPSCMD. For example, it is now possible to move security from Read/Write to Read Only within the PPSCMD utility.
× Extending the application calendar beyond 25 years. This feature enables users to manually change the maximum limit of future years to a value greater than 25 and less than or equal to 200.
For Monitoring & Analytics customers, SP3 offers improved usability, with better handling of zone adjustments, scrolling, and filtering and improved messaging. SP3 also provides better integration with Excel Services, SharePoint Server, and ProClarity.
PerformancePoint Server 2007 SP3 is being released in 18 languages (including English). The localized versions of PPS SP3 will be released by tier beginning in December, 2009. All versions are being released to the following channels:
· Microsoft Download Center. Localized versions of SP3 will be available beginning in December 09.
· Volume licensing (VL). The English version will be available in early December; localized products will be available in early January.
· MSDN. All languages are expected to be available by mid-December.
· ProductsWeb. All languages are expected to available within 4 weeks of the respective release dates.
ProClarity 6.3 SP3 was released on October 9 and is available on the Microsoft Download Center.
· Download sites: ProClarity Analytics Server 6.3 SP3 (ENU), ProClarity Desktop Professional 6.3 SP3 (ENU)
· ProClarity 6.3 SP3 documentation: ProClarity SP3 Readme and ProClarity SP3 Hardware and Software Requirements
Many thanks to everyone who helped with these releases!
- Publishing PerformancePoint Server in an Extranet - White Paper Now Available
-
Now available is a white paper outlining the technologies and steps required to publish PerformancePoint Monitoring Server dashboards in an Extranet. You can download this white paper from:
http://go.microsoft.com/fwlink/?LinkId=151630
- PPS Planning - How to display and launch assignments from SharePoint
-
SharePoint has rapidly become the preferred platform for team collaboration in the enterprise. It provides a central place for information, tasks, documents and much more of the business related content that users need to access every day.
One of the common requests we hear from customers is that they want to display PerformancePoint Planning assignments in SharePoint and allow users to launch the assignments from there. Assignments can be accessed via the Excel Add-in and email notification can be enabled for users to get notified, but there is no out of the box support for the SharePoint scenario.
We have released a code sample that demonstrates how you can display PerformancePoint assignments in SharePoint via SharePoint lists.
The sample uses the SharePoint list infrastructure to display PerformancePoint assignments in SharePoint and enable users to launch them in the Excel Add-in from there. The sample includes the source code and documentation on how to use and deploy the solution.
You can access the sample from here: http://code.msdn.microsoft.com/PPSP2007Assignments
The sample includes 2 projects:
- A standalone console application that connects to the PerformancePoint application database (AppDB) and reads the assignments out from open cycles. Then it connects to SharePoint and creates/updates/deletes list items from a SharePoint list, securing the list items with the same security enforced by PerformancePoint Add-in for Excel.
- A web project containing an ASP.NET page that is used to launch PerformancePoint Add-in for Excel for a specific assignment. This page is used by the SharePoint list items.
This is a different approach from other solutions that I've seen to achieve this. While most solutions focus on creating a web part to show the assignments, this sample uses a regular SharePoint list for that. The good thing about this is that all the list features (like sorting, grouping, filtering, creating views on top of the list, and so on) are available for both administrators and end users to customize the way assignments are displayed. Also, the interface that users see for working with the assignments is no different than other SharePoint lists. Trying to develop this functionality in a custom web part would be a huge task.
As with any sample, there are things that can be customized and extended. Some of the ones I can think of are:
- Expose more fields: Right now, the console application only copies some of the assignment fields to SharePoint. If more fields are needed, they can easily be added.
- Convert the launch link into a list Custom Action: Right now, the link to launch the assignment is created using a link column, but with some work it can be easily converted into a SharePoint list custom action. This will make the launch link more SharePoint-like. There are many samples online on how to create custom actions.
- Add a look and feel: The ASP.NET page used to launch the assignments can be customized to match the company's look and feel (or any other desired look and feel).
- Add/Modify views: Add your own customized list views and customize the default view. Add grouping, sorting, filtering and use as many list features as you need.
Give it a shot.... I'm sure you will like it!
Pablo Barvo - MSFT
- Creating PPS KPIs based on SSAS KPIs
-
There are two ways to create KPIs in PerformancePoint Server based on SSAS KPIs. The first is to use the Scorecard wizard to import those KPIs into PPS. This will create a new scorecard containing only those imported KPIs. I wrote a post on this some time ago.
If you want to add SSAS KPIs to your existing scorecards however, you can also create individual PPS KPIs based off of SSAS KPIs through the dashboard designer as well. It does require using some MDX expressions to create those KPIs. First, you will want to create a new blank KPI. Select the SSAS cube containing your KPI as your data source.
In the Data Mapping column rather than selecting a measure, you will enter an MDX expression as follows for the Actual value:
Expression:
KPIValue("Gross Margin KPI")
Screenshot:
For the Target Data Mapping, enter the following:
Expression:
KPIGoal("Gross Margin KPI")
Screenshot:
Add a new Target for Trend and map as follows:
Expression:
KPITrend("Gross Margin KPI")
NOTE: When importing your KPIs through the scorecard wizard you automatically get the correct threshold settings imported and the correct images imported for your Target and Trend. When you create these manually, you will have to select the indicator and enter your thresholds for both the Target and Trend columns.
To set the threshold on the Target column, select "Increasing is Better" for the scoring pattern. Select "Band by stated score (advanced)" for the banding method.
Select the indicator you want to show. Then, when specifying the data mapping for the threshold enter the following expression and select to "Use MDX tuple formula":
Expression:
KPIStatus("Gross Margin KPI")
Next, don't forget to set your threshold bands, for a typical 3 state indicator it would look as follows:
Recall, that the status in an SSAS KPI will always be between 1 and -1.
To set the threshold on the new Trend Target column, select "Increasing is Better" for the scoring pattern. Select "Band by stated score (advanced)" for the banding method.
Select the indicator you want to show. Then, when specifying the data mapping for the threshold enter the following expression and select to "Use MDX tuple formula":
Expression:
KPITrend("Gross Margin KPI")
Next, don't forget to set your threshold bands, for a typical 5 state arrow indicator would be as follows:
Also, don't forget to set the calculation column on your new Trend target to be "Default".
Alyson Powell Erwin
alysonp@microsoft.com
- PPS Planning - How to run a Currency Translation Job
-
PPS Planning allows the user to create a Currency Translation Job in order to facilitate a model's data to be converted to any currency.
In order to accomplish this there are certain criteria that a model must adhere to.
- The model must be a Financial type of model. Either a Financial Model with Shares or a Financial Model without Shares
- You need to add the Currency dimension to the model
- The Exchange Rate Model must be linked in as an assumption model
- The Time granularity of the Exchange Rate model must be the same as the granularity of the model that you want to convert
- The model property Default Currency can optionally be set to one of the currency members in your model. If it is, then this currency will be used to triangulate an exchange rate if a direct rate is not specified in your Exchange rate model for the period(s) that need to be translated.
- Enter your exchange rate data in the Exchange Rate Model for the exchange rate members AVE (this rate is used to convert the Income Statement) and CLO (Used to convert the Balance Sheet). You can also fill in the other rate type members if you want to customize your currency rules or if you are using the Flow dimension in your model.
This report shows the data in the Exchange Rate model that will be used to convert the fact data in our model for
- Scenario = Actual
- Time = Q2 2004
- Destination Currency = USD
- Source Currencies = {EUR, GBP, CAD}
- Exchange Rate Types = {AVE, CLO, OPE, HIST}
Now I can run a currency conversion job to convert my data.
Using the above job properties will have the net result of converting all of fact data for my Budget model using the following job properties
- Target Model = Budget
- Entity = Resorts (The job will convert all of the fact data for entity Resorts and all of its descendants)
- Scenario = Budget
- Reporting Currency = USD (Convert all applicable entities data to USD. If the default currency of the desired entities is already USD then it will do nothing for those entities)
- Start Period = Q 2 2004
- End Period = (Since this is blank, then it will only convert the data for the one period Q 2 2004)
- Exchange Rate Start Period = Q 2 2004 (If this had been left blank it would use the Start Period which in our case is also Q 2 2004. We could have used the Exchange rates from another period)
- Exchange Rate End Period = (Since this is blank it will be the same as the Exchange Rate Start Period - Q 2 2004)
- Exchange Rate Scenario = Actual (If this had been left blank, it would use the same scenario for the Exchange Rates as the parameter Scenario. In this case it would have used Budget, but for this example we wanted to convert the Budget data using the Actual Exchange rates)
- Dashboard Basics Courses Now Available
-
There are two dashboard basics courses now available online at Office Online for your users:
PerformancePoint Monitoring and Analytics: Dashboard basics I
PerformancePoint Monitoring and Analytics: Dashboard basics II
Please enter any feedback you have on these courses as well as any additional topics you might like to see in the future, via the Feedback link
