Search the Community
Showing results for tags 'report'.
Found 2 results
I have recently inherited a large number of Discoverer reports and I need to figure out the differences between them. Most likely many reports are similar with minor hard coded parameter differences. There are too many to manually review via the GUI. Is there a way to export the definition of the report so they can be compared? I do not have access to the reports/system yet, but I'm guessing Discoverer 10.1 or 11.1... used against an 11g db. I've been searching online and found a reference to saving the reports as a rex file and then comparing with an ascii comparison utility. I'm unfamiliar and can't find any information on saving rex files (except with regards to music). I would appreciate any suggestions. Due to the limited timing on this project, I'd like to hit the ground running. I tried searching for help on this website, MOSC and OracleFAQ, but no luck. If you know of any other places to search, I'd appreciate that info too. Thanks.
emolloy17 posted a topic in Oracle ForumI'm looking at this from a different angle. We are about to convert a LARGE number of Oracle Discoverer reports to OBIEE. I originally was looking for ways to compare the old Discoverer reports to see if I can find similar reports. Now I'm interested in finding out if there is a way to create a bunch of the OBIEE reports programatically (or at least by avoiding the graphical interface). It looks like the documentation I'm looking at is all GUI based... so I'm wondering if there is a way to take some SQL and generate a simple report. Then someone can go back into the GUI and "pretty it up" so it looks like the users want. If so, I could possibly parse out the information from a bunch of the output created by the workbook dump utility and at least get a skeleton report made quickly. Here's an example... The workbook dump utility is generating something like this: I'm guessing this becomes SQL that looks something like this: (not a "quote" but using to format) So, does anyone know if there is a way to take something like this SQL (or any other formatted info) and create an OBIEE report WITHOUT using the GUI? In the interest of attacking a bunch of these reports quickly, this would be really helpful. FYI - it looks like 3rd party tools may not be not allowed, so I'm not looking for purchased solutions at this time. Thanks! Note: We are using OBIEE 12