You'd need an SMS gateway to do this.

Sounds like a completely bespoke integration that's been done ... not sure how we're going to be able to fix that for you.

DB Features is a configuration option within your RPD and environment : https://docs.oracle.com/middleware/11119/biee/BIEMG/conn_pool.htm#BIEMG1268 It can cause vastly different SQL generation. In addition - are your environments at the same OBIEE patchset level?

If it's presentation services that's crashing, you need to also look at the sawlog.log. And if it's crashing, you need to raise an SR.

And, how did you update NQSConfig - through the MBeans browser, or manually? If you did the latter and didn't unset it from being centrally managed your changes will have been lost on restart.

Check your nqserver.log - it'll tell you either Usage Tracking started successfully, or give you the error as to why it couldn't.

Presentation Services Enterprise Manager Have a look here for some useful info: https://docs.oracle.com/middleware/11119/biee/BIESG/toc.htm

so that I search the topic on google. Better place than the rubbish you can find on Google is the product's documentation itself : https://docs.oracle.com/middleware/11119/biee/BIESG/usage_track.htm#BIESG211

If you've set virtualize=true then yes this should work.

SAPurgeAllCache clears the BI Server cache only.

How To Ask Questions The Smart Way OS, version, etc? Also - for "Urgent" help, you need to raise an SR ...

Why not purge your cache when the data changes, rather than some spurious schedule? Have a read of this: OBIEE BI Server Cache Management Strategies - Rittman Mead Consulting

Same question...same answer Either: 1) Do a lift & shift hack job, stick all the SQL in direct database requests. Miss the point of having OBIEE in the first place entirely 2) Take the time necessary to model your RPD properly. Transactional, dimensional..whatever. The data will have a logical model to it, and *can* be…

User538247 wrote:Hi,Need to convert 200+ sql queries to obiee answers report by adding new features such as hierarchy n all but data should be intact. NO time to follow traditional data model approach, does someone find out fastest way to convert sql to rpd modelling. Either: 1) Do a lift & shift hack job, stick all the…

You can try and write your own with OBIEE's writeback functionality (possible, I've seen it done several times, but never very nicely), you could use APEX, or there are also two commercial offerings: * ChitChat - Rittman Mead Consulting * BITeamwork

1. It will start to delete the entries that have been least-recently-used (LRU) 2. Either when you purge the cache manually in the admin tool, use an ODBC command to purge it, use EPT; or when you deploy an RPD that's got changes not compatible with the current entries in the cache. Setting cache entries to never expire is…

1. Yes, and no. Yes you *should* have a Subject Area, but you *can* use a Direct Database Request. However this is a Bad Idea because you lose all the benefits of a common metadata layer - the Repository (RPD) 2. No. Subject areas are built on Business Models (known as the Logical layer), which describe the *logical*…

Why not report against the underlying data and model the BoM as a parent-child hierarchy?

My first suggest on the above post would be - word it about 10 times more clearly. I could make half a guess at what you're trying to describe, and half a guess more at what you're asking - but I could we be wrong on both counts. For example, Eg "Cluster servers" -- what is that? A physical tin box? An OBIEE instance? A…

Is this just the same question as this one? OBIEE If so it'd make sense to continue the thread you've already started.