Category Archives: Dashboard

Review of the OBIEE Sample App v506

Little background – starting several years ago, Oracle has started providing public with a virtual machine with an image of the whole OBIEE stack. I think this has enabled multiple people to jump into OBIEE world much quicker and focus on the tool. In pre-VM era, if you wanted to deploy OBIEE 11g, you had to spend a few hours preparing infrastructure and installing the stack with DB).  This is my review and impressions of the Sample App v506.

I must tell you, this is the best release of the machine so far – in many aspects, including easiness of installation, comprehensive documentation, examples of best practices and stability. So the short version is, spend some time downloading it – must have. This is a very brief overview – and I’ve not yet had a chance to review Big Data – however, the support for the Cloudier Impala is huge. I think the product team is moving in the right direction.

Installation and performance: 

Installing this on my MacBook pro was very straightforward. Download and unzip the files. Import the resulting ova file into the VirtualBox 4.3. Network Configuration was straightforward as well. I’ve used default NAT – so using localhost:7780/analytics as a point of entry . The machine comes with a very detailed document on how to configure VM networking. I’m running it from an external USB3 drive – but the responsiveness is pretty good, considering how much stuff is there. For optimal performance, I’d recommend having 16Gb of RAM and SSD – that makes everything go faster.

Startup:

Once the VM is up. All you need to launch the demos is 1-click – literally – this hides a lot of complexity behind and allows you to quickly demo functionality / visualizations.

Sample app startup script

Content:

New content is highlighted with light-blue:

new content

Plenty of new charts and visualizations – targeting latest trends (Big Data analysis, HTML5, web API graphs). I really like the new functionality of being able to search the columns in Answers:

 

OBIEE search Answers
OBIEE search Answers

 

A lot of map features and examples – this is extremely useful for working on spatial analytics. Spatial analytics demos are very impressive and work smoothly, like the example below:

Screen Shot 2015-08-27 at 3.47.38 PM

This HTML5 chart is very impressive as well – there’s also an attached workshop on how to create such maps:

Airport Connections

Overall, the value of the content is very high. I see a lot of various applications – for BI consultants, developers, analysts, end-users.

I also want to use the occasion and thank the BITECH DEMO team!

 

 

 

How to remove “My Dashboard” and keep My Folders

Someone wanted to take away from all users ‘My Dashboard’. They want that the users only have the choice between the ‘common Dashboards’.

But the users (the report creators) need My Folders.
So Manage Privileges – Catalog – Personal Storage (My Folders and My Dashboard) does not fit exactly.

Someone has created default shared dashboards that they want the users to see/read by default, but they want to restrict user access to the Shared Dashboard folders.
They want users to be able to access their My Folders directory, but not have access to their My Dashboard link or My Dashboard folders. This is not possible with out of box functionality.

The following enhancement request has been created to benefit the users.

The only way to deny access to ‘My Dashboard’ is via the “Personal Storage (My Folders and My Dashboard)” Catalog privilege. Denying this privilege to a group or user will take away access to both ‘My Dashboard’ and ‘My Folders’ – currently, you can’t separate the two.

Jay Honnavalli suggested the following solution:
“Alternatively, here is a suggestion of using current functionality would be:

1. Create a web catalog group and dashboard via “Manage Presentation Catalog Groups and Users” to be used as the default user dashboard.
2. Grant the ‘Everyone’ web group the appropriate privilege to this catalog group via “Manage Presentation Catalog” – e.g. ‘Read’.
3. In the admin tool, create a session init block to set the ‘PORTALPATH’ session variable to the webcatalog path of the default dashboard page.
3.a. You can find the path by looking at the properties of the folder under ‘_portal’ in the catalog group folder the default dashboard was created in – e.g. “/shared/user_default/_portal/Home”.
3.b. The init string could either select the literal path (e.g. select ‘/shared/user_default/_portal/Home’ from dual) so all users would be routed to the same dashboard. Alternatively, the path could be stored externally, e.g. in a table, and selected from it per userid. That way, it would be manageable outside of the admin tool.

This would force all users to the default dashboard specified in the path used to populate PORTALPATH for all users.
One issue that may occur is with existing users that have set their ‘Default Dashboard’ to anything but ‘Default’ in the ‘My Account’ link – they may be required to set it to ‘Default’, then log-off/log-on for the default dashboard setting to take affect.
I know of no way to get around this potential issue for this scenario short of each user making the change OR deleting users from the webcat such that a subsequent logon will ‘re-initialize’ their account (which will then use the init block set PORTALPATH value). Both of these options seem severe, and the second may prove problematic as long as the ‘My Account’ link is still active. ”

Removing My Dashboard

Customer want to take away from all users ‘My Dashboard’. They want that the users only have the choice between the ‘common Dashboards’.
But the users (the report creators) need My Folders.
So Manage Privileges – Catalog – Personal Storage (My Folders and My Dashboard) does not fit exactly.

Customer has created default shared dashboards that they want the users to see/read by default, but they want to restrict user access to the Shared Dashboard folders.
They want users to be able to access their My Folders directory, but not have access to their My Dashboard link or My Dashboard folders. This is not possible with out of box functionality.

The following enhancement request has been created to benefit the users.

BUG 7665499 – TAKE AWAY FROM ALL OUR USERS ‘MY DASHBOARD’

Solution

The only way to deny access to ‘My Dashboard’ is via the “Personal Storage (My Folders and My Dashboard)” Catalog privilege. Denying this privilege to a group or user will take away access to both ‘My Dashboard’ and ‘My Folders’ – currently, you can’t separate the two. Therefore I have logged the following Enhancement Request.

BUG 7665499 – TAKE AWAY FROM ALL OUR USERS ‘MY DASHBOARD’
Alternatively, here is a suggestion of using current functionality would be:

1. Create a web catalog group and dashboard via “Manage Presentation Catalog Groups and Users” to be used as the default user dashboard.
2. Grant the ‘Everyone’ web group the appropriate privilege to this catalog group via “Manage Presentation Catalog” – e.g. ‘Read’.
3. In the admin tool, create a session init block to set the ‘PORTALPATH’ session variable to the webcatalog path of the default dashboard page.
3.a. You can find the path by looking at the properties of the folder under ‘_portal’ in the catalog group folder the default dashboard was created in – e.g. “/shared/user_default/_portal/Home”.
3.b. The init string could either select the literal path (e.g. select ‘/shared/user_default/_portal/Home’ from dual) so all users would be routed to the same dashboard. Alternatively, the path could be stored externally, e.g. in a table, and selected from it per userid. That way, it would be manageable outside of the admin tool.

This would force all users to the default dashboard specified in the path used to populate PORTALPATH for all users.
One issue that may occur is with existing users that have set their ‘Default Dashboard’ to anything but ‘Default’ in the ‘My Account’ link – they may be required to set it to ‘Default’, then log-off/log-on for the default dashboard setting to take affect.
I know of no way to get around this potential issue for this scenario short of each user making the change OR deleting users from the webcat such that a subsequent logon will ‘re-initialize’ their account (which will then use the init block set PORTALPATH value). Both of these options seem severe, and the second may prove problematic as long as the ‘My Account’ link is still active.