explore hana with the comerit authors of the sap press hana book n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Explore HANA with the Comerit Authors of the SAP Press HANA Book PowerPoint Presentation
Download Presentation
Explore HANA with the Comerit Authors of the SAP Press HANA Book

Loading in 2 Seconds...

play fullscreen
1 / 88

Explore HANA with the Comerit Authors of the SAP Press HANA Book - PowerPoint PPT Presentation


  • 145 Views
  • Uploaded on

Explore HANA with the Comerit Authors of the SAP Press HANA Book. Opening HANA Admin. Demo Overview. Adding New System in HANA. Demo Overview. Adding New System in HANA. Demo Overview. Creating HANA system connection. Demo Overview. Setup HANA Security Authentication.

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 'Explore HANA with the Comerit Authors of the SAP Press HANA Book' - lane


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
slide2

Opening HANA Admin

Demo Overview

slide13

The table definition

inside HANA

Demo Overview

slide14

All HANA tables

Demo Overview

slide15

Open a

HANA table

Demo Overview

slide16

Browsing data in

a HANA table

Demo Overview

slide17

Opening HANA Admin

Demo Overview

slide18

HANA memory usage

Demo Overview

slide20

Opening HANA Modeler

Demo Overview

slide21

The HANA Modeler

Demo Overview

slide45

Saving file formats

Demo Overview

slide47

Replicating

Productfile for

HANA data load

Demo Overview

slide48

Replicated

Product file for HANA dataload

Demo Overview

slide49

Replicating

Sales file for HANA data load

Demo Overview

slide53

Create a Batch job for HANA

data loads

Demo Overview

slide54

The new batch job for a HANA

data load

Demo Overview

slide64

HANA

data load log

Demo Overview

slide66

Opening HANA Studio

Demo Overview

slide67

Opening HANA Studio

Demo Overview

slide68

Opening our

Customer table in

HANA

Demo Overview

dashboard accelerator for your hana project
Dashboard Accelerator for your HANA project

Develop dashboards faster with RAD or Agile

Interactive development

Orientation meeting

- high-level scope agreement

Show dashboard in weekly UAT sessions

Make enhancements

Performance enhancements backend & front/end

Demo accelerator dashboards in scope

Request enhancements and new features

Unit test

System test

Integration test

Go-Live

dashboard accelerator for your hana project1
Dashboard Accelerator for your HANA project

Develop dashboards faster with RAD or Agile

Interactive development

Orientation meeting

- high-level scope agreement

Show dashboard in weekly UAT sessions

Make enhancements

Performance enhancements backend & front/end

Demo accelerator dashboards in scope

Request enhancements and new features

Unit test

System test

Integration test

Go-Live

dashboard accelerator for your hana project2
Dashboard Accelerator for your HANA project

Develop dashboards faster with RAD or Agile

Interactive development

Orientation meeting

- high-level scope agreement

Show dashboard in weekly UAT sessions

Make enhancements

Performance enhancements backend & front/end

Demo accelerator dashboards in scope

Request enhancements and new features

Unit test

System test

Integration test

Go-Live

dashboard accelerator for your hana project3
Dashboard Accelerator for your HANA project

Develop dashboards faster with RAD or Agile

Interactive development

Orientation meeting

- high-level scope agreement

Show dashboard in weekly UAT sessions

Make enhancements

Performance enhancements backend & front/end

Demo accelerator dashboards in scope

Request enhancements and new features

Unit test

System test

Integration test

Go-Live

dashboard accelerator for your hana project4
Dashboard Accelerator for your HANA project

Develop dashboards faster with RAD or Agile

Interactive development

Orientation meeting

- high-level scope agreement

Show dashboard in weekly UAT sessions

Make enhancements

Performance enhancements backend & front/end

Demo accelerator dashboards in scope

Request enhancements and new features

Unit test

System test

Integration test

Go-Live

dashboard accelerator for your hana project5
Dashboard Accelerator for your HANA project

Develop dashboards faster with RAD or Agile

Interactive development

Orientation meeting

- high-level scope agreement

Show dashboard in weekly UAT sessions

Make enhancements

Performance enhancements backend & front/end

Demo accelerator dashboards in scope

Request enhancements and new features

Unit test

System test

