Whilst you can't limit the *number* of files, there is a limit on the *total storage used* per user account: (http://slc02oks.oracle.com:7780/va/home.jsp?pageid=datasources Prodney/Admin123) These limits can be amended, per MoS doc OBIEE 12c: How To Change The External Subject Area (XSA) File Quota Settings (Doc ID…

Is there a server version of DVD where we can control access to data and visualizations based on user roles? That would be OBIEE with the Data Visualization component

I've never, in 8+ years of working with OBIEE across numerous server installations, seen anti-virus deployed on a Linux server. OBIEE is just as vulnerable as any other network-facing application. It's designed to be secure, but sometimes exploits are found. Oracle release quarterly alerts & patches for any security issues…

Some general resources on automated monitoring of OBIEE: https://www.rittmanmead.com/blog/2012/09/advanced-monitoring-of-obiee-with-nagios/ https://www.rittmanmead.com/blog/2012/09/an-introduction-to-monitoring-obiee-with-nagios/…

[...]The other installation will be completely from scratch (option "Clean slate"). After installation both the presentation server (obips) and bi server (obis) have status SHUTDOWN. I thought this had to do that by scratch you need an rpd and an empty catalog (folder).. We tried importing an empty (but valid) rpd file…

I'm not quite following. First you've said "we just want to start with something new" but then "We have an OBIEE 12 instance running (migrated from OBIEE 11)". There's not really the same concept of a standalone catalog in 12c. You can import and export service instances (for example, as a upgrade from 11g, or to import…

Runcat.sh is just a java wrapper on top of the Web Services that Presentation Services provides. So if runcat can do it, so can you, via the web services API. You can look these up in the documentation, or you may find a tool like JD-GUI useful (if you don't mind almost certainly violating your Oracle T&C to not reverse…

On 2 I have advised clients to do this very thing myself, but curiously on one site ran into a problem where excel exports could handle more data than csv, which given the overhead you mention I did find very odd. Thanks for 3 - I had not heard of this previously! What would your comment be on 5 - get them to use Smart…

Very informant and detailed, many thanks for this. One question, and an issue which every OBIEE developer runs into all too often - you allude to 'running very large volumes of data only to export to excel' - what would be your best practise recommendation on this, given that 'Do not do it' is rarely listened to by the…

What's the context for the question? As in, why are they asking this question? How are you defining "store" data? Disk, or RAM too? Analyses and dashboards do just save metadata in the Presentation Catalog. But if someone builds a report with a filter on a given customer, that customer's ID will be saved in the metadata of…

As the others have pointed out, you can't change the text just arbitrarily. But you can "prettify" the URL: a) Ask your network admins to create a DNS CNAME for 10.11.2.143 to "cib-data-portal" (you can't have spaces) b) Set up a web server listening on the default HTTP port 80 that would forward all requests to the…

If you *click refresh* on a dashboard/analysis, the cache is forcibly bypassed. When you simply *open* a dashboard/analysis, you may get a cache hit, as before. Users won't 'refresh' dashboards unless they believe the underlying data has changed. The only reason they'd see stale data is if you have a cache in use and are…

In an earlier release of OBIEE 12c, you could add an external data source through Answers. This UI was deemed a bug, and removed. The only way to correctly add external data sources is through VA. It's all the same thing though - "Mashups", and all the same licence (part of DV; which is one of the reasons for it being…

Yes; the BI Server supports both ODBC and JDBC. Connect your desired tool to it, and the Presentation Layer of the RPD appears as if a 'database' to the JDBC/ODBC client.

Assuming you're talking about Linux, then stop all OBIEE services, and then run: chown -R abc. /your/fmw/home

Did you run that from your machine, or from the OBIEE server? Also, OBIEE 11.1.1.5 is *old*. You might want to consider moving to 11.1.1.9 so that you stay within support.

OBIEE commentary in 12c is same as earlier versions. What research have you done so far?

To be precise, that shows the BI Server (nqsserver) part of the flow. The "SQL Request" shown in that diagram is the Logical SQL that Presentation Services generates - not shown in that diagram.

Presentation Services (sawserver) generates the Logical SQL (one query), and the BI Server (nqsserver) takes the Logical SQL and compiles it through the RPD to generate one, or more, Physical SQL queries to run on the database. bi_server1 *is* the WebLogic *Managed Server*, and nothing to do with query generation.

Release notes for 12.2.1.2 Exported BAR Files Don't Include Data Files When you back up a BI Service Instance into a BAR (Oracle Business Intelligence application archive) file, data files that you uploaded aren't included in the BAR file.When you import the BAR file into a target system, only the metadata for the data…