Search the Community
Showing results for tags 'obiee'.
Found 1 result
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