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”

Advertisements

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.

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