Tutorial Of SAP Digital Dashboard - UMD

2y ago
18 Views
2 Downloads
2.76 MB
12 Pages
Last View : 1m ago
Last Download : 2m ago
Upload by : Jacoby Zeller
Transcription

Tutorial of SAP Digital DashboardJiaofeng Lan, Shuo Sun, Sonam Sobti, Yangfan DengDecember 11, 20131Introduction to SAP Crystal Dashboard1.1What is Crystal DashboardDashboard is a powerful data visualization design tool belonging to SAP Crystal Solution Packagewhich is a series of Business Intelligence tools. The software can help enterprises take control ofcomplex data and give it meaning, turn raw data into sophisticated, interactive dashboards that willhelp clients understand your data more quickly and thoroughly. Crystal Dashboard use a simple pointand click interface to consolidate key information from multiple sources into dashboards to monitorbusiness performance. Dashboards with what-if analysis and visualizations such as charts, mapsand gauges present critical business key performance indicators (KPIs) with drillable, interactivedashboard views that can be deployed through SAP Crystal Server, or via Flash, documents, webapplications or mobile devices.1.2Why Use Crystal DashboardCrystal Dashboard is the first Dashboard software in the world and bridge the gap between dataanalysis and visual presentation. It has several features and benifits to make it a popular tool inenterpirse business intelligence application. Performance monitoringSimplify complex reports and data by consolidating them into actionalble, drillable dashboardin an understandable format with charts, maps and gauges. Platform independent information managementMake organized information available to everyone in multiple ways (Microsoft applications, webapplications, mobile devices, etc). Facilitate decision makingWith predictive models and real-time data, clients can can impact their decisions immediatelywith what-if analysis.1

1.3When To Use Crystal DashboardCrystal Dashboard is often a part of the business intelligence(BI) platform. Usually the keyclients of Crystal Dashboard is top management of a company. Because of the request of real-timeperformance on big-data and the popularity of evidence-based decision making, Crystal Dashboardhas more and more popular position in BI solutions. In these times, Crystal Dashboard has goodopportunities to produce its advantages: Provide real-time corporate information to management Simplify big data into understandable format Visualize complex reports and data Build predicting models and management models to facilitate decision making1.4How to use Crystal DashboardIn a nutshell, Crystal Dashboard import from Excel spreadsheets or databases, provide userwith multiple digital dashboard component, connect data to different components, add interactivefeatures build what-if or other management scenarios and export dashboards into existing platformor applications.1.4.1InstallationCrystal is a Microsoft-Windows based software that cannot support Mac or Linux now. SAPCrystal Dashboard 2013 Departmental Edition can be downloaded from SAP website for a 30-daysfree trail. Two key technologies are combined in Crystal Dashboard: Microsoft Excel and AdobeFlash Player. The two applications are required before installation.1.4.2Skill NeededCrystal Dashboard is designed to be easy to use. Since the core model of Dashboard is built inExcel, medium level of Excel knowledge is required. E.g. functions and formulas in Excel.1.4.3Importing DataAll Crystal Dashboard dashboards start using Excel spreadsheets often containing some data having gone through some analysis, massage, shaping data. Crystal Dashboard uses an Excel spreadsheetand imports a snapshot into memory snapshot. After the data is in memory, Crystal Dashboard disconnects from the Excel spreadsheet. Separated from the actual spreadsheet data out this methodcan ensure two things. First of all, your ultimate instrument panel is a separate object, independentof the original spreadsheet position or status. Secondly, it ensures that your final dashboard size assmall as possible so that it is easy to distribute.Crystal Dashboard can also import data from different databases and web servers such as SAPCrystal Server. When Crystal Dashboard cooperate with other businesss intelligence softwares, thisdata importing method is more common.2

1.4.4Building Visual ModelVisual model is essentially a dashboard in design mode. Much like a PowerPoint slide, yourvisual model starts off as a blank canvas on which you can add components. Components are thoseelements that give your dashboard its utility and purpose: charts, gauges, menus, forms, and so on.The idea is a single component added to your visual model, tying each component, importing thedata. Experienced users will apply finicial and management model in dashboad. E.g. Figure 1 is afiniance balance table applied in Crystal Dashboard.Figure 1: Balance Sheet With Crystal Dashboard1.4.5Export DashboadsAfter you are satisfied with functionality and visual appearance of your model, Crystal Dashboardis ready to compile it. First, Crystal Dashboard compiles your visual model to SWF file format.Compiled into a SWF file format ensures that your final dashboard play smoothly on any screen sizeand across multiple platforms. Moreover, this ensures a small file size of the dashboard, so as not todrown your user with gigantic 40MB file.After the visual model has been compiled to a SWF file, it is then published to a format of yourchoice. You can choose to publish your dashboard to PowerPoint, Outlook, an HTML Web page,an Adobe Acrobat PDF file, or a Macromedia Flash file. At this point, your dashboard is ready tofacilate your information management!2Example of Model BuildingThe interface of Crystal Dashboard is divided into 4 main parts. The left part is components list.The upper middle part is the canvas for Dashboards. the lower middle part is Excel spreadsheet.The right part is attribute of component.(Figure 2)3

