Christian Berg wrote:Third: If you delete it in the proper sense of the word and there is no backup, then it is deleted and gone. This isn't Excel files on your Windows desktop. Yes, if deleted in the proper sense of the word (As opposed to 'removed') then you're basically screwed :-/ Thanks for pointing out the slight…

What do you mean by : OBIEE report has got deleted from front end ? Was it only deleted from the dashboard page? In that case, yes, the report is still be available in your catalog. Please be specific in what exactly the user deleted.

Did you check that the popup blocker is not causing the issue? Please provide versions of OBIEE,chrome and the OS you are using which is important sorting out incompatibility issues.

@Jerry Casey Thanks for your contribution, however, Please do not copy content from other sources here, but link to the content instead.

What prevents you from implementing the steps provided by the links?

If you need this in multiple analyses / Dashboards then you should really consider moving logic to the RPD, or preferably to your ETL process so you won't have to calculate the same every time.

Lots of resources on the internet on that, for instance: https://www.rittmanmead.com/blog/2010/08/oracle-bi-ee-11g-reporting-on-clobs-lookups/ Or Let's OBIEE: Handling Large Data Objects In OBIEE11G

Of course, Header Amount will duplicate if you include it in your analysis and you just joined together the header and detail table in the physical layer, that is basic relational datamodeling concepts. There should just be one fact, not Fact header and detail, If you are quering a operational (relational) datamodel then…

Which Database version do you use? That bug has been fixed so you should not run into it?. If you believe you hit this bug and you're database is at a higher version I would advise to raise an SR with Oracle. Unchecking WITH_CLAUSE_SUPPORTED may impact performance so be very careful with this

That last example still won't work actually: FTable 1 T41570 A table does either exist for a schema user (Meaning it has rights to see the table) or it doesn't, therefore switching table order in the query is very unlikely to be the cause of this error. Did you find out which table triggers the ora-942 error? What schema…

I assume you are talking about BI publisher. Best ask your question here:

On a more serious note:

Good luck and thanks for letting us know!

The first thing you should do is look in your logs to see what is going on. Without that it's just guessing

Michael Verzijl wrote:Why not use Usage Tracking to see if a user executed reports? No customization needed and will provide insights.Only issue is that if the user never logged in, it will not be returned and you need an extra lookup to compare with your user base. Yes that's what we use to find out which users are not…

Hence the quotations ;-) 

True, but the points sure keep me (and others I assume) engaged. We all spent some of our valuable time to make this forum succesful so it's nice to have some kind of 'tangible' reward

@user10708433 The proper way to express thanks - and more importantly - to make this thread helpful to others with the same problem is to mark Roberts Answer as Correct and optionally other answers as helpful if you think they have helped you.

The presentation variable that the prompt creates will store the dates like 04-01-2018,04-24-2018 (dates are separated by column) You can get the second date like this: SUBSTRING('@{pVar}' FROM POSITION(',' IN '@{pVar}')+1 ) Date format in the presentation variable string can vary based on your NLS settings

Is this something you need for just one or few analyses? If so you may also consider to use sub-queries in your analyses instead of fixing it in your model (which shouldn't be overly complex IMO).