Jump to content


  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About emolloy17

  • Rank
  1. emolloy17

    select Long Raw??

    Well, I think I've just received access to load some more software... but in the meantime I learned a valuable little detail about Toad. For those interested, if you query a table and it returns (BLOB) as the result, double click on this. It will pop up a little window that allows you to convert the data to HEX and Text and either save the data to a file or open it in a viewer. I did both, but opening it in the viewer made it much easier to read through (only about 20 characters per line). I was able to verify the data that I was looking for is embedded in this value. Thanks!! (I'll try the code once I get SQL*Plus installed too, but this keeps me moving)
  2. emolloy17

    select Long Raw??

    Sounds good. I can't just download software and install it like I would on my laptop. I have to coordinate getting the files from the internal network, etc. It'll be a couple days to get access and get it installed. I'll check back. Thanks!
  3. emolloy17

    select Long Raw??

    Tried F5 and got same numeric or value error at the "Loop" command.
  4. emolloy17

    select Long Raw??

    Ok. I will respond when I am able to run it. I have to coordinate getting SQL*Plus installed on my computer. I just have Toad and the OBIEE client installed so far. Hopefully it won't take to long to coordinate. Thanks.
  5. emolloy17

    select Long Raw??

    Thanks for the advice. Strange though... it gives me the same error. I double checked the table description... doc_document is listed as LONG RAW. I am running this from and editor in Toad. I cannot execute the statement "set long 32767" (gives an ORA-00922: missing or invalid option). Can you explain what this is for? I omitted it from my executions thinking it was part of the create/insert. Thanks
  6. emolloy17

    select Long Raw??

    Looks great, but I get an error. My code is: and the error I get is: Error at line 7 Ora-06502: PL/SQL: numeric or value error Ora-06502: at line 7 Line 7 is the loop statement. Thoughts? Thanks!
  7. emolloy17

    select Long Raw??

    Hello, I am trying to see what is in a column of type LONG RAW. Is it possible? I have tried a number of conversion options and substrings, etc... but I just keep getting errors like illegal use of LONG datatype. The database is either 11g or 12c, I'm not sure. I am trying to find a specific string of characters and I am wondering if it could be embedded in this datatype. Thanks
  8. I am required to use OBIEE. This is the tool defined for this project. So, I have to figure out how to accomplish this using OBIEE.
  9. 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.
  10. 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?
  11. 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...
  12. 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!
  13. 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
  14. emolloy17

    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.
  15. 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!