Using QWAAS dynamically in Xcelsius

other Xcelsius - Crystal Dashboard Design
1

I have an xcelsius model that uses live office to refresh data. I am using Xcelsius 4.5 with BOXI R2 SP2 accessing SQL Server 2005.

I am using a Pie chart to summarise the data returned from live office at the highest level. I then have a drill down to say split 1 (clicked on) year to 12 months in a Combi chart.

I then want to be able to drill down to a clicked month from the combi chart to list the transactions that make up the month value.

I have this working at present, but i get an overflow error and get a truncated error.

I think i have a way around this by setting up a QWAAS query that will use the drill through values from the model and return the transactions for the year and month combination.

My question is, when the user changes the drill through path, can i get QWAAS to dynamically update with the new year and month paramters?

If i can get this to refresh on change, then i do not have to bring in all transactions up front, i will be working with a much smaller dataset. This should improve performance and correct the overflow/trunc errors.

anthonyjones :uk: (BOB member since 2008-03-10)

2

Hi Anthony,

You can indeed set the Web Service Connector to refresh on change.

In the Properties panel of your web service connector, navigate to the Behavior tab.

Use the “Trigger Cell” to bind the update behavior of the connector to a cell in your spreadsheet.

Choose from “Trigger on any insert” or “Trigger on change only”.

You could set a default value in the cell and enable the “Refresh on Load” to load in a default dataset when opening your dashboard.

Using both year and month as input variables in your web service, you might want to consider changing the cell only when both a year and a month has been selected.

Alternatively you could include a “update” button in your dashboard.

I hope this helps!

stieper :denmark: (BOB member since 2008-10-11)

3

Hi Stieper

Thank you for your speedy response.

I shall try this and respond with my results.

anthonyjones :uk: (BOB member since 2008-03-10)

4

I know it has been a while in replying to this post, but i have incurred another problem. I have raised another post under the link below. if anyone could help i would be most grateful as this is now stopping my project from completing.

https://bobj-board.org/t/124590

:hb:

anthonyjones :uk: (BOB member since 2008-03-10)