OBIEE and Data Visualization Desktop 12.2.1.2 is now available

OBIEE 12.2.1.2.0 download here

And the documentation here

For Data Visualization Desktop (AKA DVD), 12.2.2.0.0 download link here.

 

Advertisements

List of bug fixed by 12c Bundle Patch 12.2.1.0.160419 and 11g BI BUNDLE SUITE 11.1.1.9.160419

List of bug fixed by:

12c Bundle Patch 12.2.1.0.160419 (Download Here) Continue reading “List of bug fixed by 12c Bundle Patch 12.2.1.0.160419 and 11g BI BUNDLE SUITE 11.1.1.9.160419”

OBIEE 12c NQSServer.exe Stopped Working

What a crazy error! I’ve installed this millions of times and I had no idea why I’m getting this error now. I really don’t want to go through this problem since I don’t know where to head at all. Let me google it for you really did help!

These are the kind of screens you get. Like a virus and keeps popping up!

BI Stops Working Error1 NQSServer has stopped working nqsserver.exe has stopped working and Oracle Business Intelligence has stopped working Oracle Business Intelligence has stopped working

Thanks to Guillaume again!!!

Modified a bit of his code and everything worked fine! I don’t even want to understand why this is happening. If you do, please visit Guillaume’s blog here! Remember to thank him! I’ll do that now!!! LOL! He was right, I had a whole bunch of EPM… Talk about incompatible Oracle stuff!

Create a startup.bat on the desktop with the following:

set PATH=C:\ProgramData\Oracle\Java\javapath;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem
call “C:\Oracle\Middleware\Oracle_Home\user_projects\domains\bi\bitools\bin\start.cmd”

Up and running! Thanks Bruv!

OBIEE Setting Agent to Email the Entire Dashboard

A reader recently requested to see if I could write up a tutorial on emailing OBIEE dashboards in PDF format?

To start off, you will need to create a New Agent.

In General Tab, you will first set the priority of this email. The priority of this delivery can be set to High, Normal, Low. The priority works with the delivery profile for a user to determine the destination for delivery content of different priorities.

Continue reading “OBIEE Setting Agent to Email the Entire Dashboard”

OBIEE Enabling AutoComplete and Never Show Null for Prompts

Since 11.1.1.6 Enabling AutoComplete function is supported by modifying InstanceConfig file.

This setting when set to true turns auto-complete on, which means that the Prompts Auto-Complete field is displayed and is set to On in the My Account dialog and in the Dashboard Properties dialog.

AutoComplete

Continue reading “OBIEE Enabling AutoComplete and Never Show Null for Prompts”

Important Note on OBIEE 12c Visual Analyzer (Data Visualization) Security Settings

In OBIEE 12c, Oracle highly recommends to use Fusion Middleware Security Model.

One of the limitations in using initialization blocks is that Data Visualization doesn’t authenticate against init blocks.

Another important note is when migrating to FMW Security, users will not be able to login because the accounts were created in the Web Catalog with initialization blocks are not valid any more. When migrating, you will need to clean up the init block users form the Web Catalog and new valid accounts can then be created.

The below script will remove all the init block users from the Web Catalog cache.
Download Script

NOTE: PLEASE TAKE A CATALOG BACK UP BEFORE RUNNING THIS SCRIPT. THESE CHANGES CAN NOT BE REVERTED.

To run the script, copy it over to a server and execute it. Script will prompt the Administrator to enter the catalog path.