1 / 8

Hyperion Planning - Cisco

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.

odina
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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Hyperion Planning - Cisco Anand Dubey, Manager IT 09/01/2014 Arindam Malakar, Engineer IT

  2. 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

  3. 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

  4. 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

  5. Driver Based Approach – A Closer Look Clear Baseline – Run Zero Based Driver Analyze Data Choose your Driver – Smart List

  6. 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

  7. 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

More Related