Figure 2: Crystal Dashboard Interface2.1Introduction to Crystal Dashboard ComponentsCrystal Dashboard contains nine kinds of components: Charts, Containers, Selectors, Single value,Maps, Text, Other, Art and backgrounds and Web connectivity.2.2Example 1 Create a Bar Charts With Selectors1. Import data into Excel spreadsheet. The data contains products sales data of 7 products fromJanuary to April.Figure 3: Product Sales Data2. Add a column chart (in chart) and a list box (in selector) into the canvas.Figure 4: Original Dashboard4

3. Create label for list boxFigure 5: Product labelClick link button in label option in components property, then link it to the product labelcells(Figure 5) in Excel.Figure 6: Product Sales Data4. Create dynamic data area and link it to the components.Figure 7: Dynamic Data Area(a) Create an area in excel as dynamic area for column charts.(b) Click the list box. In its property area, click general option. In data insertion area: makeinsertion type Row.(c) Link the source data to the area of purchase quantity of each products of each month.(d) Link the destination data to the yellow dynamic data area(e) When you click each item in list box, it will insert the according line into the dynamicarea.5. Link the charts to dynamic data.(a) Click the chart.(b) In the property area, link the chart to the first cell of dynamic area. (the name of product).(c) Write the subtitle name as ”Purchase by Month”.(d) In data area, choose by series.(e) Click the plus button at the bottom of the series, add a new series Purchase.(f) Link the value to the last four cells of dynamic data area (the purchase quantity of eachmonth).(g) Link the category labels to the month area.5

6. Preview the modelClick button and you will see the preview below. Preview mode can help to test and debug.Figure 8: Final Dashboard In Preview Mode7. Export the modelClick file menu, choose export. Then choose the format you want to export. E.g. export it as.swf file. You can insert swf file into webpage, slides or documents.2.3Example 2 US Sales Map1. Dashboard(Please click and test the function!)2. Function of this module: Click each state, the pie chart will show percentage of each product of each state. Click each state, the table will show sales data of each state in detail. The color of each state is alert of each of sales data. If it is red, then the sales data is toolow.6

3. The spreadsheet of this module:2.4Example 3 Personal Finances Budget1. Dashboard(Please click and test the function!)2. Function of this module The tab page provides chart and table modes. In Chart model, user can get the trend andconstitute of his budget and actual expense. Click the drop down menu at the left top of the module, choose one of the option youwant to see details. The Year to Date Total chart and Budget vs Total chart will changeaccording to users options. Click the table option user can get details in tables. In What-if analysis, user can drag the slider to change the budget of each cost option.The three charts will change according to the change of each option.7

The scenario function can save, load and delete the budget scenarios. User can use thisfunction by clicking the scenario button at the right top.3. The spreadsheet of this module:3Frequent Asked Questions1. Do I need to install Adobe Flash while using Dashboard ?The Adobe Flash Player version 9 is required in order to function Dashboard Normal. If youdo not have Adobe Flash installed as part of the installation process, you can download andinstall Flash Adobe website.2. How to change the language in Dashboard ?Go to File¿ Preferences¿ Language, and select the language in the drop-down menu.3. What if my prefer language is not listed in Dashboard?Language that is selected during installation is only available in the ”Preferences” drop-down.If you wish to add an unavailable language, you should uninstall and reinstall Dashboard .4. Why does Dashboard function abnormally after I upgrade my Microsoft Office?When Dashboard is installed, it will automatically configure itself to work with Microsoft Officeversion that is currently installed. If you upgrade or change the version of Microsoft Office onyour machine, you must re-install Dashboard in order to properly use the new version.5. Why do the appearance of the components change when I Copy it to a new visualization?Some component customization will carry over into a new visualization. Themes do not carryover into a new visualization, but other customization will effect the appearance properties inthe new visualization.8

