I am writing a blog on the Main Differences between the HTML query panel (web) and the Java query panel (Advanced) in Web Intelligence. I hope this blog post might help. Request to rate and comment on this blog.
The Java Report Panel has the following that HTML Report Panel does not:
At the query level:
•Database Rank (Query Rank)
•Combined Queries (Union, Intersect, Minus)
•Edit and Save SQL, with the HTML Report Panel you can only view.
•Customize the Scope of Analysis
•Purge the data from the micro cube before saving
At the Report level:
•Rank is possible (Workaround for HTML: Use the formula language to add a # rank e.g. =Rank(measure; (dimensions); [TOP|BOTTOM];(reset_dimensions)]))
•Create alerter (in HTML interactive you can view and turn on/off Alerters that have been created by others using the Java report panel). Workaround: Java Report Panel uses variables as input to trigger Alerters. Interactive View users can edit variables that change what the Alerters display.
•Print directly via a printer driver in stead of converting to PDF first.
The HTML Report Panel has the following features that the Java Report Panel does not:
•Left-hand “Context Panel”
•Document and Data Summary
•Document Structure and Filters – Java Report Panel lists filters within the Report Map, but doesn’t have the same User Interface
•User prompt input panel enables on report modification of the filters – In Java Report Panel user “refreshes” to change prompts.
•Edit in-place of cells (Java Report Panel uses formula tool bar only)
•Multiple levels of undo/redo (Java Report Panel has one undo)
The best Web Intelligence experience has always required Java in the web browser and BI 4.0 is no exception.
HTML is (web) and Java-based is(Rich Internet Application)
The web version continues to evolve but is always behind its more powerful Java-based relative..
You can perform numerous actions on documents with InfoView/Interactive without having to actually open Webi and edit the document in the Java Report Panel itself.
You can modify reports using HTML with the Web Viewer in Design mode, but it is equivalent to the Interactive Viewer in XI 3 and not a true (fully functional) report panel.
Here some more differences between Java and dhtml:
In BI 4.0, the following features are currently exclusive to the Java-based Rich Internet Application:
•Query support for BEx and Analysis Views
•Custom Cascading Style Sheets
•Custom number formats
•Many usability features in the Java-based User Interface, including Data View
• Edit or create BEx data provider
• BI Web Services
• Data Tab
• Create conditional formatting (aka alerters)
• Change Data provider
• Create report on analysis view