on 09-16-2011 5:09 AM
Hi,
Is the Dynamic visibility behaviour that is available in xcelsius dashboard possible in WEBI 4.0?
I have 4 charts, 2 charts are based on measure expense and the other 2 charts are based on measure revenue. The user needs to be able to select either expense or revenue, and depending on which measure is selected, the 2 charts with the selected key figure should be displayed and the other 2 charts hidden. I have seen an option in the chart properties, to hide the chart based on a formula. Can anybody help me or give me some direction?
Thank you
Ann
Hi Ann,
Good news!
In BI4.0 you have the option to really hide something in WebI (similar to dynamic visibility).
That can be a cell, a table or chart.
You can hide when a certain formula is true (right mouse click, hide from the context menu).
In your case you can combine this with input controls to dynamically show or hide certain charts,
based on the value of the input control.
Create a new text variable with a fixed text, this should be the startup situation selection.
Create an input control with it and add as many variations as needed.
(A radio button would do nicely).
Hide the chart based on the selected text in the the text variable.
Good luck,
Marianne
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Solution in case of BOXI 3.x versions is some thing like this
create a parameter where user has the option to select values revenue or expense
create a dynamic variable like if userresponse("select measure") ="Expense" ; measure1 if(userresponse("select measure")="Revenue" ;measure2 ))
And use this measure in the charts.
But the limitation is both charts will be displayed with the same kind of data. You cannot show revenue in chart1 and expense in chart2
Hello again Ann,
You can actually create a 'dynamic measure'. You only need one chart that can display multiple measures, and have the user select which measure to show.
See this post for the instructions: http://blog.davidg.com.au/2011/07/dynamic-measures-in-webi-using-derived.html
OK, got 4.0 in front of me now.
1. Go to your input control and hover the mouse of the input control name.
2. Click the wrench icon.
3. Next to the List Of Values item, click the ellipsis.
4. In the box in the top left, type something.
5. Click the right arrow >
6. Click OK
Add as many as you like.
Then create a new variable that gets the value from that filter and returns either measure a or measure b based on the result.
Unfortunately, you can't get rid of the "All Values" item, but in your formula you can allow for this and return some default measure so your report doesn't return garbage.
I've added a new post for dynamic measures in Webi for BEx and MASA data sources, including dynamic formatting (although I can't get it working for chart labels).
http://blog.davidg.com.au/2011/09/dynamic-measures-in-webi-on-any-data.html
Hello Ann,
One workaround that I can think of is to use 'Alerter'. In your case, you have 4 charts, 2 charts are based on measure expense and the other 2 charts are based on measure revenue.
Override your first measure expense chart with the second measure expense chart and similarly override your first measure revenue chart with second.
So now only 2 charts are visible(one for measure expense and second for measure revenue ). Now use conditions on alerter such that if specific condition is true, then 1 chart is visible and second is hidden.
You can do this similar to what mentioned in below thread:
[http://bi.stieper.dk/hide-table-in-web-intelligence-webi-257/]
Regards,
Chinmay Athavale
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.