Archive for the ‘Guru Tips’ Category

Nov
9

Start Creating Your Own Custom Xcelsius Charts: Column Chart

As part of a small series that works through building a custom component, from demonstrating very basic functionality to more advanced and detailed property sheet integrations, I wanted to start with a very familiar and simple component concept to get started: A custom Flex-based column chart.

We’ll start by setting up the Flex component, its charting data provider, a few basic styles, and a very basic custom property sheet integration. You can find all of the (xlx, xlp, Flex source) source code here…

We’re working with an MXML-based component to illustrate a rapid way to construct custom charts and also because I prefer markup to pure ActionScript coding for readability and ease of use. I also think that a lot of attendees learning about the SDK for the first time at the BOBJ conference in October looked rightfully frightened seeing pure AS components and 1000’s of lines of code for 1 simple component. Here, we’ve used <100 lines of code for our chart, mostly markup, and we have achieved an impressively rapid custom column chart as the result. Creating this entire project (chart, property sheet, Xcelsius Packager) took under an hour.

LineChart

We’ll keep posting updated source code as this component evolves through the series, including in-line source code comments. Please note* Use the code however you’d like. However, it will be up to you to ensure its stability and is not recommended for a production environment, more as a jump start to inspire confidence and ideas for injecting easy and free custom charts into your Xcelsius projects.

To use the component in Xcelsius, bind the data property to a single row of data, as we only have 1 series at this stage. Then, select your fill type and you’re all set.

**I took the property sheet directly from the BOBJ SDK examples and quickly modified it to meet these requirements. Try it for yourself and see what else you can add on if you’d like.

**Also, remember to set up this project using the SDK fundamentals (i.e. setting the compiler to 2.0.1 HF3, referencing the Xcelsius SDK swc, etc.)

**If anyone has a custom chart they’d like to see, please feel free to comment.

Next, we’ll look at adding multiple series, custom tooltips, number formatting and some additional styling controls.

Oct
6

Xcelsius 2008 Service Pack 2, Fix Pack 1 Pre-Released

We first discovered it on Friday 9/25/09 ourselves.  It’s true,  Xcelsius 2008 Service Pack 2, Fix Pack 1 is available for download on the SAP download site.  See below:

X2008_SP2_FP1

When asked why it was not announced, SAP stated that they are waiting for the ‘Fixed Issues’ PDF to be posted on or before October 16th before making a formal announcement.

We are working to get more details, but for right now all you can do is install and test.

DOWNLOAD HERE

Sep
3

Formatting, Visibility and Watermarks

First off, there’s a new forum on the SAP site dedicated to the Xcelsius SDK – nice!

https://forums.sdn.sap.com/forum.jspa?forumID=466

After running through the Xcelsius SDK forum, I noticed a few quick-win issues posted that I’d like to lend a hand on.

The issues are:

  1. Dynamic Visibility
  2. Number Formatting
  3. and…Flex Charting Watermarks (a very annoying problem).

(more…)

Aug
6

Xcelsius 2008 Service Pack 2 (SP2) is HERE!!

Please download SP2 directly from SAP Software Download Site. This download applies to Xcelsius Engage, Engage Server and Enterprise. Not Xcelsius Present.

For information on how to install it, please visit the Documentation Site Which includes the following:

• What’s Fixed in Xcelsius 2008 Service Pack 2

• What’s New in Xcelsius 2008 Service Pack 2

• Xcelsius 2008 Installation Guide

• Xcelsius 2008 SP2 Release Notes

• Xcelsius 2008 SP2 User Guide

We look forward to receiving your feedback and comments.

Jun
30

Video: Show Chart Values without Hovering

One of the more annoying things about Xcelsius charts is its inability to show data lables. That is to say, you can’t see the values of each data point on a chart without hovering over each point. In this video, I show you how you can leverage one of Excel’s oldest tricks to actually show chart values without hovering. Even cooler than that, I show you that you can do this without adding a data grid, textbox or any other component to the chart visualization. That’s right, show chart values without the aid of any other components. Enjoy!!

Mike Alexander is the author of several books on advanced business analysis, including Crystal Xcelsius For Dummies. You can find Mike at www.datapigtechnologies.com, where he serves as principle contributor and shares free video tutorials with the Microsoft Office and Xcelsius communities.

Jun
18

Xcelsius SDK Challenge

This month SAP is holding the Innocentive Xcelsius SDK component challenge, enabling developers to create and submit innovative add-on solutions that bring value to the Xcelsius 2008 environment. This is a great opportunity to earn recognition for your submission(s) and to possibly claim some prize cash should you emerge as a category winner.

(more…)

May
19

Video: Charting Best Practice for Easy Chart Switching

Have you ever created a Line chart, then decided you needed a Column chart? Making the switch between chart types is easy in Excel, but in Xcelsius there is no way to quickly change chart types. You simply have to start over. That means adding a new chart to your canvas, re-doing all your configurations, an apply the formatting as needed.

Well in this video, I show you how a simple charting best practice and save you tons of time and energy.

Mike Alexander is the author of several books on advanced business analysis, including Crystal Xcelsius For Dummies. You can find Mike at www.datapigtechnologies.com, where he serves as principle contributor and shares free video tutorials with the Microsoft Office and Xcelsius communities.

May
12

What Is Possible With The Xcelsius 2008 SDK?

I often receive the question “I want to do xyz with a Flex custom component integration in Xcelsius 2008, is that possible?”. Nearly every time, my answer is yes – as long as you’re developing using the proper version of Flex, you can pretty much do anything you want with the following general guidelines in mind.

General component plausibility checklist:

  • You’re using the proper version of the Flex SDK, which currently happens to be 2.0.1 for Xcelsius 2008
  • You’re not trying to reference, modify, or inherit from Xcelsius objects in any way
  • You’re not trying to reference, modify or inherit any Xcelsius styling or themes
  • You’re familiar with Flex and Flash security and your component doesn’t violate security measures (must follow standard security considerations) that are in place in either one of those layers.
  • Always check with known issues and the latest SDK documentation

checklist2

If you follow the general rules above and the guidelines that the Xcelsius SDK has set forth, you should be clear for takeoff and can start exploring options, like the following examples.
(more…)

May
5

Video: Conditionally Formatting Y-Axis Labels

Did you know that you can add colors to your custom number formatting in Excel?  Not only that, but you can leverage Excel’s custom number formatting to add color to all kinds of Xclesius components.  I recently produced a video demonstrating how to apply colors to Y-Axis labels based on simple conditions.  This is an easy way to add another layer of analysis to your charts without adding overhead to your Xcelsius dashboards.

Mike Alexander is the author of several books on advanced business analysis, including Crystal Xcelsius For Dummies. You can find Mike at www.datapigtechnologies.com, where he serves as principle contributor and shares free video tutorials with the Microsoft Office and Xcelsius communities.

May
4

Top 10 Xcelsius 2008 SDK FAQ’s

  1. What kind of custom components can I build for my Xcelsius 2008 dashboards?

    You can build from scratch or extend any existing component that is available in the Flex 2.0.1 SDK. Below are some common cases (just to name a few) for custom component development. You may need to:

    • Connect to custom data sources
    • Design custom navigational elements and menu systems
    • Create custom charts, gauges, heatmaps and other data visualizations
    • Develop custom bi-directional application integrations with external business systems (i.e. Salesforce, etc.)
  2. (more…)