Posts Tagged ‘Dashboard Design’

Dashboard Design

SAP BusinessObjects Dashboard Design (formerly called Xcelsius) contains new features and

enhancements that are focused on improving productivity and direct enterprise data connectivity. These features and enhancements include new and updated support for SAP BusinessObjects Universe queries and integration with SAP BusinessObjects Enterprise.


Dashboard Design caching and processing servers

A new data processing layer is available for enterprise data connectivity and is designed to address the scalability and performance requirements of large scale dashboarding deployments. It includes two new servers: a Dashboard Design Cache Server and a Dashboard Processing Server. The Dashboard Design Cache Server provides data caching and sharing on consistent data models (Relational Universe queries) off the Semantic Layer, and the Dashboard Processing Server manages query processing requests. Both servers are integrated into standard BI Platform services including auditing and monitoring.


Query Panel

A new Query Panel is available for creating Universe-based queries in Dashboard Design. To define a query, you can now drag relational universe objects, dimensions, and measures from the Query Panel to the canvas. You can also define the order that result objects are returned by the query, the data sort order, query filters, and single- or multi-selection prompts. The Query Panel also provides a data preview of the query.


Query Browser Panel

The new Query Browser Panel displays a summary view of result objects, filters, and prompts included in the model and provides quick access to the Query Panel for creating and editing queries. You can also refresh queries from the Query Browser to update query data that is bound to components. When you drag a query from the Query Browser Panel to the canvas, a Prompt Selector component is automatically added to the model.


Direct data binding

In Dashboard Design, you can now bind data from query result objects directly to charts and selectors. When data is bound directly to charts and selectors, the component displays a preview of the query data on the canvas in design time.


Universe Connectivity components

The Components Browser contains a new Universe Connectivity category dedicated to query data connections. The Universe Connectivity category contains two new components: Query Prompt Selector and Query Refresh Button.

The Query Prompt Selector component automatically handles prompt value selection behavior based on the metadata for the query prompt. The Query Prompt Selector component is available in three styles:

• Single value

• Single or multiple selection with List of Values

• Single or multiple selection with cascading List of Values

If the prompt includes a list of values, the Query Prompt Selector component allows users to search for or browse through the list at runtime and also select whether the values are shown or hidden in the model.

The Query Refresh Button component allows users to request a refresh of the query data from within the model at runtime.


Regional Data Format by User Preferred Viewing Locale

Data formatting controls how data, such as dates, times, currency, and numeric values, is presented to users. In previous versions of the product, the data format was determined by the locale set when the model was created. Dashboard Design now allows models to format their data using dynamic regional data formats, which means that the format can be changed automatically to match the end user’s preferred viewing locale.


You do not need to do anything to configure regional data formatting. When Dashboard Design models are saved on the platform, the model automatically adjusts its data format settings to match the preferred viewing locale set in BI launch pad.


Text translation

In Dashboard Design, most text contained in models published to the platform can be translated to other languages through the Translation Manager. When a model is saved to the platform, the translation workflow is enabled and translation experts translate the text used in the model. The text translations are then published to the platform and combined with the model to create localized versions of the model. At runtime, user’s see the localized version that matches their preferred viewing locale.

The following text in Dashboard Design models can be translated:

• Most text input including titles, subtitles, series names, category names, and so on.

• Data in Excel ranges that are marked as translatable by the model designer.


Dashboard Design objects


Dashboard Design introduces a new object type in SAP BusinessObjects Enterprise. Previous versions of the software required two objects: an Xcelsius object for working with the model in the designer, and a Flash object for running the model. The new Dashboard Design object holds both the design document (XLF) and the Flash file (SWF) in a single object.

If the object is opened in Dashboard Design and modified or changed through the Translation Manager, the SWF cached in the Dashboard Design object is automatically updated to reflect the changes. Model designers do not need to re-export the Flash object separately for users to receive the latest changes.

Dashboard Design objects support object-level security. For example, system administrators can set the user rights to block certain users or user groups from modifying or even viewing the dashboard.For models that have Universe query connections, system administrators can specify preferred server groups for query caching and processing. Object-level caching options override server-level settings,so system administrators can allocate resources and adjust processing settings to accommodate individual model requirements.


Lifecycle Management of Dashboard Design objects

To integrate with Lifecycle Management support in SAP BusinessObjects Enterprise XI 4.0, the new Dashboard Design object maintains relationship and dependency information, including the model’s:

• relationship with Universe queries

• dependency on QaaWS and Universe objects in QaaWS connections

• dependencies on correspondingCrystalreports, Interactive Analysis documents, and Universe

objects in Live Office connections

With integration to Lifecycle Management tools, system administrators can check dependency information for Dashboard Design objects and make sure all dependent objects are promoted together.

Dashboard Design models access SAP BusinessObjects Enterprise data through a Web Services

connection. If the model is migrated to a different location, such as from a testing system to a production environment, the Web Services URL might change. To support this scenario, Dashboard Design models accept dynamic Web Services URLs at runtime. BI launch pad and the CMC retrieve the Web Services URL from the Web Services application object for the Web Services connection.