run-cat.cmd works on Windows, with the same syntax as the Linux version (runcat.sh). Nico has a good article (as always) on it here: http://gerardnico.com/wiki/dat/obiee/catalog_manager#command_line_options

You're probably best raising a SR to Oracle. Software crash = bug = what you pay your support money for

Please see your system administrator to ensure the clocks are synchronized. Did you try this?

Go and look at the server log files. BI Server, Presentation Services, Managed server. You'll find an error in there that should guide you to the issue.

One possibility is that your connection pool in the RPD is not set to pool connections, and/or you've not set the number high enough. If that happens, OBIEE will indeed queue up requests to the database until there is an available connection. You can validate this by using the DMS metrics available within OBIEE. There's…

OBIEE is pulling back a LOT of data from the database, and has to dump it to disk when it can't store it all in memory. Get a bigger disk, or preferably reduce the amount of data you're getting OBIEE to ship around. Look at the number of rows back from the DB vs what goes back to the end user report, see if there's a…

I never install OBIEE 12c. The manual is always a rather splendid place to start : https://docs.oracle.com/middleware/1221/biee/docs.htm

Have you tried setting LOGLEVEL=2 and checking the BI Server query log for evidence of cache hit/creation? What about running with DISABLE_CACHE_SEED=0 as a request variable? Can you post the excerpt of the query log for an execution?

OK, I got what you're saying. I'm saying, focus on the bigger picture. Whether you can do a View Data or List Table in Import Metadata is kinda irrelevant to the end goal. Annoying, but irrelevant. What you're trying to do is get OBIEE to generate dynamic SQL queries based on the logical requests that your users will…

923551 wrote:Could be great, but how ? Not sure what you're asking. Do you know how to build an RPD?

What happens if you take a bit of a different tack, and build a very simple RPD so that the physical query generated is a viable one? I.e. so that it's not trying to do a "SELECT *..." it's more like something OBIEE would actually run in practice, along the lines of "SELECT FOO, COUNT(*) FROM TRUCKS GROUP BY FOO;".

What version you are on? There are many poor quality "articles" on blogs that show you how to butcher an OBIEE installation to 'customise' a skin, but what's in the docs works just fine: * <= 11.1.1.7 * 11.1.1.9 * 12c

You could have a look at the AdminServer.log file and the access.log file for AdminServer too, that might at least give you an IP.

Thank you. I understand your point. Is there any way to get the actual time taken using Usage Tracking.? No.

Usage Tracking tells you how long the BI Server was working on the logical query, including holding open the ODBC cursor for the client (typically, Presentation Services). The time in Usage Tracking often does match up what the end-user will experience, but not always. Things like reports paging through data etc will give…

My requirement is to get GA data (like Users, Sessions, start_timestamp, end_timestamp, etc.) and integrate it with my other BI system. Have a look at Usage Tracking (out of the box with OBIEE) and Enhanced Usage Tracking, between them they can provide that information

I am trying to create a java app that allows a user to select an object from Catalog Manager. What will the user do with the object once they've selected it? How does the java app interact with catalog manager? Seems like only half the picture we're getting here. As @Gianni Ceresa says, the webservices are the best way to…

Doesn't work like that any more. That password is there for a reason (live RPDs in 12c are a LOT more complex than before) and no-one knows it - because you don't need it. You can open the RPD online, or you can use data-model-cmd downloadrpd to get a copy of the current live version.

Does CURR_FISC_YEARMO join to YEARMO in the physical level? If that's not your join key then the query generated is not going to use it. If it is, then queries should be using it and so your DB But, re-reading your question you say : it does not hit partition table How do you mean? Do you mean OBIEE generates the physical…

Docs: Customizing the Oracle BI Web User Interface