Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to pass a selection from a data island into an extension object, and having little success. I need to do this because the data island contains information about how I want to further process my main data selection.
Here is what I've discovered so far:
Thanks in advance,
Justin
Well, I've answered half of my question now myself with some more investigation.
Unlike the straight table, the extension object demands both expressions and dimensions to be populated for both the main data and the data island. I did this by adding an extra, fake, column to my data island and passing this in as an unaggregated expression.
This gives me the same set of data in my extension as I see in my straight table, and is subject to the same problem: the main data makes a cartesian join with the data island!
One approach to this would be to just look at the first value in the data island and ignore the rest.
I'd still like to know if there is an option to not use expressions and dimensions at all to interrogate my data island?
Do I have access to anything other than these within my extension?
Thanks
Well, I've answered half of my question now myself with some more investigation.
Unlike the straight table, the extension object demands both expressions and dimensions to be populated for both the main data and the data island. I did this by adding an extra, fake, column to my data island and passing this in as an unaggregated expression.
This gives me the same set of data in my extension as I see in my straight table, and is subject to the same problem: the main data makes a cartesian join with the data island!
One approach to this would be to just look at the first value in the data island and ignore the rest.
I'd still like to know if there is an option to not use expressions and dimensions at all to interrogate my data island?
Do I have access to anything other than these within my extension?
Thanks
An with a bit more time and investigation I've managed to bypass the cartesian join problem too! I've now passed all the information from my data islands in as a calculated, concatenated expression using the following in my Definition.xml:
<Measurement Label="Measure 1" Initial="DoseColumnID"/>
<Initiate Name="Chart.Expression.0.0.Definition" Value="'{' & Concat(DoseColumnID,',') & '},{' & Concat(TimeColumn,',') & '},{' & Concat(TimeUnit,',') & '}'" />
I can then parse this field and work out the contents of my 3 separate data islands from here, without the danger of a cartesian join causing 1000s of rows of data to appear in my extension object. Marvellous. Sorry to bother everyone with this thread, and then working an answer out for myself!