Usage Tracking as @simon_D says, and there's also lots of low-level data (every HTTP request/response) to be had from the Presentation Services sawlog.log file if you enable the appropriate log filters. What is it your security team want to capture?

Error: State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 12010] Communication error connecting to remote end point: address = [OBIEE SERVER]; port = 9703. (HY000) That just means your BI Server is down (or, you've misconfigured the AnalyticsWeb ODBC.ini entry)…

Technical debt. You're about to start accruing it in spades. Even more so if you try to "use partition table selection dynamically using the session variables".

What you're doing here is fundamentally wrong. There's no nicer way to put it. The point of OBIEE is that it generates dynamic SQL based on the user requests, and if you model your RPD correctly in line with your physical data model (partitioning etc) then the physical queries generated will be correct such that they take…

If it's LDAP, can't you just set up the LDAP authenticator in WLS to ignore the relevant branch of the LDAP tree for which you want to disable access?

12c docs home: https://docs.oracle.com/middleware/1221/biee/docs.htm The described behaviour for publishing changes in online mode does indeed seem to have changed, comparing 11.1.1.9 docs to 12c: http://docs.oracle.com/middleware/1221/biee/BIEMG/planning.htm#BCGJIBAE (12c)…

The behaviour you describe in 12c is what I would expect, and would have said I'd observed in 11g too. Did you check what the manual said re. this behaviour? As for design decision ... very unlikely you're going to get one of the product managers from Oracle lurking on here, so if you literally want an answer to that…

Basic toolbar is grey, with blue colour for hoverover, and coloured graph icons

Which component? AdminTool? Answers? VA? Can you post a screenshot.

Interesting. So if you run the logical SQLs (35e2c90a and d2521141) individually (eg through nqcmd or issue raw sql), do they run in the same time? You need to take a look at the DB side of things too -- does it show each physical query (30802, 31226) as taking the same amount of time elapsed? What we're looking for here…

BI Server Cache is stored on disk; it won't get flushed when you restart the BI Server. The exception is if you deploy an updated RPD that's not compatible with the previous cache entries.

Try this: https://docs.oracle.com/cd/E23943_01/doc.1111/e14860/new-bi.htm#FMWLC272 Failing that, speak to your Oracle account manager.

As @Christian Berg said: do the search on the physical files in the file system From a quick test I think you want to be searching for <saw:filter><sawx:expr xsi:type="sawx:subQuery". Assuming you're on Linux, the grep would be: oracle@demo:SampleAppWebcat () $ grep --files-with-matches --recursive '<saw:filter><sawx:expr…

500 *concurrent* users is a vastly different thing from 500 registered users. The rule of thumb I hear is 10% user concurrency, and from experience even that overstates it. Also bear in mind that concurrently logged in is not the same as concurrently executing work. And to get even more into it, they could be putting work…

There *is* a hardware sizing guide on MoS - I'm travelling right now but look again and let me know if you still can't find it. It's built on the kind of things that @Gianni Ceresa mentions - *actual* user concurrency, not just total registered users. Also need to consider are they running pre-canned reports or adhoc?…

https://docs.oracle.com/middleware/1221/biee/BIESG/toc.htm [edit: @JohnGoodwin beat me to it! ]

Great -- glad to have helped.

http://slc02ojq.oracle.com:7780/analytics/saw.dll?bieehome works just fine -- maybe your current network is blocking access on that port, or to that host.

I definitely want to know OBI. But I don't want to spend 6 months reading each and every manual either. I have at most 2 months only for this task. The way I'd see it is that either (a) you won't be able to learn what you need within two months, because you need to practice implementation and learn from mistakes or (b) you…

Can you share your nqquery.log?