You need to first install a database and then create a schema/user into it. You can call it DEV_BIPLATFORM. Then you need to specify this schema i.e DEV_BIPLATFORM and it's password in this screen.

What is the purpose of this installation? If you want to install for learning/training purpose, I would advise you to use Oracle Pre-Built Developer Virtual Machine for OBIEE. These virtual box images comes with entire OBIEE suite pre-installed and configured along with lots of sample data and reports, analysis,…

You can also give a try to LOGICAL SQL if your requirement is complex. It supports NOT EXISTS clause. Refer to blog: https://oraclebizint.wordpress.com/2009/05/07/oracle-bi-ee-101341-understanding-logical-sql-part-1/ Here is an old reference: https://docs.oracle.com/cd/E14571_01/bi.1111/e10544/appasql.htm#BIEUG426

To get this document, please follow steps below: * Login to support.oracle.com. * In upper-right corner, enter 2085767.1 in the search box and press on magnifying glass icon next to it. It will open the document for you.

It is not part of OBIEE standard functionality (should have been though). Please refer to support document 2085767.1. Depending on the scenario there might be a solution (with development efforts involved). What exactly is the requirement?

Is it a BI Publisher report or an Analysis? What is the file type of output (PDF, Excel etc.)?

Can you try following and see if this works for you: * Click on the gear icon next to column name. * Select Column Properties. * Go to Data Format tab. * Select Override Default Data Format. * Select Custom as value of Treat Number As list of values. * Enter #,##0;-#,##0;0 as custom numeric format.

I hope someone from Oracle Analytics team answer this question. However, In the meanwhile, I can tell you what I know. I believe you should go for Analytics Cloud ( https://cloud.oracle.com/en_US/oac ). This is the best product, in terms of capabilities, that you may go for. If I remember correctly, it will provide you…

I am not sure if I understood your question correctly. I believe you want to pick all records modified since 1st of last month. Is that correct? You should be able to do the same. Here is the filter I applied: "- Header Details"."Journal Creation Date" >= TIMESTAMPADD(SQL_TSI_MONTH, -1, TIMESTAMPADD( SQL_TSI_DAY ,…

Hi, Please select my answer as the best answer to help close this thread.

* Click on View Properties [xyz] icon on graph view. * Click on Titles and Labels * Click on icon next to Data Markers * Select Display Option tab in Format:Data Labels pop-up window and select Always as value for Show Data Labels Please refer to attached screenshot.

Can you add a screenshot to start with?

BI Publisher Bursting feels tricky in the starting. Following are some useful resources: https://www.youtube.com/watch?v=dvSrZBuhAZ4 https://docs.oracle.com/cd/E21764_01/bi.1111/e18862/T527073T555155.htm http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi//bip/advancedbip/advancedbip.htm#t6…

Hi Ruth, I believe the problem is that you are not filtering last clause. For example, following line is actually a filter as it is looking for PERSON_TYPE = 300000000120758. (DESCRIPTOR_IDOF("Workforce Management - Worker Assignment Real Time"."Worker"."Person Type") = 300000000120758) Similarly, following line is a VALID…

Sorry, I am unable to see the text file. Can you please go to Advanced tab of analysis and copy & paste text in SQL Issued text box? It will allow me to duplicate your analysis to debug this issue.

Did you built this statement manually? Please try to use Expression Builder to build the same statement. Even converting filter to SQL statement filter is not required. You will be still able to filter the data just like a normal column. Can you please go to Advanced tab of analysis and copy & paste text in SQL Issued text…

Please add a screenshot of entire Advanced SQL Filter. I tested a similar situation that worked. Please refer to the following screenshot. I guess you are missing "='Ture'" or "='False'" criteria based on your need. If this answers your question than please mark this question as answered.

In case of BIP report, Bursting can be used to filter data and export to different files. The query will be run once, data will be fetched once as well, but will be exported into different files post filtering. For OTBI, again multiple views, with different filter criteria applied, can be created out of a single big…

Did it resolved your problem? If yes, then please mark this question as answered.

How complex is the OTBI analysis? If it is tabular in nature, you can create a BI Publisher report instead. In the query, you can link Lookup and Value Sets table to get desired result. You can also fetch physical query behind an Analysis easily, so that you don't have to create whole query from scratch. Please let me know…