I am working on xcelsius dashboard (Xi 4.0) and I have a requirement to call second tab from first tab drill. First tab I have Sales by USA data and second tab I have Sales by state data. If I click USA from first tab then second tab will display with USA state only. any idea? how to resolve this requirement?
Philip (BOB member since 2006-03-02)
Still I am waiting for your thoughts on this solution…
Philip (BOB member since 2006-03-02)
Philip,
This topic has been discussed numerous time on this thread. Change your search criterion, what your looking for is called passing parameters using opendoc links for Xclesius to Xcelsius.
katullus 
(BOB member since 2009-08-21)
No I am not using any opendoc here. I am not calling any webi report. it is within Xcelisius tab.
Philip (BOB member since 2006-03-02)
I understand that, opendoc in not just for webi, you will need opendoc link to pass data from Sales by USA to Sales by States etc between your xcelsius files (unless you overload ONE dashboard with too much static binding). Like I said, there are plenty of topics already on here discussing how to do that.
katullus (BOB member since 2009-08-21)
Or use flash. I pass flash variables between different dashboards with flash connection.
Or if you want to stay within the same dashboard - just send the drill results to a range of cells and set the display of the drilled component accordingly.
Debbie
Debbie 
(BOB member since 2005-03-01)
Hi Debbie,
yes I wat to stick with same dashboard.
as you said “Or if you want to stay within the same dashboard - just send the drill results to a range of cells and set the display of the drilled component accordingly.”
How to do this?
See attached file for sample tabs. There are three tabs, Country, State and City. If I click USA value from bar chart, It supposed to be land in ‘State’ tab and displaying data only for USA and so on.
Philip (BOB member since 2006-03-02)
The whole point of a tab is that it involves user action. It’s easy enough to make whatever you put on the second tab reflect the user selection on the first tab, but I don’t know any way to make the product automatically change tabs.
It’d be more normal to select country, state and city via dropdowns across the top pf the screen and then have the graph automatically change. Otherwise the user has to do more work to change options by clicking a tab and re-selecting.
If you really want to do this, you’d have to create “dummy” tabs by maybe using buttons and controlling visibilty of components according to whether buttons are pushed in certain sequences.
Debbie
Debbie (BOB member since 2005-03-01)
We did something very like that in our dashboard: http://www.gsa.gov/portal/category/103435
The “tabs” are actually push buttons. If you click in the lists below the graphs, they also take you to the “detail” tabs with the item you clicked on already selected.
The trick, for us, was to have several cells that represented a flag for each tab and the necessary values for the drop-down filters. Clicking a push button would overwrite the target cells with the flags for the associated tab and reset the filters to default values (in our clase, blank). Clicking on an item in the list would use the Position in the list to set the flag for the tab, and the Value of the item to set the filters.
Lugh (BOB member since 2009-07-16)
Thank you Lugh. This is the one what I am looking for. If you have a sample file that will be great…
Philip (BOB member since 2006-03-02)
Hi Lugh,
I am waiting for your sample file if you have any… Thank you…
Philip (BOB member since 2006-03-02)
Hi BO Gurus,
Please help me on this… I have huge problem now… need to delivered ASAP…
Philip (BOB member since 2006-03-02)
I doubt anybody has any sample files they can give you that aren’t subject to commercial confidentiality. Designing dashbaords is often a long and complex process.
What have you actually tried? Lugh has suggested you use a push button component to control visibility and lay out your dashboard so it “resembles” a tab. There’s even an example on line for you to go and study. Did you give this a go? What problems did you encounter? Come back with what you have tried and what worked/didn’t work and people will help you solve problems.
Debbie
Debbie (BOB member since 2005-03-01)
Push buttons are one way of doing it, or you can use a Label Based Menu and set its ‘Selected Item’ property when the user clicks an item in the first tab to ‘jump’ to the second tab.
It’s all about the logic and the process flow, and each dashboard is different. As Debbie says, what have you tried?
philip.zip (6.0 KB)
cdavies (BOB member since 2005-01-28)
Thank you cdavies for your sample file. Let me try this and will update you guys.
Philip (BOB member since 2006-03-02)