1 / 28

Directions EMEA 2012 25 – 27 April 2011, Rome Mastering the Visualization AddIns in Dynamics NAV 2013

Directions EMEA 2012 25 – 27 April 2011, Rome Mastering the Visualization AddIns in Dynamics NAV 2013. Mastering Visualizations in NAV 2013. Empowering end user to explore and understand Business Data. Empowering end user to explore and understand Business Data. Business data & processes.

red
Download Presentation

Directions EMEA 2012 25 – 27 April 2011, Rome Mastering the Visualization AddIns in Dynamics NAV 2013

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. Directions EMEA 201225 – 27 April 2011, RomeMastering the Visualization AddIns in Dynamics NAV 2013

  2. Mastering Visualizations in NAV 2013 Empowering end user to explore and understand Business Data Empowering end user to exploreand understand Business Data

  3. Business data & processes Insight Monitor Discover Act Query, O-Data Charting Client Extensibility Interop Async, Performance Managed data layer Dev tools Customize and utilize Scale our strategy

  4. Enhancements in Dynamics NAV 2013 Generic Charts Specific Charts Business Data Visualizations Client Extension Framework

  5. Add-in framework Custom Interfaces Tooling (from Blogs)

  6. Charting capabilities in NAV 2013 • Rich set and combinations of chart typesColumn, Point, Line, ColumnStacked, ColumnStacked100, Area, AreaStacked, AreaStacked100, StepLine, Pie, Doughnut, Radar • Select dimension for X-Axis, and Z-Axis • Select any number / up to 6 measures for the Y-Axis

  7. Empowering application developers to create powerful chart visualizations

  8. The Chart Add-In for developers

  9. ”Hello World” code sample The Chart Add-In for developers

  10. The Chart Add-In: App tooling • Standardized initialization (locale,…) • .NET interop code (Values, Measures,...) • Utility functions on top • Same fully tested code used by standard Microsoft functionality

  11. Real World Use Case: Cash Flow Chart

  12. Chart::AddInReady() DemoCashFlowChartMgt.GenerateData( BusinessChartBuffer); BusinessChartBuffer.Update(CurrPage.Chart); WITH BusChartBuf DO BEGIN Initialize; AddMeasure('Accounts Receivable', 1,"Data Type"::Decimal,"Chart Type"::StackedColumn); AddMeasure('Accounts Payable', 2,"Data Type"::Decimal,"Chart Type"::StackedColumn); AddMeasure('Forecasted Balance', 3,"Data Type"::Decimal,"Chart Type"::Line); AddMeasure('Credit Limit in Banks',4,"Data Type"::Decimal,"Chart Type"::StepLine); SetXAxis('Date',"Data Type"::DateTime); BalanceDate := WORKDATE - 1; // demo. Should be TODAY. CalcBankBalance(BalanceDate,TotalBalance,BankCreditLimit); FOR i := 1 TO 6 DO BEGIN // Generate 6 columns CustNetChange := CalcCustNetChange(BalanceDate,BalanceDate); VendNetChange := CalcVendNetChange(BalanceDate,BalanceDate); TotalBalance := TotalBalance + CustNetChange + VendNetChange; AddColumn(BalanceDate); // X-Axis value SetValueByIndex(1 - 1,i - 1,CustNetChange); // zero indexed. SetValueByIndex(2 - 1,i - 1,VendNetChange); SetValueByIndex(3 - 1,i - 1,TotalBalance); SetValueByIndex(4 - 1,i - 1,BankCreditLimit); BalanceDate := BalanceDate + 1; END; END;

  13. Drill-down Chart::DataPointClicked(point : DotNet "Microsoft.Dynamics.Nav.Client.BusinessChart.BusinessChartDataPoint") BusinessChartBuffer.SetDrillDownIndexes(point); DemoCashFlowChartMgt.OnDataPointClicked(BusinessChartBuffer); OnDataPointClicked(VAR BusChartBuf : Record "Business Chart Buffer") DrillDownDate := BusChartBuf.GetXValueAsDate(BusChartBuf."Drill-Down X Index"); CASE BusChartBuf."Drill-Down Measure Index" + 1 OF 1 : DrillDownCust(DrillDownDate); 2 : DrillDownVend(DrillDownDate); 4 : DrillDownBank; END;

  14. Relation to Generic Charts Specific charts with Chart AddIn Generic charts Identical rendering capabilities Based on a chart definition End user UI CAL tool: BusinessChartBuilder Platform data aggregation from Table & Query • Identical rendering capabilities • Custom API to CAL • CAL tool: BusinessChartData • Data: .Net Data Table filled by App developer

  15. Controlling Generic Charts from CAL • Generic charts are defined by Chart Definition • Contains: • Data source, custom column filters (based on Query or Table) • Measures, custom totaling methods, chart type • Dimension (X / Z), custom titles • Tool for CAL developer available for creating and editing of chart definitions: BusinessChartBuilder • Used by Chart Configuration tool (Objects 918x)

  16. How to build a specific FactBox Chart

  17. Page Properties and triggers SourceTable = Item; OnAfterGetRecord() UpdateChart; UpdateChart() IF NOT AddinIsReady THEN EXIT; DemoItemSalesChartMgt.GenerateData(BusinessChartBuffer,Rec); BusinessChartBuffer.Update(CurrPage.Chart); Chart::DataPointClicked(point : DotNet "Microsoft.Dynamics.Nav.Client.BusinessChart.BusinessChartDataPoint") BusinessChartBuffer.SetDrillDownIndexes(point); DemoItemSalesChartMgt.OnDataPointClicked(BusinessChartBuffer,Rec); Chart::AddInReady() AddinIsReady := TRUE;

  18. Timeline Visualization: End user explore and interact with Business Data

  19. Timeline Visualization

  20. UI & interaction behavior

  21. Empowering application developers to use the Timeline Visualization in partner scenarios

  22. Timeline Viz – CAL Interface - Data

  23. Timeline Viz – CAL Interface

  24. ”Hello World” code sample The Timeline Add-In for developers

  25. The Timeline Add-In: App tooling

  26. Addin for easy delayed refresh

  27. PingPong AddIn – CAL interface

More Related