Hyperion planning cisco
This presentation is the property of its rightful owner.
Sponsored Links
1 / 8

Hyperion Planning - Cisco PowerPoint PPT Presentation


  • 166 Views
  • Uploaded on
  • Presentation posted in: General

Hyperion Planning - Cisco. Anand Dubey, Manager IT. 09/01/2014. Arindam Malakar, Engineer IT. Cisco Corporate Gross Margin Forecast – Pre Hyperion. Forecast. Manual Process to get data. Excel Rollup. Business Rules. WW Bookings. BU Finance. Cisco Forecast. Gross Margin. CORP.

Download Presentation

Hyperion Planning - Cisco

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


Hyperion planning cisco

Hyperion Planning - Cisco

Anand Dubey, Manager IT

09/01/2014

Arindam Malakar, Engineer IT


Hyperion planning cisco

Cisco Corporate Gross Margin Forecast – Pre Hyperion

Forecast

Manual Process to get data

Excel Rollup

Business Rules

WW Bookings

BU Finance

Cisco Forecast

Gross Margin

CORP

Consolidation of Forecast

Booking - BO

Supply Chain

Revenue- BO

Channels


Hyperion planning cisco

Cisco Corporate Gross Margin Forecast – Hyperion Enabled

Https:// OR

Excel AddIns

Channels

Supply Chain

BU Finance

CORP

  • Corp FP&A Team –

  • Actual & Forecast Reporting

  • Variance Analysis

Actual Data

> Cisco

> Acquisition

Hyperion Planning – Data Form / Smart View

EDW - SSOT

Financial Reports - Hyperion

Hyperion Planning – Financial Models

Acquisition Data

Product Bookings - Forecast

PnL Cube

One View

Sales Bookings - Forecast

Hierarchies

IFPSales

IFPProd

IFPSRVC


Overall forecasting process as is dummy data

Overall Forecasting Process – AS – IS (** Dummy Data)

Step 1: Analyze Actuals

A Driver Based Approach

Step 2: Seed Your Forecast

Step 3: Adjust Your Forecast


Clear baseline run zero based driver

Driver Based Approach – A Closer Look

Clear Baseline – Run Zero Based Driver

Analyze Data

Choose your Driver – Smart List


Hyperion planning cisco

Driver Based Approach – A Closer Look

Verify Baseline

Choose a new Driver

5 Quarter Rolling Forecast

Month calculation –

Feb = (Sum(Nov, Dec, Jan)/13) * 4

Mar = (Sum(Nov, Dec, Jan)/13) * 4

Apr = (Sum(Nov, Dec, Jan)/13) * 5


Hyperion planning cisco

Cisco Product Gross Margin – Architecture

ETL Mappings used for transformation of transactional data into IFP (i.e from detail to summary level)

DRM

Source Systems

Prod

Sales

PNLA

STAGING

Demantra

Product Forecast

Inbound Forecast

  • SSF Gross Margin

Gross Margin

IFPRPT

  • BTOF Gross Margin

STAGE

OMF

Sales Forecast

Main

Main

SSF

Acquisition

Finance Data

  • SL2 data allocated to PF

  • BE Judge – Top Down

  • @SL2 @PF view

Sales

Prod

Contra

PNLS

EDW

PFMarg

Contra

  • Sales /Deals Finance

  • @Sales Lev 2

Disti

Sales

  • WW Disti Finance

  • 2 Tier, POS Revenue

  • @Sales Lev 2

Inbound Actuals

Outbound Forecast

  • WW Partner Finance

  • @SL2, SL6, Rebate Programs, Product Family

  • BTOF, Supply Chain, RAO

  • @Product Family rolling up to BE and BU

  • Shipped Margin


  • Login