Multiple charts based on sheet - BI Beans(Archived)

Can I create a BI Beans application where ad-hoc users can create multiple charts based on a BI Bean sheet and print multiple sheets and charts in one page?.

I would also like to know if there is a way to be able to print multiple presentations at one time. We are using iuXML pages but the <printOptionsDef> only allows one printerFriendlyViewId attribute.
- Charley 

well if you go with the a javaclient:yes and easily
it depends which type of mdi you are using, swing has the concept of a jdesktoppane and a jinternalframe, which do the trick
custom printing as you have in mind is possible as well: look up the various XYZprinter docs:ie graphprinter,crosstabprinter


QIQ template or dashboard from scratch?

I need to develop a dashboard with Interactive Reporting that controls several queries and many reports to be printed out. The dashboard will be published in the iHTML workspace and give the user the oportunities to control several predefined limits in the queries like: datepicker, customer listbox, timezone and export formats. From what I saw so far, all the included (QIQ-based) templates concentrate on quickfilters, pivoting, charts and setting userdefined filters on results and not so much on controlling queries themselves or printing report sections.
Would you recomend starting from a QIQ-Template anyway and build own functionalities on top of it, or start the dashboard from scratch witch custom code for everything?
The thing is, I've only seen complex dashboards based on QIQ-Templates which more or less look the same. All other dashboards are merely basic and show only single functions, nothing to really evaluate the pontentials of the tool.
best regards,

"simple query builder for end users" or Discoverer emulation

Is there any solution developed by someone which creates metadata layer (similar to End User Layer in Discoverer) and allows
- developers: to add datasource (query) and its fields with attributed (this field is used for grouping, that field can be summarized,..)
- users: to select several/all fields from the datasource, assign "group by/sum/avg/count" behaviour to them and get results of this "visually built" reports? 
Did you check the Interactive Reports in APEX - ?
It depends on how complex your reports need to be.
For us, the new Interactive Reports covers the bulk of basic reporting needs by users. If you have not run across it yet, check out:
It will give you a quick overview. I ran a demo just the other day that I came across that gave a good visual overview of the capabilities of Interactive Reports (IRR), but I can't find it. The above link will give you a very good overview though.
Now, as to having multiple IRRs on one page, see: Multiple interactive reports on one page?
The recommendation by Vojin appears to be the simplest way to provide a mechanism for users to select from different data extractions for reporting. Depending on your needs you could come up with yet another's up to you. The flexibility and power is there.
Have fun!
HTH, Thomas 
In thinking about my reply (and after seeing Arie's), I wanted to mention that the reason we pointed out the Interactive Report feature of APEX is that it will give you the ability to present a front-end that has features similar to Discoverer, but in an easier to comprehend format.
The reason I pointed out the forum posting regarding having several Interactive Report regions on one page is so that you will be aware that there is a way to present several IRRs on one page, in a fashion that mimics being able to select a view in Discoverer. How you present the option to select from the different IRRs is up to you, and how you feel would be best to your users.
Again, have fun, Thomas 
Thanks a lot, I know that there is Interactive Report option, but:
1) I have a table with thousands of orders per month
Is Interactive Report able to show me totals (count and sum) for example by month?
It seems to me that if I don't I change report's query all I can do is add totals and see ALL DETAILs (thousands of rows with every single order) above the totals, but I do not need these details...
2) Interactive Report is not able to get PL/SQL generated query as its rowsorce, and I need to use PL/SQL to prepare Crosstab / Pivot Report,
see this topic with my really working Crosstab / Pivot Report example
Really working Crosstab / Pivot Report example

Drill Down Reports in Oracle Application 11i

Hi All,
Any one have any experience of creating a drill down report in oracle application. If yes please share with me its urgent..
Hi Saquib,
there are different ways to create drill down reporting, depends on which technology you want to use.
For example you can create drill-down worksheets in Discoverer, or you could use BI Publisher. Or even develop your own Forms. But this all depends on the technical requirements that you have. Are there any preferred things that you want to use?
My requirement is to develop a drill down report on oracle developer 6i for oracle applications.
Hi Saquib,
so it seems you want to do that with Oracle Forms, which is part of the developer suite. There is a hierarchical tree element available in 6i, maybe this one is helpful. There are numerous guides available in the net, just search for oracle forms and hierarchical tree.
If the levels you want to drill-up & down are fixed, then you could also use several data blocks for each level, and depending on which value you select in one block, then other blocks for the other levels automatically update.
best regards,
Hi David,
I want to do this by Oracle Report Developer 6i not by forms....
ah ok, now the situation gets clearer ;)
Normally I would say that drill-down requires some kind of interactivity, so I am not sure if reports is the best way for this, because the functionality of reports is:
enter parameters > run > view output. But for drill-down you need some more functionality: select a column/value where you want to drill-in or out, have some kind of hierarchy to select the "drill-level"... I don't think that this is foreseen in Reports 6i. So I would try maybe two different ways:
1. design the report in a way that the users can select the drill-level (or level of detail) as a report parameter. For example you create a parameter "Detail Level" with possible values "Summary", "Detailed Rows". Based on the parameter value chosen the report returns different output. This keeps you of course limited to a certain, fixed set of drill-levels, but I think this is ok in most of the cases.
2. Another option could be to create several different reports, for example one "Summary" report and one "detailed" report, and in the summary report you could include links (dynamic URLs) to the detailed report, and when the user clicks on a certain value in the Summary report, then the detailed report is started for that specific value. However this is a bit more complex, I'd go for the first option.
But to get real drill-down functionality you should consider using Discoverer or BI Publisher technology, those are perfect for such kind of reports.
kind regards,

