on 09-22-2014 5:26 PM
Hi Experts,
The problem is if I select the box in the heat map, it will take me to a webi report then if I come back to the dashboard and change the combo box. The selection is not deselected, As the selection is still there it selects the value in the changed heat map there by automatically triggering the URL and redirecting to Webi Report automatically.
Can any one Please help me to resolve this,i really would appreciate your help.
Thanks,
Prasad
Hi,
I suggest to do a work-around. Set the selection of your Heatmap in a cel. And use URL button to jump to your webi report. Note: do not set trigger by datachange!
Grtz
Koen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks you for your Prompt Response.
actuall my issue not able to pass the parameter to webi
my issue is i'm able to pass but when i change any value from drop down corresponding to that selction the heat map will chnage and the value will pass and webi report will trigger automatically
because of the previous selction in the heat map.
i have to stop that
can you please see the previous discussion,it will help understand the exact issue
Thanks,
Prasad
This is a typical issue when the xcelsius components do not have auto-deselect property.
Try doing this work-around. I have implemented it successfully in one of the previous projects.
Identify one particular destination cell (lets call this cell DEST_CELL here onwards) that is triggering the particular report to open automatically. Now, take a new combo box and use it to insert a blank value in the DEST_CELL everytime DEST_CELL changes its value. Now write a formula in some other cell(lets call is FLAG_CELL) that gives you a "1" when DEST_CELL is not blank and gives you "0" when DEST_CELL is blank. Use this FLAG_CELL to fire the URL. Do not fire URL on change event, fire it when FLAG_CELL is "1".
Hope this helps you. Do let me know if you need any more/other help.
Thanks,
Prasanna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
sorry for late response,i already know this solution and implemented.
one more thing i have to mention here.whenever i change any selection from the combox at that time query is also refreshing for the below heat map,so once combobox place blank cell to destination cell stiil that query refreshing,once refresh completed the selected value placed into the destination Cell(means its replacing blank cell with selected value after refresh complete for that seelction in combo box).
to avoid this i put dynamic visibility for that combobx,like this should enable once query refresh completed but no use
Thanks,
Prasad
What map have you used here ?
How are you passing the values to the webi report ?
If possible please attach the xlf file in txt format to check the flow ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.