Select Page

Art of BI: BITeamwork API In Action – Calling Basic Interactions

Christian Screen | | March 20, 2016

BITeamwork is the only collaborative BI tool on the market today for Oracle BI.

Many BITeamwork customer’s wish to leverage it’s JavaScript API to provide place-anywhere type of links on existing dashboards. For example, a sales dashboard would like to have a link inside of the page for launching the cell annotation editor. Or, a User Acceptance Testing (UAT) page on dashboards, wants users to be able to click an obvious link above an Oracle BI table to open the dashboard comment editor in order to document some of the UAT testing and kick off workflow.

The BITeamwork API is very extendable and expands functionality on every minor release as new features are added. Also upon customer request which drive a lot of the functionality that you seen in Oracle BI’s collaboration.

This post looks at the BITeamwork API in action, calling basic interactions such as those mentioned above for launching the cell annotation process and the dashboard comment editor. Enough chit chat, let’s look at the examples.

Screenshot 2016-03-19 22.03.23

Calling Dashboard Editor Via BITeamwork API JavaScript

Any Oracle BI Developer or Administrator should now how to use a bit of JavaScript to do some customizations in OBIEE. The simplest use of OBIEE JS integration is to use the OBIEE dashboard page text object.  Along the sides of the dashboard objects the text object either lets the developer add plain text or rudimentary HTML capable text. Although a primitive object it let’s you accomplish the basics of JS integration.

Add a text object, access its properties, and then enter a simple HTML A link with a javascript call or an onclick handler call to reference the BITeamwork API.

In this case the API function to call is, bar.showPageCommentFormModal()

[code type=”html”]
<a onclick="bar.showPageCommentFormModal()" href="javascript:void(0)">Add Dashboard Comment</a>
[/code]

Screenshot 2016-03-20 14.13.46

Now run the dashboard page and click on the new “Add Dashboard Comment” link.

Screenshot 2016-03-19 22.04.09

Calling Cell Annotation Workflow Via BITeamwork API JavaScript

Add a text object, access its properties, and then enter a simple HTML A link with a javascript call or an onclick handler call to reference the BITeamwork API.

In this case the API function to call is, bar.toggleHotSpotViews(false)

[code type=”html”]
<a onclick="bar.toggleHotSpotViews(false)" href="javascript:void(0)">Start Cell Comment</a>
[/code]

Add the code above to the existing or new text object when editing the dashboard page.

Screenshot 2016-03-20 14.14.32

Run the dashboard page and click on the new link for Start Cell Comment.

Screenshot 2016-03-19 22.03.52

Click on the cell of the table or pivot table or create a footnote to an OBIEE view just like normal.

Bringing the Examples Together

You can see that by using a bit of  standard HTML, the text object can have multiple links or you could split the logic into multiple text objects. Either way the end result when the dashboard page runs will result in the links displayed to your end users. Also, you have the ability to use OBIEE conditional formatting, to prevent certain users from seeing the OBIEE customization or not, as well as to show/hide based on results of another report’s logic, etc.  That latter part is standard OBIEE.  What’s more is the the launch of the API functionality abides by BITeamwork privilege security, so exposing any functionality in general to your user base, still aligns with what you’ve declared the users (or application roles) do or do not have access to.

[code type=”html”]
<a onclick="bar.toggleHotSpotViews(false)" href="javascript:void(0)">Start Cell Comment</a>
[br/][br/]
<a onclick="bar.showPageCommentFormModal()" href="javascript:void(0)">Add Dashboard Comment</a>
[/code]

There’s a lot of awesome functionality in BITeamwork for all different departments of the company. BITeamwork Financial Close, Board Book, UAT, Documentation, Collaboration on Slack, HipChat, Salesforce, Chatter, Podio and lots more integrations like splash page, inline cell commentary, and Smart View and Oracle BI Mobile app provisioning.  Be sure to download the latest version to see for yourself.

12c Upgrade Bug with SQL Tuning Advisor

This blog post outlines steps to take on Oracle upgrade 11.2 to 12.1 if you’re having performance problems. Oracle offers a patch and work around to BUG 20540751.

Megan Elphingstone | March 22, 2017

Oracle EPM Cloud Vs. On-Premises: What’s the Difference?

EPM applications help measure the business performance. This post will help you choose the best EPM solutions for your organization’s needs and objectives.

Bobby Ellis | April 10, 2018

Scripting Out the Logins, Server Role Assignments, and Server Permissions

Imagine there are over one hundred logins in the source server and you need to migrate them all over to the destination server. Wouldn’t it be awesome if we could automate the process by generating the scripts for the required tasks?

JP Chen | October 1, 2015

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.

CONTACT US

Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.

EXPLORE JOBS