Sparkline chart components. The new Sparkline chart is based on the Sparkline chart created by Edward Tufte and provides a method for displaying a one-dimensional range of numeric data in a way that is dense, takes up a small space, and can be quickly interpreted. It is useful for creating small, data-intense graphs to show trends and variations associated with a specific measurement, such as stock market activity. Designers can set key data points start value, end value, low value, and high value that will be displayed as markers on the Sparkline chart. They can also define a normal range that will be displayed as a colored background behind the chart.
|Published (Last):||19 February 2006|
|PDF File Size:||19.81 Mb|
|ePub File Size:||2.51 Mb|
|Price:||Free* [*Free Regsitration Required]|
Sparkline chart components. The new Sparkline chart is based on the Sparkline chart created by Edward Tufte and provides a method for displaying a one-dimensional range of numeric data in a way that is dense, takes up a small space, and can be quickly interpreted.
It is useful for creating small, data-intense graphs to show trends and variations associated with a specific measurement, such as stock market activity.
Designers can set key data points start value, end value, low value, and high value that will be displayed as markers on the Sparkline chart. They can also define a normal range that will be displayed as a colored background behind the chart. Bullet chart components. The Bullet Chart components have a single primary measure for example, current year-to-date revenue that is displayed as a vertical or horizontal bar.
A marker indicates a target or performance goal and changing color hues behind the bar indicate qualitative ranges of performance for example: poor, satisfactory, and good. Designers can configure the Bullet Chart to display multiple series and can configure the scale, axis, and ticks separately for each series. For example, the chart can be configured to show revenue in thousands of dollars, profit in dollars, and order size as a count. Scorecard Selector component. A new selector component is available that allows you to display visual alerts in a grid.
The new Scorecard selector component is similar to the List View selector component, but includes options to enable and configure alerts in columns and to add headers that allow users to sort the columns at runtime. Alert levels can be displayed with cell background colors, font colors, or alert icons with or without values.
Canvas container component. A new container component is available for creating an invisible container. The new Canvas container component is similar to the Panel container component, but it does not have any art for example, background, borders, heading bar, and so on.
In design mode, the container is visible to allow the designer to work with the component, but when the model runs, the container is invisible so components in the container appear to be free floating.
If the components in the Canvas container extend beyond the container borders, scrollbars are added. Push Button component. A new selector component allows users to restore Single Value components to their default values without resetting the values for the entire model.
The new Push Button component can be configured to set the values of one or multiple cells to specific values when the button is pushed. The values change only when the user pushes the button, so users have more control over when the data is copied to the destination cells. SWF Loader component.
A new web connectivity component is available for loading SWF files at run-time. Unlike the Slide Show component, it does not provide transition effects when moving from one file to another and it does not allow you to block user interaction. It does have some advanced options that I believe offer the opportunity to load more sophisticated SWF files and have them interact with the model. Chart data labels. A new option is available to overlay data labels on or around chart markers.
When selected, data labels are visible for the chart markers. Designers can specify the values used for the labels, the label position, and, if applicable, add leader lines. The options available for configuring the labels depends on the type of chart. Chart range slider. For many chart components, you can now add a range slider to allow users to focus on a particular data set rather than viewing the entire chart at once.
At runtime, the range slider appears below or to the left for bar charts of the chart and allows users to select the data range that is shown in the chart. Users can change the size of the range by adjusting control handles on either side of the range slider. Chart sorting. If the chart contains multiple series of data and sort by data is selected, the designer can also specify which series the data will sort on. When the property is selected, users can select which series are shown in the chart.
If selected, at run-time, users can deselect checkboxes or click the series name in the legend to remove the series from the chart display. Dynamically set color. You can now bind color values to cells in the spreadsheet to dynamically control colors of component elements.
This option allows you to select a cell in the spreadsheet as the color value. The cell could then be linked to another component or external data source to dynamically set the color value at run-time. When a color is bound to the spreadsheet, the Color Selector icon on the Color tab is replaced by a new Bind icon.
Load default scenario. The Local Scenario button component now allows users to create and load a default scenario. The new default scenario option allows users to set the model to a specific state when the SWF loads. When designers include the Local Scenario button component in models, at runtime, users can click the button to define and save a scenario.
They can then click the Set Default option to load that scenario by default. The next time the model is opened, it automatically loads the specified scenario.
Note: Default scenarios are valid only for the local scenarios on the computer where they are defined that is, the local computer. Gauges support multiple indicators. Designers can now configure gauges to display multiple indicators, as well as set the indicator type to be a needle, outside marker, or inside marker. When designers bind a gauge to multiple spreadsheet cells, the gauge displays an indicator for each cell.
The designer can then configure the indicator type, label, and label position for each indicator. Note: When a gauge has multiple indicators, it is an output component only. The Trend Analyzer component can now be configured to forecast data for a specific time period based on the trend found in existing data. Designers can bind the Trend Analyser component to a range that includes the historical data plus empty cells for the forecast data.
At runtime, the Trend Analyzer inserts the trend data and forecast data into the specified cells. Designers can also specify the number of forecast periods the Trend Analyzer will forecast. To set the number of forecast periods dynamically, designers can bind the Number of Forecast Periods box to a spreadsheet cell and, then bind a dial to the same cell.
At runtime, users can manipulate the dial to set the number of forecast periods. Selectors allow multiple insertions. Many selectors can now be configured to insert multiple chunks of data from different sources into multiple destinations at once. By default, the list box contains one insertion behavior.
Designers can click the Plus icon to add more insertion behaviors. The designer then selects each insertion behavior and specifies its Name, Insertion Type, Source Data, and Destination. At runtime, when users use the selector, the source data values for all the defined insertion behaviors are written to their specified destinations.
This is fantastic news! If this is anywhere near as complete as advertised, developers will really start saving some time and adding some real value. The advancements promised by this service pack are certainly something to get excited about.
It looks like SAP has really listened to product feedback. I also see the push button as a great timesaver from those developing whatif scenario analysis visualisations. A great XMAS present. I see lots of great new functionality. The new SWF loader component looks realy interesting for integrating multiple dashboards within one single dashboard. This is a great component for multi touch usage. Which version of Flex framework the component support?
When I checked it last time it was using flex 2. Looking good! Stability good so far as well…. I am in the middle of a major effort to deploy an executive dashboard before year-end and I knew I had a lot of work to do in order to get around the three major issues for me; multi selection, multi series manipulation and all the extra cosmetic work to create printable dashboards yes Senior mgmt still likes to have their own printouts… so with the SP3 will be able to enjoy some of my vacation time after all because I can use out of the box functionality and save me tons of development time!!!
Is anybody having trouble adding xml data connections with sp3? It will run my previously existing files just fine, but any new files I create do not pull in the data.
Any ideas? I ended up exporting the data file, making the change in Excel, reimporting, and then resetting up the connection. Then it worked fine…. Dear All, Tried the new version. Much stable. The improvements make me feel that SAP is really keen on listening to our feed backs.
I just realize the new version has taken away vertical value Axis Labels number format options for charts. Does that happen to you too? Farid, sorry about not replying — yes, you can do it by overlaying multiple charts, with transparency if necessary — and see the xcelsius forum link below for more information. Is it possible for the range slider to handle other componants as well? Can I in some way pick up the current status in the slider for other componants to show the same time range?
Can we shift the axes in chart components so that the values start from any arbitrary number and not zero? El SP3 es bastante estable e integra mucha funcionalidad! It has arounnd components in it.
While there were some initial negative reactions to Xcelsius , much of that has subsided with the Xcelsius community understanding our strong commitment to support and enhance the user experience for Xcelsius products. Xcelsius Present is a new product for those users looking to turn Microsoft Excel spreadsheets into engaging and interactive data presentations. It comes with 10 ready-to-use templates allowing first-time users to immediately use and benefit from the solution. Our goal is to deliver these Fix Packs on a regular basis to ensure that you get the most out of your Xcelsius application. See what some of you have already built on the Xcelsius Add-on Marketpalce.
Xcelsius in 2008