hi Jim, You can get them back using 'Admin View' (attached a screenshot) and additionally did you try removing 'BI Consumer' from the permissions? Give a try please and make sure there is enough backup of those objects to be on safer side. Thanks, Santosh

hi Jim, There would not be any impact as long as you are only using 'HCM' content. Instead of removing them, you can set the privileges to allow only 'Admins' to view and set to No Access/Deny for rest of the Userbase. You can also refer to this note 'https://support.oracle.com/epmos/faces/DocumentDisplay?id=2412231.1'…

Did you try using _xmode=2 and create the parameter (Supplier Name) within your data-model? You can enable the results for 'Supplier Name' populate thru a SQL-query or thru a fixed list of values. And with respect to output, open the report layout, click on 'View a list' and there you can choose an appropriate output…

hi Aswanth, You may want to give a try: Edit report -> Properties -> Formatting -> HTML Output -> there are few properties listed at https://docs.oracle.com/middleware/bi12214/bip/BIPRD/GUID-AD8B4E8B-B187-4A66-B6CC-82A382989CE0.htm#GUID-7838AB78-D868-4CF4-93DC-78183CD709FD. thanks, Santosh

and if you find any issues with document shared earlier, you can share a revised one for everyone's benefit :)

check these : https://cloudcustomerconnect.oracle.com/posts/d1596176c3 https://cloudcustomerconnect.oracle.com/posts/c07c085ea7

either way - do you know if this information captured anywhere? Unless, Oracle may restore from the catalog, etc..

Hi Maarten, I have been using notepad++ from a very long time and generally find it is good particularly keyboard short-cuts like Ctrl+q to comment a line (which is often required), Ctrl+L to delete a line, etc. I use http://www.dpriver.com/pp/sqlformat.htm to format my SQL at times. I am curious to learn more on this. I…

Hello Giuseppe, I am sure you would have installed a local database as well. You would need to provide your local database details in this section, basically a TNS entry. thanks, Santosh

hi Janko, I will wait to hear if there is an option to isolate these changes. But if you need to manage thru privileges (Administration -> Manage Privileges), it can be done easily. thanks, Santosh

Hi Stephanie, Can you please try? 1) create two conditions -> (a) Due Date is greater than current_date (b) Due Date is null 2) click on AND and change this to OR

hi Praveen, you can navigate to 'Administration' (on the top menu header), Manage Sessions and there you will find sessions for each execution. You can search the session log either by Report Name or User. It provides a very detailed session log which includes the physical SQL as well. thanks, Santosh

Yes. As I mentioned earlier, all features and functionalities of OBIEE are available within OTBI. I would suggest you to search for it - you will get umpteen results.

hi Vijay, I am afraid I dont have but can you search under 'Reporting Sharing Center' (https://cloudcustomerconnect.oracle.com/resources/dd487d65f8/summary)?

Hi Vijay, OTBI has all the functionality of regular OBIEE 11.1.1.9 version. So pivot is available too. Thanks, Santosh

hi Prudence, one option is to create multiple layouts to achieve the tab functionality and the other option is to use an iframe within a dashboard page, something like below: <iframe frameborder="0" MARGINWIDTH="0" MARGINHEIGHT="0" scrolling="no" width="100%" height="1200"…

Just to close it - looks like there is a limitation to use LAG function in child dataset.

any trial versions definitely takes long compared to the subscription ones. and sometimes it may not come through as well. also check your spam folder; usually it comes with 'Oracle Cloud <oraclecloudadmin_ww@oracle.com>'

Hi Saud, You may want to check all the responsibilities the user is associated with. For example, you want to hide 'customer dim' from User # 1 who has responsibility 'Sales Region EMEA'. You can explicitly grant it to this User. And if the same User # 1 has access to other responsibilities, the table in question will…

Hello, Last year, I have raised an SR to Oracle about connecting Oracle BICS to third-party cloud databases (like AWS, etc.). They confirmed that it is not available. https://support.oracle.com/epmos/faces/BugDisplay?id=23123698&_adf.ctrl-state=y1keme3et_9&_afrLoop=540911186896781 Do you have any documentation/links which…