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
Custom Xcelsius Add-On – 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
Web Service Based Xcelsius Report – SWF Airline Report
Dynamic Business Graphics – Airline Report
The business graphic chart gets updated every time the table showing the BEx query data changes its selection. Selected table rows represent chart series and table column names represent the chart categories. Continue reading Dynamic Business Graphics – Airline Report
Dynamic Tables – Airline Report
Now that BEx query data is reflected into a context node, we can use this node to create dynamic tables to show its content. The first column of the dynamic webdynpro table will always represent the query Y axis, the rest of the columns representing the query X axis. Continue reading Dynamic Tables – 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