Jump to content


  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About emolloy17

  • Rank
  1. Do you know how we can get access to view reports generated by other users? As a conversion/migration team, we need to have access to all reports that need to be converted. Is there an administrative method for getting access?
  2. So I has been confirmed through tests that the EUL_ACCESS_PRIVS table only identifies who the report is shared with. To continue our test, UserB saved the report as his own and shared it with User A and User C. Now when we run the report above it shows the following: WORKBOOK_NAME EU_USERNAME WORKBOOK_KEY ReportA UserB ReportA ReportA UserC ReportA ReportA UserA ReportA1 ReportA UserC ReportA1 This shows that the report can be saved with the same name, but the key shows that it is a different version. The original owners of the report do not appear in this query, but if we look in the EUL5_DOCUMENTS table, we see the 2 entries representing the owners of the reports ( ReportA UserA and ReportA UserB). Google is an amazing thing. I just searched for "desc EUL5_QPP_STATS" and found the following query from you...
  3. Thank you. This is very helpful and clear. If you could share the SQL, I'd appreciate it. We set up a test scenario. User A creates a report on Thursday and shares it with user B and user C. Both user B and user C view the report on Friday. The following query is run: SELECT USERS.EU_USERNAME , DOCUMENTS.DOC_NAME WORKBOOK_NAME , ACCESS_PRIVS.AP_UPDATED_DATE LAST_UPDATED , DOCUMENTS.DOC_DEVELOPER_KEY WORKBOOK_KEY , DOCUMENTS.DOC_DESCRIPTION WORKBOOK_DESCR FROM EUL5_ACCESS_PRIVS ACCESS_PRIVS ,EUL5_DOCUMENTS DOCUMENTS ,EUL5_EUL_USERS USERSWHERE DOCUMENTS.DOC_ID = ACCESS_PRIVS.GD_DOC_ID AND USERS.EU_ID = ACCESS_PRIVS.AP_EU_ID AND DOCUMENTS.DOC_CONTENT_TYPE = 'application/vnd.oracle-disco.wb' AND DOCUMENTS.DOC_NAME = '01_OBIE_test_tbj'ORDER BY USERS.EU_USERNAME, DOCUMENTS.DOC_NAME; The results return 2 rows. We only see the share with user B and user C on Thursday. (I don't have access to play around in the data yet, so I'm asking someone else to send me results.) This suggests that the EUL5_ACCESS_PRIVS table only identifies who the report was shared with... thus providing me a clear roadmap of who the reports have to be shared with in OBIEE. I'm wondering if I should send a query with an outer join so I can see the creator as well as the users the report is shared with. Then any entry without an "ACCESS_PRIVS.AP_UPDATED_DATE" value would be the originator and the others could be eliminated as "shared copies". If I was to just query the EUL_DOCUMENTS table for this one report, would I get 1 entry or 3? (I've just asked the DBA to query this one report in the EUL_DOCUMENTS table.) If it is just one entry, then I know all reports in EUL_DOCUMENTS identifies uniquely saved reports... aka, all the reports we need to convert. Sadly, I'm still just trying to figure out how to identify the scope of the project and how we will know when we have successfully completed it. My next question is whether there is a way to pull the SQL without having to click through the GUI to display it for each report individually. I know there are some queries that return SQL, but without documentation on the underlying tables, who knows what it's returning. Definitely not enough data to indicate it's the SQL for all reports. Thank you for your help!
  4. First, I should ask if my understanding is correct... I understand Discoverer users can generate a report and once they like the results they are getting, they can share it with other users so they don't have to write their own report. To keep them straight, I refer to the original report as the "base report" and the copies that were shared to other users as the "shared report". So, here are a few questions: 1) Can the user who receives the shared report change it? 2) Is the shared report a separate copy of the base report (or just a reference to the base report)? 3) If the base report is changed, will the shared report also change? 4) Is there a way to determine which reports are base reports and which ones are shared? Unrelated, is there a way for the DBA to access all the reports, by all users? I understand you can log in as a particular user and see their reports, but as a DBA, can you see all reports made by all users? Thanks for the help. Liz
  5. Oracle Discoverer - report definition comparison?

    I still don't have access, but someone sent me the output from the dump utility and the actual SQL from the report. He said he was able to use the Discoverer desktop tool to pull up the SQL, and he cut and pasted the contents so I could compare the dump with the actual SQL. It seems the workbook dump is just a wordy version of the SQL so it seems it would be easier to parse/compare the SQL. Plus, I understand there is a way to quickly create some simple/rough reports in OBIEE using the SQL from the Discoverer reports... so this is my current focus. I'm trying to get 500-1000 reports converted in 2-3 months so any automation is a good idea. The need is to just get the users operational, then we'll focus on creating a data warehouse and replacing their reports with ones that take advantage of the new DW and OBIEE bells and whistles. Do you know if there is a way to automate gathering the SQL for all the reports in Discoverer? Manually pulling up the SQL for each of these reports will be very time consuming. Is SQL for the reports stored in the database somewhere so I can just query it? Thanks so much for your help.
  6. Well, they're looking to transition the users into using OBIEE, with the hopes that most users will learn how to write their own reports and use all the wonderful new features. Only problem is, the mandate to turn off the old servers is looming and we'll have no way to keep the users operational. So, for now, we have to get the reports up and running so they can continue to function. I was asked to figure out how to get the reports converted "in bulk" to meet the deadline, and then they'll train the users and get them working on their new reports. Problem is, we know how that goes... old reports are not re-written (because they function and no one wants to reinvent the wheel). It's an ugly situation to be creating, but my job is to get them off Discoverer (converting 500-1000 reports in 2-3 months) and using OBIEE. I'm hoping the training will teach good programming practices (like not creating a new report every time because you hardcode the values.) It has been suggested "yes it is possible to bulk-create the XML definitions of the OBI "direct database request" analyses." Also, "As said before: by web services you can create analysis and inject the XML with your query for direct database request analysis. All you need is to define in the RPD physical database with connection pools containing the required username/password/host to point to your DB, the direct database request require the name of the connection pool to use when sending the contained SQL to a database (to know where to send it and using which credentials). So can definitely be automated quite nicely." Any other insight? I am new to the product so I have to learn what all of this means and how to do it. FYI - Phase 1 is to use the EUL to generate a simple RPD and convert the reports so we can shut down the old servers. Phase 2 is to create a Data Warehouse and re-write the reports to take advantage of this along with any new reports. I'm hopeful that they'll see that effort through. The timeframe is just too short to take on that endeavor. This is a fire fighting effort for now. Thanks!
  7. I'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
  8. Oracle Discoverer - report definition comparison?

    I will open an SR as soon as I am able. I have just switched contracts and I don't have a new Oracle Support Identifier yet. :-( update -- Apr 4, still no access :-(
  9. Oracle Discoverer - report definition comparison?

    Thank you. Yes, I am aware. This question is in reference to an effort to move reports from Discoverer to OBIEE because of the deprecation. Due to the environment, we can't use any COTS program to migrate them, so I'm hoping to find a way to bundle similar reports when converting them so we can minimize effort (a very large number of reports). I have a VERY short time to perform miracles... so I'm looking for suggestions. Last time I worked with this group (Y2K), they had many reports that were duplicated and certain values were hardcoded. So you could convert 5+ reports at once by either adding a runtime parameter or converting once and then duplicating for each hardcoded value. This new GUI reporting environment means I don't have a textual version of the report to compare. Thus, I'm looking for some way to get a text definition so I can gather stats on their similarities. Thanks.
  10. Oracle Discoverer - report definition comparison?

    I have cross posted this question. A commenter on another forum suggested I use the Discoverer workbook dump utility to get the EUL objects. Any one have any success with this? I'm waiting to gain access to try it out. Thanks!
  11. 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.
  12. SQL Developer slow to load some user's table lists

    Update: I was running version 4 of SQL Developer. Oracle support recommended that I install version 17.3.1 and retry. The times greatly improved. One of the table list expansions went from 40+ minutes to 4 minutes, another went from 6-8 minutes to 5 seconds. However, I still can't understand why it takes 4 minutes to expand when querying directly is instantaneous. Oracle support then recommended I make a parameter change: "Take a look at Describes Of Dictionary And Fixed Objects Very Slow Using SQL Developer Against 12c Database ( Doc ID 2147939.1 ) as I have had a few customers that completed this solution and it resolved their issue." This doc recommends setting optimizer_capture_sql_plan_baselines to FALSE in hopes of speeding up the query. Unfortunately, our parameter is already set to false. So, now they are waiting for my user to install the latest version and see what his testing reveals. I'm happy with the improvement, but I don't think they have a complete explanation/solution. If anything else comes of this, I'll be sure to update again.
  13. SQL Developer slow to load some user's table lists

    Thanks, makes sense... but seems so weird it only happens to some users and not others. I was hoping there may be something I wasn't thinking of. I'll check in with Oracle and update with the response.
  14. I hope I'm not repeating, I tried searching the forum for similar posts. I have SQL Developer version My client complained that when he logs in as a certain user and tries to expand the tables list from the connections navigation window, it takes 6-8 minutes to display the list. I confirmed the same problem. Once I expand the list, I can expand/collapse and it is instantaneous. If I disconnect and then reconnect, I have to wait the 6-8 minutes to expand again. However, if I log on as system, navigate down to "other users", find the user and then expand the tables list, it is almost instant. The user found the same was true if he selected another user to log on as and navigate to the same tables. Also, during the wait, it appears no other queries can be run. I tried running a few queries in the worksheet while I waited and they appeared to stack up and wait until the list loaded and then each of the queries I tried to run fired off one after the other. I also tried using the SQL window to query select table_name from all_tables where owner = 'xyz'; (where xyz is the username in question). The response is instantaneous (immediately after logging on and after expanding the list). The database version is Oracle on HP-UX. I'm not sure where to look for reasons for the issue. While the expand was running, I tried looking in "v$session_longops" without success. That makes sense to me because it should run quickly. Also, this same issue happened a few months ago with different user on their system. I am unaware how the issue was resolved... or if it just went away. Any ideas? Thanks so much.