If you place the "Sub Analysis" to the same page where the "Result analysis" placed does it ["sub analysis"] work? My guess is that dashboard prompt and the "sub analysis" use different logical models.

Oh, that one. Well, I'm simply trying to be honest and useful. Isn't it better to tell the truth at the beginning of the journey, not when someone comes with something starting with "I have a requirement..."?

WAT?! I gave: 1. Step by step guide; 2. Easy to follow; 3. Reference links; 4. Everything numbered. And you call me a "bad cop"? @Daniel Gerçossimo you are welcome

Let me re-energize this topic. Was this system ever working before?

OK. 1.How to enable logs: Diagnosing and Resolving Issues in Oracle Business Intelligence - 11g Release 1 (11.1.1) 2. How to find your query log: Trace SQL Query OBIEE 12c 3 and 4 are more tricky so you may need to come back later with more information.

That is a pretty typical question with a typical answer: 1. Enable query logging (if it is not yet). 2. Find the query for your report. 3. Analyse this query and identify the cause. 4. Correct your model. OBIEE has no magical _SHOW_CORRECT_VALUES=true|false option and we don't know your model.

Why not simply create a new repository and make a new OBIEE installation? Full OBIEE installation takes only a couple of hours. I believe it's the fastest and the simplest solution. And the most reliable too.

@Rampradeep Pakalapati , I'm curious what is the difference between your answer and @Gianni Ceresa 's one.

Let's not leave the question unanswered. It is possible to revert everything to the initial state using wlst and importServiceInstance command. You can import $ORACLE_HOME/bi/bifoundation/samples/sampleapplite/SampleAppLite.bar and restore Sample sales sample rpd and webcat. Here is a good blog post about wlst and…

Documentation: https://docs.oracle.com/cd/B28359_01/server.111/b28319/exp_imp.htm#i1004670 What Are the Export and Import Utilities? The Export and Import utilities provide a simple way for you to transfer data objects between Oracle databases, even if they reside on platforms with different hardware and software…

Hi Abhi, That isn't a direct answer to your question, but it's much easier to use OBIEE SampleApp for learning and testing purposes. Sample App is a prebuild virtual machine with a database, OBIEE and a LOT of interesting samples. You can download it here: OBIEE Samples

@ksbabu, you really need to read the documentation before diving into security related task. Security is a complicated thing and shouldn't be done with hit and miss approach. I've even googled the doc for you: Fusion Middleware Security Guide for Oracle Business Intelligence Enterprise Edition - Contents

If I understand you correctly, you have a data model which gives you default XML and you need to give your customer an XML of another format. Right? You need to create a report with an XSLT template to transform generated XML into the desired form. Data model itself is not a report, but only a half of it.

What do you mean by "XML output in oracle table"?

Maybe I don't understand your question, but right now (on the screenshot) it looks like you are trying to write your custom HTML for a predefined format. You can select "Custom text format" from the drop-down list and write there whatever you want.

Just browse this forum and you'll see a lot of people facing various issues related to installations on desktop OSes (Win 7, 8, 10). So it's a good idea to use a server OS for an enterprise software. Unless you know what (and why) you are doing.

What about using Physical and Logical display folders?

Are you sure it is possible? From my understanding, you see either your own recycle bin or global (if you are a sysdba).

Actually, I've been thinking about something like purging recycle bin, but that isn't a recommendation I would give without some questioning.

BIN$... tables are dropped tables in recycle bin. Do you really need them? About recycle bin management: Managing Tables