hyperion planning cisco
Download
Skip this Video
Download Presentation
Hyperion Planning - Cisco

Loading in 2 Seconds...

play fullscreen
1 / 8

Hyperion Planning - Cisco - PowerPoint PPT Presentation


  • 229 Views
  • Uploaded on

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.

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 ' Hyperion Planning - Cisco' - odina


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

slide2

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

slide3

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

slide6

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

slide7

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
ad