This article introduces Dashboard Simulators™ and illustrates basic techniques for creating and applying them. Dashboard Simulators™ allow you do things you can't normally do in Excel… at least not easily. Some of their basic facilities include incrementing and looping mechanisms. Others entail altering how computations are performed. This article addresses how to harness these capabilities in ways you wouldn't ordinarily think about when working with conventional spreadsheets. In the process, practical issues in deploying Dashboard Simulators™ are explained.
Welcome to The Xcelsius Journal, the publication dedicated to delivering authoritative information and techniques for using Xcelsius 2008 and Crystal Xcelsius (products of Business Objects, an SAP Company) and related dashboard products and technologies.
The Xcelsius Archives 03
In this issue...
We introduce the topic of Dashboard Simulators™ which is a framework for handling "programmer" style facilities within a dashboard (such as incrementers, loops, and conditional logic). We show to create dynamically resizeable geometric shapes in your dashboards.If you want to have a firm handle on moving averages, this is your place to learn about it. The panel below is an
interactive panel that allows you to click on each of the four pictures
in the grid and go directly to the associated article, file downloads
for that article, or post a note about the article in the forums. Click
here for help on how to use the Navigation Panel.
Dashboard Simulators™, Geometric Widgets, Moving Average Dashbooards, & Standalone Applications
This article introduces Dashboard Simulators™ and illustrates basic techniques for creating and applying them. Dashboard Simulators™ allow you do things you can't normally do in Excel… at least not easily. Some of their basic facilities include incrementing and looping mechanisms. Others entail altering how computations are performed. This article addresses how to harness these capabilities in ways you wouldn't ordinarily think about when working with conventional spreadsheets. In ... Read More >>
One of the benefits of using Crystal Xcelsius is that the widgets and dashboards you can create are highly interactive. Interestingly enough, that interactivity can be extended further. This article shows one of the ways you can create dynamic geometric shapes that can resize and reposition themselves at the touch of a slider or change in data.
A dashboard represents the intersection of visualization, interactivity, and analytics; hence, the term visual analytics. An important aspect in time series data is to show information and compute moving averages for such data. While this capability exists within Excel, its interactive capability is not easily harnessed in spreadsheets. This article explains how to prepare and represent interactive moving averages in your Crystal Xcelsius dashboards.
We are all used to building dashboards as a part of a presentation or report; but what about building standalone applications using Crystal Xcelsius? This article explores some basic ground rules using an example drawn from the popular game called Sudoku. ... Read More >>
