Solver
Your Performance Management Partner
Print Email
PerformancePoint Server
Business Intelligence Studio
XL Spreader
Drill Anywhere
ProfitBase
Enterprise Reporting
XL Reporter
Business Intelligence Studio

Business Intelligence Studio

What is Business Intelligence Studio?

Business Intelligence Studio (BIS) enables full utilization of all Microsoft Office PerformancePoint Server 2007 (PPS) features. It is a solution that accelerates the implementation of PPS, enhances end-user productivity and provides valuable budgeting/planning functionality to facilitate better Business Performance Management.


Why use Business Intelligence Studio

BIS enhances your investment in PerformancePoint Server, to better serve your user community with user-friendly financial applications.

A few examples of how BIS can help your organization:

BIS enables you to combine data from several cubes (for example, employee salary per year in the user model with the salary increase percentage from the assumption model). This ensures an easy to use end-user environment, rather than having to juggle with multiple workbooks.

Let end-users add members on the fly (for example, If a department manager needs to add a new employee, this can be done easily and securely directly in the excel budget model versus having to go to the PPS console (Biz Modeler).

For Line Item detail (such as detailed travel expenses below the GL account level) you do not have to first add each line item as a dimension member in the data warehouse. Instead BIS will handle this automatically directly in Microsoft Excel, enabling dynamic input forms.

Business Intelligence Studio Features and Benefits for your business:

Form Designer/Report Writer: Easy and powerful Excel-based form designer to create forms and reports. New forms can be inherited or cloned from existing forms for easy reuse. The advanced MDX wizard will create complex MDX queries for your form without having to know MDX. Rules can be run directly within the form.

Parameterized Rules: BIS can dramatically improve speed and scalability in the budget model because it can parameterize PPS business rules with the benefit of only having to recalculate the relevant section of the cube.

Line Item Detail: Update/create/ remove records from the transaction table, reference multiple measures within one model, read multiple models within a line item.

Form Controls: Drop down boxes, check boxes, short and long text boxes, and linked drop downs enable data entry with checks and controls, to ensure better data quality, smoother budgeting and forecasting processes which provide better business performance management in your organization.

Dimension Slicer: Can control one or more dynamic matrix controls, a slicer can have multiple dimension members and member set groups that can reference to each other to allow for filtering.

Multi-Model Forms: Custom template-based controls can be assigned multiple times to one form and can be controlled from the slicer. It can submit to multiple models and scenarios without having to change from one Excel form to the other. In other words, multiple cubes can be linked to the same slicers.

Simplified Dimension Maintenance: End-users can create, add, and delete dimension members and related hierarchy maintenance as well as their attributes directly within the Excel add-in without having an administrator first add the member in the PPS Biz Modeler interface.

PRODUCT FAST FACTS
PerformancePoint Server

Help organizations improve performance by integrating monitoring, analysis, and planning into a single application.
 
SIGN UP TODAY
Instructor – led Classes
Microsoft Office PerformancePoint Server 2007, Planning – Advanced 4 day Class! Read More +
 
RESOURCES

Business Intelligence Studio
For Microsoft Office PerformancePoint Server 2007 (134KB)
PerformancePoint Server - Overview
 (5.3MB)
PerformancePoint Server - Management Reporting
(5.2MB)
PerformancePoint Server - Planning
(5.4MB)
PerformancePoint Server - Case Study: OTICON
(128KB)
 
 
Copyright © 2008 Solver Inc. All Rights Reserved | Contact Solver