Hi
Created a parent and child dashboard.
In child dashboard has a flash variables that are fetching the parameters which are selected in the parent dashboard.
I place a URL Button in the Child dashboard so as to go back to parent dashboard.So when i click the button in the Child one it basically opening the parent dashboard which is like resetting, is it possible to have a parent dashboard values selected f previous one.
I’ve never tried it, but the only way I think that would be possible would be to pass the parameters from the child dashboard back to the Parent dashboard.
Basically, both dashboards would have to have flash parameters.
I tried by creating the flash variable in the parent dashboard for which will capture the parameters of the child dashboard but it not working.
This is because of parent dashboard has a refresh on load and flash variables
so Xcelsius is not so intelligent when to take the flash variables values and when to take parameters values from the QAWS.
In heritance is possible from the parent to child but not from child to parent…
Here the question is when i click the URL button with the parameters as “US” and “NY” from the parent ,child dashboard opens up and again i place the URL button in the child dashboard so go back to my parent dashboard with the same parameters what was selected previously(US and NY in the Combo boxes selected) whole thing is Caching to be maintain in the parent dashboard
Data loader does the same thing as it like of flash variables.
It’s possible to do with flash variables. Check out my recent thread here. I started with parent–>child, but then I decide I wanted them both at the same level, so now I have 4 dashboards all linked. You can load any one of them as the parent and move across to any of the other three as child and back again.
I did it by having a flash variable in each dashboard. The user can select a location in whichever dashboard he goes into - that location is passed into the child and back to the parent again (or any other of the linked dashboards. If you want to be able to change value of the flash variable in the child and pass the change back to the parent, you need two trigger cells (one for first-pass value one for the changed value). You also need two connections (one to refresh-on-load and take the parent variable and one to refresh-on-trigger to get any new data)
It works beautifully! Kind of hard to explain but it wasn’t that hard to achieve once I’d worked out how to pass the flash initially.
Update - as I’ve just fixed a bug, it’s fresh in my mind…
Set a cell (say D1) to hold a flash variable. Create a flash connection to put a flash variable (mine is called Location) into D1. This will be blank when this dashboard is the parent and populated when this dashboard is the child.
Set a cell (say D2) to be the on-load trigger cell. Put an IF statement in here:
if(isblank(D1),default location,D1)
where default location is the top of hierarchy - location value to use if this is the first dashboard opened and no user selection has been made. Create a connection to get your data with a load-on-open only, sending the data in D2 to the query.
Set a cell (say D3) to be the on-refresh trigger cell. Bind the results of your on-screen location selection to D3 (for when the user changes the location). Create a connection to get your data with a load-on-refresh only, sending the data in D3 to the query.
Set the default value of your on-screen location = D1, so your dropdown is auto-populated when this dashboard is a child. This will also ensure that your trigger cell D3 always holds the current location selected, even if the user makes no change on load.
Pass the value of D3 out of the dashbaord (with ?Location=D3 on the end of the url) to be the input flash for the next dashboard.
This works for me and means that I can have multiple dashboards at the same level and pass the same flash variable between them in any order. The user can change the location in any dashboard it will pass through any other dashboard until it’s changed again.
I would if I could - but unfortunately I can’t. What I have is a complex set of XLFs and ASPX files hosting my queries. There isn’t really any way I can split it out into anything useable on its own. To post anything here, I’d have to rebuild from scratch and sanitise all the data and I’m afraid I don’t have the time available to do that.
[quote:eae0173bfe=“Syed.Rizwan”]Hi
Created a parent and child dashboard.
In child dashboard has a flash variables that are fetching the parameters which are selected in the parent dashboard.
I place a URL Button in the Child dashboard so as to go back to parent dashboard.So when i click the button in the Child one it basically opening the parent dashboard which is like resetting, is it possible to have a parent dashboard values selected f previous one.
Please help me out
thanks !!
[/quote]
I’m working on something similar but I could give you a suggestion. I don’t know if your child and parent dashboard dimensions (length width) are locked but if you put the back button in the parent dashboard, that would make life much more easy. you’ll only have to leave a column on the left to expose the parent dashboard and the child dashboard is 100px shorter in width than the parent.
Sorry. I’m not a consultant, I’m a public sector employee! I help out as much as I can during my lunch break and when I’m waiting for queries etc to run, but that’s as much as I can get away with here!
(BOB member since 2010-07-08)
(BOB member since 2005-03-01)
(BOB member since 2010-10-28)