Can you connect to SQL*Plus via command line on your OBIEE server?

The dimensions join via the facts in dimensional modelling. If you exclude a fact from your query and just run query against 2 dimensions, the BI Server doesn't know how to join up because there could potentially be multiple paths that could join these 2 dimensions together. Two ways round this would be to: * Add a fact to…

This document might be of some help to you. It describes in some detail the supported encryption algorithms.

Have you got a JAVA_HOME environment variable setup pointing to the right Java Home?

What you need to do is to run the Catalog Validation. Oracle Document Rittman Mead Document As these documents suggest, it's best practice to make this a scheduled activity in order to keep your catalog in "clean shape".

A point worth noting is that if you haven't side stepped the repository by building Direct SQL reports then your changes will minimal and they'll just be to the connection pools in the physical layer. Opaque views are another that will need to be changed if you have any.

Hello @3396166 You have given little or no information about software versions, OS you're installing OBIEE etc. Have you read the installation instructions provided by Oracle?

Have you tried other browsers? Clear your browser cache and then try and access your "My Folders " folder. Sent from my iPhone

Have you tried using alternative browsers? Clear your browser cache and then try and access your "My Folders" folder.

You say it works in your UAT environment, how many rows does the report generate in your UAT environment compared to Production where you say it generates between 200000 & 300000 rows.

Approximately how many rows are you trying to export to Excel? By the way, you made no mention of the OBIEE version you're running.

Some might argue that this defeats the purpose of configuring external LDAP. The main reason for external LDAP is for user authentication and user management to be dealt with external from OBIEE. However, you can achieve this by assigning your LDAP users to WebLogic Application roles. You can then apply your specific…

As @Thomas Dodds and @Gianni Ceresa have mentioned this is typically required for textual date fields. This RANK column will then be used as the sort order column for your logical column

You modify your instanceconfig.xml by pointing the catalog to the location where you'd like your new catalog to be created and then restart the Presentation Services.

What you're describing is OBIEE's default behaviour of drilling down a dimensional hierarchy. You can override this by changing the setting in the column properties; Change this setting to Action Link and you can call a report which has the information you require at the specific level of the dimensional hierarchy.

"if" the model has a time dimension...

I don't think that is possible directly as the only tags in the XML writeback configuration are insert and update. However, you could use a database trigger to call procedure on insert or update on your writeback table.

Does the user which the connection pool uses to make a DB connection have access to the synonyms?

Correct but in a scenario where you'd want a non admin user to maintain access to a folder, an option would be to set them up as owner of the folder. You'd need to be careful though as the owner can delete objects by default including the folder itself.

The owner can then reassign permissions of the object to others. Sent from my iPhone