BI Publisher V/S Oracle Reports

Need some information on BI Publisher.
1. Which is easier with respect to designing the report BI/XML Publisher or reports 10g?
2. Any feature which is available in Reports 10g is not available in BI Publisher?
3. Is it possible to create drill down reports using BI Publisher?
Thanks in advance,
1. Depends
2. Yes
3. Yes
Complex questions with lots of details behind the answers. Start here...
...and look at the intro and demo files, then decide for yourself. If you make wizard-based Oracle Reports, that is comparable to simple BIP reports. Each can get much more complicated, and quickly at that. 
1. Where can I find the example for drill-down reports in XMLP?
2. Consider a complex report (say Invoice Printing). Which one is preferrable for developing this report - XMLP or Oracle Report and Why?
Thanks in advance,
Preferable how? Depends on the report developer's experience. If invoice printing works fine now in Reports, what makes it worth migrating those to BIP (or XML Pub if in EBS)? If starting from scratch, BIP is much easier to learn and start off with, but it some limitations on how much data it can crunch. But it has lots of other advantages related to scheduling and bursting.
Drill-down reports - add hyperlinks to a report page and call up other reports. 
Thanks again.
I was referring to developing the report from scratch.
For drill-down reports, what does the hyperlink refer to? Will it be the RTF template? If so, how will it fetch the data?
All of the HTML reports (most PDF ones too) can be accessed via a URL in the form of:
See page 4-34 in Oracle Business Intelligence Publisher Report Designer's Guide ( 
2. Any feature which is available in Reports 10g is not available in BI Publisher?Yeah: an usable design tool! I'm evaluating BI Pub and I must admit, it's a nightmare! First it looks easy when you see these little simple one page table demos. But when you try to build your own reports from scratch it's a horror! You have put tiny little xsl fragments into your Word-RTF-document and this leads to a trial and errorr game. For me, an Oracle Reports professional, this product is a joke! I don't want to know, what happens, when you generate reports over 1000 pages, for Oracle Reports no problem, but for Bipub?
My last problem: You have a Table Wizard in your Bipub-Plugin. This Wizard should generate a table with grouping columns. Works fine, when you put your grouping column on top of the table (the reason why you can see this in all these nice demos). But when you want to have your grouping column left to the others, the wizard generates a table in the table and the heading of the other cols on the level of the grouping col. Absolutely unusable. And it's not easy to bring this in a good looking form.
MS Word is not a report design tool, never! It's good for mail-merging, but not for more. Ok, you can code your whole report with xsl! Do you really want this?
In my opinion there is no reason to go from Oracle Reports to BI Publisher, unless you want to do mail merging.
And I'm not alone with my opinion:

Multiple Report Layouts for a Single Report Query

is it possible to associate, at runtime, a different report layout to a report query? I'm trying to apply different template translations to a single query so there may be a better way of doing this.
For standard reports I would suggest that you use a View as the report source and then create multiple reports on one page based on the single view. Each report can then have a different template with a conditional display.
Is this for standard reports, Interactive Reports or Report Downloads?
this is for report downloads. I was hoping not to have to replicate the report query for each transalation. If I have 10 queries and, 10 translations for each, you can see how this quickly gets unwieldly.
I've worked out an untidy way of solving my problem.
Create your own version of wwv_flow_report_layouts i.e. my_report_layouts but allow multiple instances of the id, or better still add a column shared_query_name. Probably best to use a name as the id's change if you create a new version of the layout.
Load your report layouts to apex and ensure that theyall use the same naming convention but have implicit language types i.e template_name_en, template_name_it etc.
Use these in a select list or use some other method to determine the users browser language depending on your implementation to idenmtify which report layout you should associate with a print action.
Now comes the horrible bit. Just prior to printing, update wwv_flow_shared_queries and set the report_layout_id to the selected, or determined, template id.
If anyone has any better suggestions...