cancel
Showing results for 
Search instead for 
Did you mean: 

Dynamic visibility behaviour in WEBI charts

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

MariannevL
Advisor
Advisor
0 Kudos

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

Former Member
0 Kudos

Thank you...I was able to create the control...How can I specify more than one value in my input control box.

Ex. one readiobutton for "revenue" and the other for "Expense".

How can I specify in the variable more than one fixed text?

Thank you.

Ann

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Marianne,

How can I specify more than one value in my input control box? Example one radiobutton for "revenue" and the other for "Expense". in order to acheive this i am guessing that i need to maintain the variable with fixed text 'expense' & 'revenue'. Please advice how??

Thank you.

Ann

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi David, my WEBI source is BEx. As per your blog, the solution is not applicable to BEx sources.

Pls advice.

Thanks

Ann

Former Member
0 Kudos

Oh,

In that case, your solution would be part of that post, and part of what Marianne is saying.

when you create your input control, you have the opportunity to select which items to show as radio buttons, and here you can also add in new items (you could in 3.1, not sure about 4.0 sorry).

Former Member
0 Kudos

David, How do you add new items to an input control in 3.1? I can try the same in 4.0.

Ann

Former Member
0 Kudos

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.

MariannevL
Advisor
0 Kudos

Sorry I haven't been on this weekend....

Just to confirm, Input Controls are stilll the same in BI40.

So wrench item, radio button, list of values, click on ...

Type values and add them to the list. The all values is also still there as a gift

Good luck,

Marianne

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi David,

I followed your blog post on this with a OLAP data source, but I seem to be getting string values with the measure names in the Selected Measure rather than the values for the measure itself. I am using BO 4.0 SP05. Have you run into this problem?

Thanks,

Aditya

Former Member
0 Kudos

Nevermind that - I fixed it.

Answers (1)

Answers (1)

Former Member
0 Kudos

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