Still working out the kinks transitioning to 8.0...

In the previous application iteration we would develop dashboard pages with the HTML Composer tool, which would allow us to create parameter controls that would link to multiple procedures, i.e. one drop-down box control could pass a parameter to multiple charts/reports on a single dashboard page.

Does anyone know how to accomplish this using the new BI Portal frames? Are we stuck creating HTML pages and including these as one large frame in a Portal page?

Thanks for any help/advice you can provide.

This message has been edited. Last edited by: <Kathryn Henning>,

Hi,
I think you'll find what you need in the Virtual User Forum that is scheduled for Dec 10.
Virtual User forums

Magically Filter Reports in the New BI Portal
Presented by Matthew Lerner, Information Builders

I think Matthew also did this presentation at Summit 2013, so alternatively you may be able to download the presentation/lab from back then.

The steps needed are outlined in Chapter 10. Filtering Reports Using An HTML Composer Form of the Business Intelligence Portal manual.

Cheers

Stuart

quote:

Originally posted by StuBouyer:
The steps needed are outlined in Chapter 10. Filtering Reports Using An HTML Composer Form of the Business Intelligence Portal manual.

Cheers

Stuart

This is exactly what I needed! Thank you very much for your help Stuart.

Did you get this to work. I am trying to use this technique. It is refreshing the forms, but doesn't seem to be passing the parameters to the procedures. My parameters have the same name. Do we need to do something else with the fex?

quote:

Originally posted by DLR:
Did you get this to work. I am trying to use this technique. It is refreshing the forms, but doesn't seem to be passing the parameters to the procedures. My parameters have the same name. Do we need to do something else with the fex?

I was able to get this approach to work after some iteration...

What ultimately worked: I included one of the actual report procedures into the HTML Composer page in order to force the parameter control to populate. I then removed the report from the HTM file, and added in the javascript to refresh the reports. Finally, I added the HTM file and all corresponding report procedures into the Portal page and hit paydirt.

The key seemed to be using one of the report procedures to "build" the parameter control, rather than attempting to build the control from scratch.

Thanks! I will try that!

Ok, I created an HTML page with the composer. Added a report. Changed the text boxes to listboxes so I could dynamically populate. removed the report. Added the javascript for refresh. Added it to the portal, plus a couple of panels with reports. My 'run' button still wants to run the orignal report. What am I missing?

Thanks!!

Remove the hyperlink from your run button...

When I remove the hyperlink from the run button, it removes the parameters(not the list boxes). When I add them back it doesn't work.

This message has been edited. Last edited by: DLR,

I got it to work! Of course it was something simple. When my parameters were removed I had to create them and bind them to the listbox again. Well I was binding them in the wrong direction. Instead of dragging listbox to parameter I was dragging parameter to listbox.

Thank you so much for your help!!