microsoft office performancepoint server 2007 l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Microsoft Office PerformancePoint Server 2007 PowerPoint Presentation
Download Presentation
Microsoft Office PerformancePoint Server 2007

Loading in 2 Seconds...

play fullscreen
1 / 16

Microsoft Office PerformancePoint Server 2007 - PowerPoint PPT Presentation


  • 275 Views
  • Uploaded on

Microsoft Office PerformancePoint Server 2007. Planning Module. Sony Jose sjose@solidq.com. Overview. Data Models and Rules to support the range of business models used in organizations. Utilizes Microsoft Office Excel as the end-user interface for planning, budgeting, and forecasting.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Microsoft Office PerformancePoint Server 2007' - JasminFlorian


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
microsoft office performancepoint server 2007

Microsoft Office PerformancePoint Server 2007

Planning Module

Sony Jose

sjose@solidq.com

overview
Overview
  • Data Models and Rules to support the range of business models used in organizations.
  • Utilizes Microsoft Office Excel as the end-user interface for planning, budgeting, and forecasting.
  • Built on top of Microsoft SQL Server 2005 tools suite including Relational Engine and SSAS.
data model
Data Model
  • Supports Business Models.
  • Facilitates Planning
    • Budgeting: Income, Expense, etc.
    • Forecast: Sales, Inventory, etc.
  • Supports Rules for
    • Cost Allocations
    • Inter-company Reconciliation
    • Consolidation
    • Currency Conversion
excel interface
Excel Interface
  • Provide everyone with a single, easy-to-use Excel interface.
  • Supports Excel functions and macros.
  • Almost no learning curve for the end Business Users.
architecture

SSAS

User Input

Planning

Business

Modeler

HR

Data Flow

Actual

SQL 2005

RDBMS

Oracle

Enterprise Systems

Plan

Assets

Architecture
  • Built on the strengths of SQL Server 2005 Relational Engine and SSAS.
  • Enterprise Level Scalable Architecture
components
Components
  • Architecture/System Main
  • Business Modeler
  • Rules and Calculations (PEL, MDX)
  • Forms/Reports
  • Data Integration
architecture system main
Architecture/System Main
  • Server Architecture
    • Planning Process Service
  • Install and Deployment Scenarios
  • CMD Line tools
  • Migration and Upgrade
  • Server level user access
    • Global Administrator
    • User Administrator
    • Modeler
business modeler
Business Modeler
  • Data Models
  • Dimension Structures
  • Cycles/Assignments
  • Associations
  • Security
  • Deployment of Models
rules and calculations pel mdx
Rules and Calculations (PEL, MDX)
  • PEL – PerformancePoint Expression Language
  • Business Calculations
  • Financial Calculations
  • Cross Model Allocation Rules
  • Currency Conversion Rules
  • Parameters, Variables, Ranges
forms reports
Forms/Reports
  • Excel Add-In
  • Assignment Input
  • Review and Approval
  • Executing/Running of Jobs
  • Formatting (Excel 2003 & 2007)
  • Programmability (Macros)
data integration
Data Integration
  • Data Load (Initial)
  • Data Load (Continuous)
  • Outbound
  • Referential Integrity (Dimensions and Fact)
  • Stored Procedures for Data Load
  • Can be automated with SSIS
benefits
Benefits
  • Imports data from multiple sources, including multiple general ledger systems.
  • One version of truth: Feeds data automatically into a centralized, trusted data store.
    • No more e-mails flying around with sensitive budget data in attached spreadsheets.
  • Standardized business rules and processes.
  • Security: Ensures that people only see appropriate and relevant information.
  • Track changes automatically
  • Manage planning and budgeting processes
enhances the relationship between the business and it
Enhances the Relationship Between the Business and IT
  • Business Users manage the application
    • Rules – e.g. allocations, business relationships, alerts
    • Workflows – e.g. planning and forecasting cycles
    • Content – e.g. accounts, business views, roll-ups
  • IT centrally manages security and information
  • Increased business flexibility, declarative model based applications, and reduced development time.
additional features
Additional Features
  • Handle Top Down as well as Bottom Up Forecasts.
  • Easily configurable Planning (Budget/Forecast) templates.
  • Ability to have centralized IT/Data administration.
  • Easy adaptation of future organizational changes.
  • Easy Integration with other systems.
  • Near-Real time interface to other systems.
  • Personalized User roles and Security capabilities.
  • Handle multiple currencies.
  • Can support and save text.
  • Support multiple iterations/versions of plan.
  • Have Offline capabilities.
  • Robust data validation.
  • Locking of plan data in a multi-user environment.
  • Automatic locking of plan data after submission.
  • Integration of sub-plans into an overall enterprise plan.
  • Standard set of Operational Reports
  • Real time reporting
  • Capability to handle costs and Head Count forecast