Search the Community
Showing results for tags 'obiee'.
Found 2 results
I know my posts do not follow mainstream OBIEE usage, thus why I have issues finding the answers in online documentation. A quick background... I am part of a conversion team that is trying to figure out how to migrate users from Discoverer to OBIEE by doing most of the work for them. Some users will convert their own reports, but for the rest, we will be trying to convert numerous reports for numerous users and share them as needed to mimic their current Discoverer environment. The idea is that the users will log on to the OBIEE environment and find their reports converted and the necessary co-workers who had access to the reports before will have access in the new OBIEE environment. Problem 1: Converting the report for the user (not logged in as the user, but as a conversion team user) but having the original author own the report when we are done. I am hoping I can convert their report and then share it with them. Similar to how it works in Discoverer, I am hoping the user will then save the report to their own folder so they have the report owned by them (and I can delete my copy). Problem 2: I generally understand the various privileges in OBIEE (like BIConsumer, BIAuthor, etc), but I need to figure out how to implement the same sharing as it shows in Discoverer. I cannot log in as the user. So, is it possible to use the weblogic administration console to manage who the reports are shared with? What type of privileges will be required by the conversion team to setup these sharing relationships? I anticipate the conversion team member assigned the task of setting up the report sharing settings will be required to have the minimum amount of privileges to accomplish the tasks. Any thoughts on what is required? I am working through the following document: https://docs.oracle.com/cd/E14571_01/bi.1111/e10541/prescatadmin.htm#BIESG2904 It seems to be telling me as administrator I can do this. Can anyone confirm this? Thanks so much for the help.
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