Integration test

Go-Live

a r available dashboards
A/R - Available dashboards

AR Overview

Aging, past due and outstanding Sales Orders by 15 & 30 days buckets with drill-down to business units, division and sales offices

AR Details

Aging by customers, past due and Sales Orders outstanding, weekly change tracking, overall outstanding and 30 day buckets. Also top-5 and top-10 customer analysis

AR Disputes (Billing)

Tracking by paid, cleared, disputed amounts, write-offs, resolution status, priority, amounts and number of Sales Orders. Organizational drill-down to business units, division and sales offices.

AR Disputes Details

Tracking by case Id, status, customer, customer type, dispute type code, amount, paid, credited, write-off, top-30 customer analysis and daily tracking of resolutions.

invoices available dashboards
Invoices - Available dashboards

Annual Sales Order Analysis

Sales current 12 months vs. last year, top-10 customers, top-10 materials, promotion sales current, prior and variance, drill-down to company code, sales organization, sales group and sales office, 3 detailed data table listing, 3 pie charts, 4 bar charts, reset, help, save scenario, print options.

Current Month, Week and Daily Sales Order Analysis

Sales current months, week, day and variance analysis for each period. top-10 customers, top-10 materials, promotion sales current, prior and variance, drill-down to company code, sales organization, sales group and sales office, 4 detailed data table listing, 3 pie charts, 5 bar charts, reset, help, save scenario and print options.

Organizational Sales Order Analysis

Sales Order tracking by Sales Area, top-10 materials, monthly invoicing and disputes current year, invoicing by region, annual details and variance reporting. 1 Map, 2 pie charts, 4 bar/column charts, 2 data tables, reset, help, save scenario, print options.

Top Customers Sales Order and Gross Margins

Gross margin analysis and Sales Order amount analysis for top-25 customers. (top-n), COGS, and Sales Order amounts with GM %. reset, help, save scenario, print options.

balance sheets available dashboards
Balance Sheets- Available dashboards

General Ledger Annual Balance sheet

Short-term and long-term Assets, Liabilities, and stockholders equity for current year and two years prior, Eight key ratios trending for three years.

General Ledger Quarterly Balance sheet

Short-term and long-term Assets, Liabilities, and stockholders equity for four rolling quarters, eight key ratios trending for last four quarters.

g l income statement available dashboards
G/L Income Statement - Available dashboards

General Ledger Annual Income Statement

Income statement with 3 years revenue, Cost of revenues, Gross profit, R&D expenses, Selling general and admin expenses, non-reoccurring expenses, other expenses, income (loss), EBITA, interested expenses, earnings before tax, tax, minority interest expense, net income from continuing operations, preferred stock adjustments, net income applicable to common shares; percentage growth trend for nine core Income statement areas for current year and 2 years prior.

General Ledger Annual Income Statement

Income statement with four quarters revenue, Cost of revenues, Gross profit, R&D expenses, Selling general and admin expenses, non-reoccurring expenses, other expenses, income (loss), EBITA, interested expenses, earnings before tax, tax, minority interest expense, net income from continuing operations, preferred stock adjustments, net income applicable to common shares; percentage growth trend for nine core Income statement areas for current year and 2 years prior.

g l cash flow statement available dashboards
G/L Cash flow Statement - Available dashboards

Annual Cash-flow statement

Operating generating cash flows, adjustments to net income, changes to AR, changes to liabilities, inventory, other op activities, capital expenditures, investment income (loss), dividends paid, sales and stock purchases, net borrowings, cash flow from finance activities, effects of exchange rates, changes in cash and cash equivalents for 3 years.

Quarterly Cash-flow statement

Operating generating cash flows, adjustments to net income, changes to AR, changes to liabilities, inventory, other op activities, capital expenditures, investment income (loss), dividends paid, sales and stock purchases, net borrowings, cash flow from finance activities, effects of exchange rates, changes in cash and cash equivalents for 4 rolling quarters

purchasing available dashboards
Purchasing - Available dashboards

Purchasing Annual Overview

Purchase orders, Goods receipts and Sales Orders received over the last 12 months, PO amount and number of POs issued and outstanding. Top-10 vendor analysis and individual vendor lookup, drill-down by plant and purchasing organization, 4 detailed data tables and 10 other graphs. Save, print, reset, refresh and help buttons.

