Advanced Dashboards using Extensions in SAP Design Studio - Webcast Notes

[TammyPowlas]

Tuesday I attended this Visual BI webcast; I won’t repeat what is already posted here Advanced Dashboards using Design Studio Extensions Webcast Notes

Design Studio 1.5 introduced mapping capabilities.  Visual BI says they provide more advanced capabilities; they have integrated maps into existing landscape – map to a Crystal, Web Intelligence or another DS dashboard.  Extensions include filtering, time-based filtering, and dual axis charts, gauges, spark line charts, waterfall

Charts come with a List of properties, they are exposed inside of Design Studio

Figure 1: Source: Visual BI

The plot band shows the background of chart changing

Figure 2: Source: Visual BI

Figure 2 shows different states and street level maps (right hand side), with states, county level

Figure 3: Source: Visual BI

At times you want to compare across multiple years

Time based filters give you the option to configure how value is sent to underlying data source (HANA, BW or Universe) (Figure 3)

True hierarchical filtering in lower left

Figure 4: Source: Visual BI

Configure an alert so user can focus on certain “products

Overview:

The extensions are updated once a quarter

The next version is planned before SAP TechEd, “going beyond standard Design Studio”

Identical scale can be used for multiple charts to make sure charts show identical scale

Themes, charts, - theme editor, color coding, export what is needed

It will generate style sheet code for you

You can integrate maps with existing BusinessObjects system, when you see data, take action

Figure 5: Source: Visual BI

Offset period selector to adjust for business year

July 2015 would be the start of business year for 2016 – this can be configured

Figure 6: Source: Visual BI

Table component is VB

• Search the table
• Column independent sorting like Excel
• Paging – to show # of rows on a page; important for mobile
• Alerting capabilities – alerting inside the dashboard itself
• Custom calculation – actual & budget – you can create the calculation
• Format without CSS

Figure 7: Source: Visual BI

Use Excel as a datasource – to show business user what Design Studio is capable of doing for a prototype

Figure 8: Source: Visual BI

PDF workflow differs between Design Studio and Visual BI

Standard Design Studio developer defines what is being exported

Visual BI leaves choice to business user

Figure 9: Source: Visual BI

Using the hierarchical filter shown in Figure 9, you can select children, descendants, parents and pass them to underlying datasource

Business user can open/close the hierarchy

Drilldown – drill along a hierarchy – expand to next release – expand/collapse inside the chart

Figure 10

Figure 10 shows the what-if scenario; you select measure to influence, based on percentage or absolute value

With the panel on the right you can change values.   This is not a replacement for planning but to change values in Dashboard

Figure 11: Source Visual BI demo

Maps can include a non geo dimension

Integrate as shown each time click on marker you are opening a report – the context is used – store location – Web Intelligence, Crystal

Maps work on a mobile device

Maps can use longitude and latitude or address; with complete geo-coding

A roadmap was shown during the session - see presentation here starting on slide 26

Question & Answer

Q: Components work with BI4.2?

A: Working with Design Studio releases; 1.6 planned for end of year will likely support BI4.2

Related

In-Depth Learning with Pre-Conference Sessions at SAP TechEd

Take a deep dive into a particular topic during the Pre-Conference Sessions offered Monday, October 19, in Las Vegas.   Join ASUG Volunteers for a full day, hands-on SAP BusinessObjects Design Studio Deep Dive.  Sign-up for pre-conference seminars during the registration process.  If you have already registered and would like to add a pre-conference session, visit the following registration page.

Next week: See what's new in latest 1.6 release of #SAPDesignStudio on #askSAP 9/17 Webinar - open to all