Skip to main content

Action Links in OBIEE 11g



Action link which is used to make link from the analysis/Dashboard to other URL of Web Pages.

Actions provide functionality to navigate to BI Contents, including actions in analyses, dashboard pages, agents, scorecard objectives, scorecard initiatives, and KPIs.

Actions can be executed Explicitly by end users who click action links that are embedded within, Analyses on column headings, column values, and hierarchy level values and in certain views, such as graphs, Dashboard pages, Content delivered by agents, Scorecards in Cause & Effect Maps, Custom Views, Strategy Tree Views, Strategy Maps, KPIs, and KPI watch lists, KPI analyses

Action Links consists of two methods - dashboard and columns in analysis methods.

Dashboard Action Link

While on editing the dashboard in the left side pane we have the option “Action Link” you can drag and drop for available in answers side.

Action Links in OBIEE 11g
Action Links in OBIEE 11g




Analysis Action Link

Under analysis for each and every column you can have a action link under column properties of interaction.

Action Links in OBIEE 11g
Action Links in OBIEE 11g




Types of Actions:

1. Navigate

2. Invoke

Navigate Action:

It navigate or drill or link to other contents in dashboard as well as in columns of tables.

Navigate to BI Content — Navigates to an analysis, a specific dashboard page, or dashboard.

Navigate to a Web Page — Navigates to a specified URL.

Navigate to EPM Content — Navigates to Financial Reporting content.

Navigate to E-Business Suite — Navigates to an Oracle E-Business Suite page or form. You use this type of action to allow users to navigate back to an Oracle E-Business Suite page or form after they have first logged in to Oracle E-Business Suite and then accessed Oracle BI EE.

Navigate to Siebel CRM — Navigates to a view (such as an opportunity) in a Siebel CRM application. You use this type of action to allow users to navigate from a dashboard that is embedded in a Siebel CRM application to a record in a view in the CRM application.

Invoke Action Type:

Invoke a Web Service — Invokes a Web Service operation or any SOA service that is exposed as a Web Service (for example, a Business Process Execution Language (BPEL) process in the Oracle SOA Suite that is exposed as a Web Service).

Invoke a Java Method — Invokes a Java method in an Enterprise Java Bean (EJB).

Invoke a Browser Script — Invokes a Java Script function from the client Web browser.

Invoke Server Script — executes a custom script when the current agent completes. The custom script type can be either Java Script or VB Script.

Invoke an HTTP Request — Sends an HTTP request through the server to a target URL. This action type is used to invoke external systems that are exposed by URL KPIs.

Invoke Agent — invokes another agent. This action type lets you chain agents. For example, you can have Agent A invoke Agent B, which invokes Agent C and so on.

Invoke Java Jobs — executes a custom Java program action that was created in a previous release (prior to 11g) and upgraded in this release. You cannot create this type of action



Steps to Implement Action Links On Dashboard:

Click on the “Edit Dashboard” on the Dashboard right side corner.

Action Links in OBIEE 11g
Action Links in OBIEE 11g




Drag and drop the “action link” object from Dashboards object in left side to right side pane of the sections.


Action Links in OBIEE 11g
Action Links in OBIEE 11g





Edit on the action link, to set the link and parameters.


Action Links in OBIEE 11g
Action Links in OBIEE 11g




Assign the links and text; add the navigation by clicking the right side of the action.

It will display the options of navigation and also invoke actions also.


Action Links in OBIEE 11g
Action Links in OBIEE 11g




For example I am explaining here with “Navigate to a Web page”. 

Linked to Google web page for sample. Once you click on “navigate to web page it asks for the web page address a “HTTP” link. And you can assign parameters. Under options you can assign the information for invoke action.

Action Links in OBIEE 11g
Action Links in OBIEE 11g




· Defining Parameter to execute the action, types of parameters are 

· Fixed — a fixed parameter can be seen but its value cannot be set by a user.

· Hidden — a hidden parameter cannot be seen and its value cannot be set by a user. (Note that hidden does not mean that the parameter is secure.)

· Optional — an optional parameter does not require a value in order for the action to be executed.

Action Links in OBIEE 11g
Action Links in OBIEE 11g




Click and save, check in the dashboard the link will get appear with the name what you assigned.

Action Links in OBIEE 11g
Action Links in OBIEE 11g




Once I click on the link it will navigate to Google site, with some confirmations.

Confirmations as for invoking the navigation.


Action Links in OBIEE 11g
Action Links in OBIEE 11g




Click yes to invoke the action. Click execute to run the action. Once you click execute the Google web page will open in a new tab in the browser.


Action Links in OBIEE 11g
Action Links in OBIEE 11g






Action Links in Analyses

For Each column under properties you can run the action links.

Steps to implement Action Links in analysis:

· Drag and drop the columns from subject area to analysis space. 

· Select the column which you want to add action, click on that and go for the column properties. 

· In the column properties go to 5th tab “Interaction” select for value or column heading too.


Go to Values interaction to assign an action link.


Under Primary interaction you have the list of options to choose, like Default (drill), None, Drill, Action Links, send master – Detail Events.

By click the + symbol, Selecting Action links to navigate to web pages or bi content or Invoke services.


Select Navigate to a web page and define parameters links.


Assigned parameter as “GOOGLE” and prompt “Vijai” Values “12345” Fixed and optional parameters are check in, 


Check for values the interaction assigned or not and then give ok.


Check the action in table view or pivot table view.


The link will check the parameters and ask permission to user to execute or not. User has to confirm the requirement to invoke the actions.


Click Yes. And check the assigned parameters is correct or not then give execute to link to Google web page.


Comments

  1. Hi There
    You mentions Invoke Agents , but how do you do it ?

    ReplyDelete

Post a Comment

Popular posts from this blog

Contact Me

Do You have any queries ?                   If you are having any query or wishing to get any type of help related Datawarehouse, OBIEE, OBIA, OAC then please e-email on below. I will reply to your email within 24 hrs. If I didn’t reply to you within 24 Hrs., Please be patience, I must be busy in some work. kashif7222@gmail.com

Top 130 SQL Interview Questions And Answers

1. Display the dept information from department table.   Select   *   from   dept; 2. Display the details of all employees   Select * from emp; 3. Display the name and job for all employees    Select ename ,job from emp; 4. Display name and salary for all employees.   Select ename   , sal   from emp;   5. Display employee number and total salary   for each employee. Select empno, sal+comm from emp; 6. Display employee name and annual salary for all employees.   Select empno,empname,12*sal+nvl(comm,0) annualsal from emp; 7. Display the names of all employees who are working in department number 10   Select ename from emp where deptno=10; 8. Display the names of all employees working as   clerks and drawing a salary more than 3000   Select ename from emp where job=’clerk’and sal>3000; 9. Display employee number and names for employees who earn commission   Select empno,ename from emp where comm is not null and comm>0. 10

Informatica sample project

Informatica sample project - 1 CareFirst – Blue Cross Blue Shield, Maryland (April 2009 – Current) Senior ETL Developer/Lead Model Office DWH Implementation (April 2009 – Current) CareFirst Blue Cross Blue Shield is one of the leading health care insurance provided in Atlantic region of United States covering Maryland, Delaware and Washington DC. Model Office project was built to create data warehouse for multiple subject areas including Members, Claims, and Revenue etc. The project was to provide data into EDM and to third party vendor (Verisk) to develop cubes based on data provided into EDM. I was responsible for analyzing source systems data, designing and developing ETL mappings. I was also responsible for coordinating testing with analysts and users. Responsibilities: ·          Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business. ·          Understood the requirement and develope