Skip to Content
Former Member
Nov 10, 2008 at 09:43 PM

Cube like aggregation behavior from a flat file data source


Is the following workflow possible in Xcelsius and if so how would your organize you logic to be able to acheive this? Any examples would greatly be appreciated

My data source is XML, therefore a flat file.

The flat file contains multiple dimensions for which the customer wants to aggregate by based on the selection and also include and "ALL" option for every dimension/selector.

Essentially, the file is structured like this:

ie: Dim1 Dim 2 Dim3 Dim 4 Dim5 Metric1 Metric2

a c e j l 5 5

a c e j m 3 2

a c e j n 4 8

a c e k o 3 4

a c e k n 8 2


We need drop down selectors for Dim1-Dim4 with the "ALL" option. I would have my tables and charts etc use the Dim5, Metric1 and Metric2.

I've used the "Lookup" function to create 1 level of aggregation in a flat file structure with 1 dimension, such as the "Lookup" would call all the Dim1entries and insert into a group of referenced cells and then i would use the "Sum" function from Excel.

But is this possible with multiple dimensions and include the "ALL" option. If so, how? The workflow defined is ideal for a CUBE architecture but for many different political reasons we need to be able to address this with Xcelsius being sourced from a flat file ie XML. Any insight would be greatly appreciated..