Monthly Purchasing Overview

Daily breakdown of PO, Goods receipt, Sales Orders received, outstanding POs, ad-hoc period analysis (slider) for current month. Top-10 vendor analysis including returns, individual vendor lookup. Save, print, reset, refresh and help buttons.

Top-25 Vendor Performance Analysis

Top-25 vendor analysis of returns, POs, Goods received, invoiced received, outstanding POs, outstanding Sales Orders, monthly breakdowns and tracking, detailed data tables by month and averages also supported. Save, print, reset, refresh and help buttons.

sales management available dashboards
Sales Management - Available dashboards

Sales Analysis (scenario)

What-if scenarios analysis based on real data for growth COGS, returns, SG&A, Returns & allowances, sales growth, interest expenses and taxes, 6- key sales ratios, 6 month trending and save scenarios capabilities, print, help, reset and refresh also supported.

Sales Plan Performance

Sales performance for top-n customers, ideal for mobile solutions (i.e. tablet), tracking sales vs. plan (i.e. BPC) as well as prior year and variance. Live RSS feed can also be included.

sales order available dashboards
Sales Order - Available dashboards

Annual Sales Order Analysis

Sales current 12 months vs. last year, top-10 customers, top-10 materials, promotion sales current, prior and variance, drill-down to company code, sales organization, sales group and sales office, 3 detailed data table listing, 3 pie charts, 4 bar charts, reset, help, save scenario, print options.

Current Month, Week and Daily Sales Order Analysis

Sales current months, week, day and variance analysis for each period. top-10 customers, top-10 materials, promotion sales current, prior and variance, drill-down to company code, sales organization, sales group and sales office, 4 detailed data table listing, 3 pie charts, 5 bar charts, reset, help, save scenario and print options.

Sales Office Analysis

Sales Order tracking by Sales Office and regions, top-10 materials, monthly invoicing and disputes current year, invoicing by region, annual details and variance reporting. 1 Map, 2 pie charts, 4 bar/column charts, 2 data tables, reset, help, save scenario, print options.

budgeting available dashboards
Budgeting - Available dashboards

Annual Budgets Vs. Actual

Long-term trends revenues and expenses (upto 10 years), drill-down to Department, includes variance by year and detailed table data.

Monthly Budget Vs. Actual

Monthly budget revenues and expenses vs. actuals and remaining budget. Drill-down by fund center.

Organizational Unit Monthly Budget Vs. Actual

Monthly budget revenues and expenses vs. actuals and remaining budget. Drill-down by org units.

Long-Term Financial Plan - Annual

Upto 5 years financial plan based on prev years actuals, BPC, Hyperion or BCS. Revenues, expenses and variance historical and forward looking. Drilldown by fund center, cost center or profit center.

Long-Term Financial Plan Overview - Expenses

Operating expense planning and actuals trend with budget balances and plan balances.

Growth and Trend Expenses and Revenues

Growth rates for any given period for revenue types, expense types, compounded rates, 3-5-10 year rates YTD, and averages.

travel expense available dashboards
Travel Expense - Available dashboards

Travel Expense Purpose Analysis

Travel expenses by month and expense category. Drill down to Company code, business unit, department, cost center and employee level.

Travel Expense Change Analysis

Month comparison with prior year month, by expense category, amount, percent change, variance. Drill down to Company code, business unit, department, cost center and employee level.

Disallowed Travel Expense Analysis

Breakdown of policy, missing receipts, disapproval, audit rejection, incorrect amount and percentages for each expense category for the last 6 month. Drill down to Company code, business unit, department, cost center and employee level.

Travel Expenses Budget Vs. Actual

Budget vs. actual and remaining budget in amounts and percentages color coded based on growth from prior year. Supports local budgeting and changes to budget. Drill down to company code, business unit, department, cost center and employee level.

Annual Travel Expenses

Annual actual expenses, growth & payment type tracking.

mobile
Mobile

All dashboards are web based and may be rendered on a mobile device.

Future development may also include HTML-5 and non-flash based apps

With Flash version 11 installed, all dashboards may be rendered on a mobile device.

Further optimization is also possible for older devices with low memory or low network capacity