Auto move to another Tab Container

other Xcelsius - Crystal Dashboard Design
1

I’ve got a dashboard built using a tab container. MTD, QTD, and YTD are my tabs.

Is it possible to have Xcelsius auto move to each tab after a set amount of time?

Matt Minyard :us: (BOB member since 2002-08-15)

2
  1. Use Panel containers. Pretty them up until they look like tabs. You can make buttons that looks like Tabs or D/L them. There are millions online. Panel containers can be controlled via Dynamic Visibility, while Tab panels (switching) cannot.

Option One:

  1. Get your DBA to make you a one row/one column table in the datawarehouse. The field in this table will have the current time.

  2. Get a query going (qaaWs ?) to pull the time from the table. This query will need auto refresh…say every 15 mintues. Its value will return to a cell in excel

  3. Use a function in excel to extract the minutes (or hours or seconds…whatever) from the returned time.

  4. Now you can make an IF statement that says something like ( IF minutes between 1 and 15 then 1, else if minutes between 16 and 30 then 2, etc ect )

  5. Set your MTD, QTD, YTD panels to look for that value (1,2…) and show the panel when appropriate.

OPTION 2.

the key here is to use a web service to get the time every few minutes. You cannot make excel do this by itself…so your model is goign to need to be connected to something. You can use a generated XML file (probably easiest) if you dont know how to interact with your data warehouse. Also some public webservers broadcast information like time with WSDL’s. Here is s simple link that shows what Im talking about:

http://www.altova.com/library/wsdl/wsdl_documentation.html#Link03AB6E08

All the config information you need for your Xcelsius Web Service connection is there. Thats a public server, so use at your own risk. There are millions more links if you look online.

Option 3.

use SWF variables. This option is overkill for something like that, but a preprogrammed SWF that retrieves the time from whereever could be embedded and programmed to pass a variable, like the current time back to your dashboard. Using Flash variables is a pain however.

Cairmor :us: (BOB member since 2008-06-05)

3

Thanks Cairmor…

Matt Minyard :us: (BOB member since 2002-08-15)

4

Matt,

You probably can do this with the history component and setting it to change on an interval. So after every 5 seconds take a value and put it into a destination cell. Depending on that cell you can show one of the three tabs using the selected item binder on the behavior tab of the tab container.

You will have to figure out the logic on how to increment the values so that the container knows to show tab 1, 2 or 3.

Hopefully this helps you in the right direction

-Mike

mallison :us: (BOB member since 2008-07-30)

5

Matt,

Here is an early b-day/ x-mas present. It is all done in xcelsius. No need for QaaWS or Flash Vars and it allows you to use your tab set.

Best,
Mike
movingTabSet.zip (8.0 KB)

mallison :us: (BOB member since 2008-07-30)

6

Nice work Mike

cdavies :uk: (BOB member since 2005-01-28)

7

Thanks everyone. :mrgreen:

Matt Minyard :us: (BOB member since 2002-08-15)

8

How about throwing in a simple play selector and set it to Auto Play?

kalyanverma (BOB member since 2007-04-24)