6. Why does not the visualization appear exactly the same with my spreadsheet customization?Some Excel features (conditional formatting and macros, for example) cannot be supported inDashboard models. So Dashboard will not display just exactly the way in your spreadsheetcustomization.7. Why does my table look different with my Excel spreadsheets?The table component only supports Verdana font. To match your opinion, please change yourfont to Verdana in your spreadsheets.8. Can I re-import the spreadsheet with renaming files?You can re-import the spreadsheet and renamed it, but any binding to the previous spreadsheetwill be lost in the new visualization.9. How can I embed SWF files into existing PowerPoint presentation in Dashboard ?You can open a SWF files and embed it into a new PowerPoint presentation by using the Exportto PowerPoint Options. Then you can cut and paste your SWF into another presentation.4Troubleshooting Questions1. Why don’t my Excel macros work?Dashboard does not support macros in Excel spreadsheets at this time.2. Why do I get the message ”A script in this movie is causing Flash Player to run slowly .”?The Flash Player for viewing in Dashboard visualization will display this message when thescript has been running for more than 60 seconds. Since the complexity of Dashboard visualization, larger visualizations running on slow machines may result from displaying this message.If you click No on the message dialog boxes, the visualization will load properly. Note: whilein preview mode, press yes to abort the script will cause the preview to stop working. Youwill need to exit the preview, and then return to the preview mode for the correct previewvisualization.3. Why do I get a serve busy message?The message indicates that the Excel has a pending operation or is busy preforming an instruction. Make sure that the Excel is not in the process of editing and then click Retry on thewarning dialog box.4. Why doesnt my URL button work?Your URL must include http:// in order to make it function properly.5. Why single value component cannot be dragged?The values of single value components are linked to cells with formulas cannot be adjusted.6. Why isnt my visualization connecting with external data source?The Flash version 9 that is required by Dashboard has security features, which may preventconnecting with external data source. Without a policy file, SWF files from one domain cannot9

access data on another domain or sub-domain. In addition, SWF files served over HTTP cannotaccess data at an HTTPS location.7. Why doesnt my component show scientific formatting?The visualization currently doesnt support scientific formatting at this time. Calculations thatdepend on scientific formatting will not be affected.8. How large can the Excel file be?There is no limit size of the excel file being used in Dashboard . Though there are many factorsthat can affect the performance of the visualizations. Those factors include: The amount ofdata that is being changed during the visualization The number of components on the canvasThe complexity of calculation being performed The performance can also be greatly affectedby the speed of the computer.9. Why does my visualization look strange when I open it?When the visualization is loaded, all selectors insertdestination ranges to populate other components withinserts last if there are more than one selector insertsObject Browser to view the order of the componentsOptions.their default selection data into theirdata. The selector at the highest layerinto the same range. You can use theand change the order using the Layer10. Why Microsoft office files cannot be opened normally when Dashboard is running?The Microsoft office files may not be opened normally when LiveOffice Compatibility Mode isenabled. To turn the mode off, select File –¿Preferences–¿ Excel Options. Then uncheck theenable button under Live Office Compatibility, click Apply and then OK button to exit.5Evaluation of Digital Dashboard5.1Delimitations of using Crystal Dashboard Dashboard supports most of Excel functions, but not all. The list of the functions supportedcan be found under Help ¿¿ Dashboard Supported functions. By default, Crystal Dashboard has a row limit of 512 rows that are readable from any datablock. That means that if you have a query returning 2000 rows of data, only 512 of them aregoing to be read. Though we can change the value for row limit, but inflating this number toohigh can make the dashboard slower as load times increase. Anything over 2000 rows can beunpredictable. Therefore Dashboard is not a good tool for analyzing 30,000 rows of data at thesame time. But the problem can be solved by importing data from databases or web servers. Dashboard doesnt support Pivot tables, you have to use aggregate functions like SUMIF instead. There are limitations when it comes to SUMIFs, VLOOKUPs, Index and some other arrayfomulas. Though these can be handled by Dashboard, the more formulas you have in yourdashboard the slower it becomes.10

Crystal Dashboard is a visualization and presentation tool. It is not a back-end reporting tool.It does allow data manipulation and transformation but solely for the purpose of visualizationand interactivity. For advanced data transformation such as type functionality, Dashboard isnot a good fit. After you begin with data modeling, it is not advisable to change worksheet names as it mayresult in losing all component cell bindings. Moving a worksheet from its position can alsoresult in loss of bindings. It is therefore advised to plan out all your sheets before you beginwith modeling. Crystal Dashboard is known for its visualization technology, not as a complete dashboard orscorecard solution. While Crystal Dashboard most definitely can build amazing dashboardsand scorecards, it represents only part of a complete dashboard or scorecard package. Mostdashboard and scorecard technologies on the market today come with a complete infrastructurefor managing key performance indicators and metrics, strategy mapping, collaboration, securityand navigation.5.2Advantages of Crystal Dashboard Crystal Dashboard enables simple point-and-click designs. Its interface includes prebuilt skins,components, maps, charts, and one-click export that can easily be used by business users withoutreally requiring technical skills to develop fully interactive business dashboards. Close relation with Excel. Creating charts in Dashboard is not only easy but very similar tocreating charts in Excel. Many charting methods and concepts that you applied in Excel applyto Dashboard as well. Also a lot of powerful Excel function can be used in model building, suchas fomulas, which empower Crystal Dashboard. Enables easy distribution of dashboards to your workgroup. With Crystal Dashboard workgroup, it is easy to distribute live dashboards and visual business models in Microsoft PowerPoint, Word, Outlook, and Adobe PDF so users have easy access to live data to gain deeperinsight. Visual components such as Sliders, gauges, filters, numerical input tools enable evaluation ofmultiple what-if scenarios in real-time, with the click of a mouse right on the dashboard. Dashboard results in gain in productivity when compared to programming. Below given is ascenario to state the same.Steps to Bind Data ResultProgrammingFetching data into result set5-10 minutesConverting data into bindable objects5-10 minutesPerforming looping calculations5-10 minutesCrystal Dashboard3 minutes0 minute¡1 minuteMost dashboards contain at least a half-dozen visualizations, each requiring unique data sets.Assuming that it would take average 20 minutes, to create one visualization programmatically,it takes about five minutes to do the same thing using Crystal Dashboard. So assuming youhave six visualizations, you can build a dashboard with Crystal Dashboard in little less than11

