HTML code not resetting Input Controls

[mhmohammed]

Everyone,

I'm trying to create this workaround suggested by Gustavo Stenio Sousa, in the comments section of this Webi idea. I think, the one step missing in the list is how and when to apply Input Control, which I did. The part where I'm stuck is, after clicking on Back to Panel button, the Input Control is not reset.

Would one of you experts in HTML/Java help me?

To make it easy for you, below is Gustavo's comment on that idea.

-------------------------

Dear friends, I found a workaround for the problem. In summary, I have included a table with the filtered data at the end of the document in the same tab as the report, but that table starts the document as hidden. When you click on any of the graphs, the table is displayed and the graphs are hidden.

Below is a short summary of how I did it:
1) Create graphs and configure them to align with relative position with respect to each other. (this step is important for the table to appear at the beginning of the document)
2) Create a detailed table at the end of the graphs and place it in line with the position relative to the last graph. (this step complements the previous one)
3) Use the graphics link only with the table
4) Create a variable to identify when a graph was clicked: Variable Check Filters Pos (ReportFilterSummary ("Report Name"); "Filters on Detailed List:") * Report Name should be replaced with the report name ** Detailed List should be replaced with the table name in the report
5) Configure the graphics to hide when: [Check Filters]> 0
6) Configure table to hide when: [Check Filters] = 0
7) To return to the graphics, just use the reset button on the input controls.
😎 From here it is optional but makes the report more usable, as it will create a button to return to the graphs and hide the table in the report itself.
8.1) Adjust CMC configuration to allow using Java Script codes: Applications> Web Intelligence> JavaScript
8.2) Include a text box in the report and configure it to: Hide when: [Check Filters] = 0 Read content as HTML
8.3) Insert the following text in the text box:
<input type = button value = 'Back to Panel' onclick = cleanFilters>

<script>
function cleanFilters () {
self.top.window [2] .window [0] .window [5] .iFormResetAllCB ()
}
</script>

8.4) End, now the graphs are linked to the detailed table and after creating there is a button to return to the graphs and hide the table. I don't know if this is the right place to post this, but I hope I helped.

--------------------End Gustavo's comment---------------------

Thanks,
Mahboob Mohammed

[mhmohammed]

Hi amit.kumar71,

Any thoughts on this?

Thanks,
Mahboob Mohammed

[mhmohammed]

Any Java or HTML experts here? Would you please help?

Thanks,
Mahboob Mohammed

[mhmohammed]

Hi Ayman,

If you look at this Idea I created, it was about Updating Intra Document Linking feature (in BI 4.2 SP7), as it can't filter data in the Target report (after we navigate to that tab from a different tab), like navigating from Summary tab to Detail tab in Webi (we do something similar using OpenDocument by Navigating from a Summary Report to a Detail Report (which is a different Webi report).

Using the workaround what we want to do is, to have a Summary Chart and Detail Table, so that when we click on a Bar/Column in Summary Chart, the chart should be hidden, and a Detail table with detail data and a Back to Panel button should appear. Then, when we click on Back to Panel button, it should bring back Summary Chart, and also that the Detail table & Back to Panel button should be hidden.

The step where that workaround is failing is, even after I click Back to Panel button, the Summary Chart doesn't appear with Element Linking filters cleared.

Thanks,
Mahboob Mohammed

[ayman_salem]

What actually needs to be achieved with this workaround? Can you share a screenshot?

[mhmohammed]

Hi Ayman,

Below is what the workaround is supposed to achieve:

1. In the beginning (original view) we've a Summary Chart with summary data,
2. When we click on a Column/Bar of a value from the Summary Chart, the chart will be hidden, and 2 blocks appear
3. 1st is the Detailed Table which has detail level data filtered for the value we click on Summary Chart, and 2nd is a button with text "Back to Panel"
4. Then, when we click on "Back to Panel", we should go back to the original view where we see only the Summary Chart.

The problem I'm having is, when I click "Back to Panel", I don't go back to the original view. Hope that explains my problem. Please help.

Thanks,
Mahboob Mohammed