General Development Notes – Timeline Chart

Probably the most important thing to be mentioned is that custom flex components designed to be used as Xcelsius add-ons require to be compiled against Flex 2 SDK, latest being Flex 2.0.1 SDK with HotFix 3. You can’t use Flex 3/4 SDK and this haven’t changed with the latest Xcelsius 2008 SP3 version. I have no idea when this will change… Also Flex 2 SDK is not supported in the upcoming Flash Builder replacing Flex Builder.
Continue reading General Development Notes – Timeline Chart

Static and Dynamic Data – SWF Airline Report

Loading dynamic query data via web services in an ABAP stack is not an option for the online environment this site is hosted under. But loading data via static XML files is always an option no matter the environment. Xcelsius needs to have the xml data formatted in a certain way and because of this Xcelsius itself was used to transform the web service query data into compatible xml data. The end result is a static xml file that gets loaded every time you view the online report.
Continue reading Static and Dynamic Data – SWF Airline Report

Pivot Table Concept in Xcelsius – SWF Airline Report

Once the BEx query data is loaded into Xcelsius, an interactive list box gets initialized with possible airline options from a series of spreadsheet cells. List box data insertion functionality allows us to update a given spreadsheet cell with the current selected list box entry. All interactive elements from this report are based in one way or another to this single spreadsheet cell containing the current selected airline.
Continue reading Pivot Table Concept in Xcelsius – SWF Airline Report

Loading Web Service BEx Query Data – SWF Airline Report

The starting point is represented by a BEx query similar to the one described in the first airline report. A remote function module is created to load the query data. Based on it, a web service is generated. This web service will be used by Xcelsius to load the query data into an Excel spreadsheet.
Continue reading Loading Web Service BEx Query Data – SWF Airline Report

Dynamic Context Nodes from BEx Queries – Airline Report

Having a context node reflect the structure and content of a query data makes it easier to display it via webdynpro UI elements. InfoCube query calls are available via RRW3_GET_QUERY_VIEW_DATA function allowing advanced query control via run-time defined parameters. These parameters represent the query variables defined using BEx query designer. Continue reading Dynamic Context Nodes from BEx Queries – Airline Report

From DataSources to BEx Queries – Airline Report

The goal here is to be able to summarize and extract various airline comparison report data with as much freedom as possible when specifying what/how various airline attributes should be returned. An obvious choice is the olap cube, allowing us to define dimensions Continue reading From DataSources to BEx Queries – Airline Report