30 minutes to versus approximately 120 minutes with a more programming approach. That isabout 400% increase in productivity. Crystal Dashboard has alert functionality which is commonly used to call the attention of theuser to a specific item or action that has reached some pre-established limits. These limits areoften called targets, budgets, benchmarks, etc. and serve as a standard to which an item iscompared. Platform Independence make Crystal Dashboards easily apllied in diffenrent applications. Multiple Languages support. Crystal Dashboard is available in Dutch, English, French, German,Italian, Japanese, Spanish, and Simplified Chinese12

Tutorial of SAP Digital Dashboard Jiaofeng Lan, Shuo Sun, Sonam Sobti, Yangfan Deng December 11, 2013 1 Introduction to SAP Crystal Dashboard 1.1 What is Crystal Dashboard Dashboard is a powerful data visualization design tool belonging to SAP Crystal Solution Package which is

Related Documents:

SAP ERP SAP HANA SAP CRM SAP HANA SAP BW SAP HANA SAP Runs SAP Internal HANA adoption roadmap SAP HANA as side-by-side scenario SAP BW powered by SAP HANA SAP Business Suite powered by SAP HANA Simple Finance 1.0 2011 2013 2014 2015 Simple Finance 2.0 S/4 HANA SAP ERP sFin Add-On 2.0

SAP Certification Material www.SAPmaterials4u.com SAP Certification Material for SAP Aspirants at Low cost Home Home SAP Business Objects SAP BPC CPM SAP BPC 7.0 SAP EWM SAP GTS SAP Public Sector SAP Real Estate SAP FSCM SAP FI/CO SAP AC - FI/CO SAP BI 7.0 SAP CRM 5.0

SAP Master Data Governance SAP Information Steward SAP HANA smart data integration SAP Data Hub SAP Cloud Platform Big Data Services SAP HANA, platform edition SAP Vora Customer Experience IoT Workforce Engagement SAP Cloud for Customer SAP Commerce SAP Marketing SAP Asset Intelligence Network SAP Predictive Maintenance and Service SAP .

SAP HANA Appliance SAP HANA DB In-Memory A io BI Client non-ABAP (SAP supported DBs) SAP Business Suite SAP Business Suite SAP Business Suite SAP Business Suite SAP Business Suite SAP Business Suite SAP Business Warehouse SAP HANA DB r In-Memory Source Systems SAP LT Replication Ser

ALE/RFC Setup 88 SAP System Type 88 SAP IDoc Version 88 Program ID (SAP to e*Gate) 88 SAP Load Balancing Usage (e*Gate to SAP) 89 SAP Application Server (e*Gate to SAP) 89 SAP Router String (e*Gate to SAP) 90 SAP System Number (e*Gate to SAP) 90 SAP Gateway Ho

Customer Roadmap to SAP Simple Finance - Example " Adopting SAP Simple Finance is a journey - start early" Side-by-side SAP HANA Acceleration SAP HANA accelerators, BW, BPC, GRC SAP Business Suite on SAP HANA SAP ERP on SAP HANA SAP ERP in SAP HANA Enterprise Cloud SAP Accounting Powered By SAP HANA Simple Finance add-on/

SAP Business Suite SAP BW SAP Apps Partner Apps SAP HANA PLATFORM Planning and Calculation Engine Real-Time Replication Services Information Composer & Modeling Studio SAP UI HTML5 Mobile SAP BI 4 SAP ERP SAP CRM SAP SCM SAP PLM SAP SRM SAP Netweaver Predictive Analytics & Business Function Libraries In-Memory

mercedes a 180 free workshop and repair manuals mercedes a 180 the mercedes-benz a-class is a compact car produced by the german automobile manufacturer mercedes-benz. the first generation (w168) was introduced in 1997, the second generation model (w169) appeared in late 2004, and the third generation model (w176) was launched in 2012. mercedes-benz 180 service manual pdf download manualslib .