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.

Advertisements

Bursting using OBIEE Agents: Part 3 of 3

Since you have already read Part 1 and 2, our 2016 starts off with the last of the 3 part Bursting using OBIEE Agents. Guillaume explains in Part 3 how to setup the Batch Script and burst off using it.

Bursting using OBIEE Agents: Part 3 of 3

Bursting using OBIEE Agents: Part 2 of 3

Bursting using OBIEE Agents: Part 1 of 3

Bursting using OBIEE Agents: Part 2 of 3

In Guillaume Slee last article using OBIEE Agents to burst reports started us off. The recent Part 2 is out and we will define the bursting definition before continuing to part 3. He has also highlighted the key steps in using Saschinvoke which is the command line tool for scheduler. The good thing is, he using Windows for this demonstration which I’m extremely used to. Following part 2 will be part 3 which is the final part and he will walk us through the batch scripting to launch the agents.

Bursting using OBIEE Agents: Part 2 of 3

Bursting using OBIEE Agents: Part 1 of 3

Merry Christmas and Happy New Year!

Bursting using OBIEE Agents: Part 1 of 3

We all had a problem with bursting in OBIEE. The only tool providing this feature is Publisher but it requires a lot of extra efforts to complete a bursting using Publisher since it will not leverage the RPD for bursting. Recently, Guillaume Slee has written an article using OBIEE Agents to burst reports. It’s an excellent article so take a look if you are interested. I’ll keep this updated when Part 2 is out!

Bursting using OBIEE Agents: Part 1

 

OBIEE Print Dashboard Page PDF without Prompts

By default, OBIEE does not allow you to print PDF without the prompts. The best workaround is to create a custom button using javascript which points to a hidden dashboard page made for printing. Then we can disable the print button in the dashboard and just use the custom javascript button for printing.

Continue reading “OBIEE Print Dashboard Page PDF without Prompts”

Installing OBIEE 12c (12.2.1.0.0) on Windows 7

As you may have noticed, OBIEE 12c just came out. I have decided to deinstall 11.1.1.9 completely and install OBIEE 12.2.1.0.0 on my laptop. Things wasn’t so smooth to begin with as I skipped all the documentation. During my installation, I found out that I will need Oracle DB 11.2.0.4+ to begin with, hence I deinstalled my Oracle DB as well.

In order to follow my tutorial, you will need the following downloaded:

  1. JDK 8 Minimum of 8u51 Download Here
  2. Oracle DB 12.1.0.2.0 Download Here
  3. WebLogic Server Download Here
  4. OBIEE 12c 12.2.1.0.0 Download Here
  5. OBIEE Client Tools Download Here (Which I still have problems with)

For your referencing, Christian and Shiva has an overview of what OBIEE 12c has to offer. View here for: Christian Screen and here for Shiva Molabanti

Once you have downloaded everything, you can continue reading.

Continue reading “Installing OBIEE 12c (12.2.1.0.0) on Windows 7”