How to connect Xcelsius data to Flex...

My question pertains to Business Objects software Xcelsius 2008 which we are using to create a dashboarding application. Xcelsius uses a copy of an Excel spreadsheet and creates a locally bound version then severs the connection with the original spreadsheet. Therefore, after loading in my Flex component into Xcelsius 2008, how do I create properties for the component so Xcelsius will allow me to bind the Excel data grid to elements of my Flex component??How to connect Xcelsius data to Flex...

I found in the book ''Xcelsis 2008: Dashboard Best Practices'', written by Loren Abdulezer who is also connected with Xcelsius Journal, that is states to modify a line of code from a previous example in the book.?The instructions don't directly fix the problem because they only address the example used in the book and not a generic, custom application. Here is the abridged code from the previous sample BasicHorizontalSlider.as:

package com.anl.book.basicslider

{

import mx.controls.HSlider;

import mx.controls.Label;

[CxInspectableList (''title'', ''showTitle'')]

[Inspectable(defaultValue=''showTitle'', type=''String'')]

[Inspectable(defaultValue=''Title'', type=''String'')]

.

.

.

There is also a get/set function for each ''title'' and ''showTitle''

public function get title():String{...}

public function set title(value:String):void):String{...}

public function get showTitle():String{...}

public function set showTitle(value:String):void):String{...}

.

.

.

The steps for the fix are as follows:

1. Change the line of code in the BasicHorizontalSlider.as file from [CxInspectableList(''title'',''showTitle'')] to [CxInspectableList(''title'',''showTitle'',''value'')]

2. Save file

3. Re-compile the SWF

4. Rebuld the .xlx file for Xcelsius

5. Load the new component

I suppose my question would be how does this solution get modified to my example or for any other example in the future? The previous sample referenced by BasicHorizontalSlider.as is a app which displays a sliding bar displaying the x-value in a tooltip as you drag the control left and right. So, then is the element CxInspectableList the variable which needs to be changed per usage?

Any suggestions?

Thanks in advance.

Alex Dove

How to connect Xcelsius data to Flex...

I am making progress!?I have successfully created a horizontal slider component in Flex and integrated it with Xcelsius spreadsheet to display data. Hooray!

This is a simple binding of linear information. The slider takes the values bound to it from the range in the spreadsheet and assigns it to ''Value'' When I slide the slider handle the numbers move, however, since the ''defaultValue'' had been coded and the starting number in the spreadsheet range was 6 the slider handle started at the number 6. This is good, but not something I can work with in its current state.

My attempts to restructure the code to display graphing data in a column chart has been unsuccessful. Upon import of the Flex component onto the canvas of Xcelsius no data binding occurs. Rats!

Any suggestions?

I am making progress! I have successfully created a?horizontal slider component in Flex and integrated it with Xcelsius spreadsheet?to display data. This is a simple binding of linear information. The slider?takes the values bound to it from the range in the spreadsheet and assigns it to?''Value'' When I slide the slider handle the numbers move, however, since the?''defaultValue'' had been coded and the starting number in the spreadsheet range?was 6 the slider handle started at the number 6. This is good, but not something?I can work with in its current state.

Hi,

Can u pls provide detail steps how to connect Xcelsius data to flax component.

Regards

Ravi