Using HTTP in Oracle BI

This document is intended to show you how to use the HTTP (URL or JavaScript) method in Oracle BI to achieve some specific presentation effects. This document contains the following topics: 1. Use the Go URL to introduce Oracle BI views in an external portal or app, 2. Use the dashboard URL to reference dashboard content in an external portal or application, 3. Use the Go URL to pass SQL or filters; 4. Using JavaScript for filtering 1 using the Go URL to introduce Oracle BI views in an external portal or appThis section describes how to introduce Oracle BI views in an external portal or app by using the Go URL, including the following: (1), Go URL structure, (2), go URL parameters; 1.1 Go URL structureOracle BI's Go URL command can bring a specific Oracle BI view into an external portal or application. When you add a view to a page or add a link to request an Oracle BI view, you'll use the Go URL. If you are calling a page on the same Web server, the URL should be written as/analytics/saw.dll? In the form of go&path=, "=" is followed by the path to the Oracle BI view that you refer to. If you call a page on a different Web server, the URL should be written as Http://server_name_or_ip_address/Analytics/saw.dll? In the form of go&path=, "=" is followed by the path of the Oracle BI view that you refer to on that Web server. The following go URL returns a view named Testform in the/share/test directory of Oracle BI:/analytics/saw.dll? Go&path=/shared/test/testform 1.2 Go URL parameterYou can control the effect of the go URL by adding one or more parameters. If you pass a parameter that contains a space, you must replace it with a "+". 1.2.1 User name and password. If the view requested in the go URL requires a specific user permission to see, or if the user does not choose to keep the login information, then the user name and password must be submitted in the Go URL. The format is as follows: &AMP;NQUSER=UUU&AMP;NQPASSWORD=PPP For example: Http://localhost:9704/analytics/saw.dll? Go&path=/shared/test/testform&nquser=administrator&nqpassword=administrator users to log in as Administrator, Password is administrator? 1.2.2 Link Options. The returned page will contain related links. Format: &option=x x can be the following characters: M: Modify F: Refresh D: Print r: Download For example: Http://localhost:9704/analytics/saw.dll? Go&path=/shared/test/testform&options=mfdr? 1.2.3 Application Optimization. The returned pages will be optimized appropriately based on the specific parameter values. Format: &action= for example: Http://localhost:9704/analytics/saw.dll?Go&Path=/shared/test/testform&Action=print; The returned page will not contain information such as page controls, hyperlinks, etc., for printing. 1.2.4 The specified view. The view specified by the parameter value is returned instead of the default combined view. Format: &viewname= for example: Http://localhost:9704/analytics/saw.dll?Go&Path=/shared/test/testform&ViewName=Chart; Assuming that the requested view contains a graph named chart, only the graph is displayed in the returned page. 1.2.5 Specifies the style. The view is displayed in the style specified in the parameter. Format: &style= For example: Http://localhost:9704/analytics/saw.dll?Go&Path=/shared/test/testform&Style=Lime? 1.2.6 The result format. This parameter can be used to control the format of the returned page. Format: &format=xml/html example: Http://localhost:9704/analytics/saw.dll?Go&Path=/shared/test/testform&Format=XML; The XML code for the page is displayed. 2 referencing dashboard content in an external portal or app using the dashboard URLThis section describes how to use the Dashboard URL to include the following:? (1), Dashboard URL structure, (2), Dashboard URL parameter, (3), Dashboard URL for an application case. 2.1 Dashboard URL structureOracle Bi's Dashboard URL command can bring content from a specific dashboard to an external portal or application. If the call is Dashboard,url on the same Web server should be written/analytics/saw.dll? In the form of dashboard&portalpath=, "=" is followed by the path of the Dashboard you refer to. If you call a page on a different Web server, the URL should be written as Http://server_name_or_ip_address/Analytics/saw.dll? In the form of Dashboard &portalpath=, "=" is followed by the path you refer to Dashboard on the Web server. The following dashboard URL will return dashboard named Page1 in Oracle BI's/share/test/_portal/test directory:/analytics/saw.dll? Dashboard&portalpath=/shared/test/_portal/test&page=page1 2.2 Dashboard URL parameterThe parameter type and usage of the Dashboard URL is similar to the Go URL, please refer to the go URL parameter. an application case of 2.3 Dashboard URLIn the view generated by  oracle BI, you can set the navigation in the Column Properties section to point to a page or dashboard. And all rows of the column will point to the same page or dashboard, which means that the returned result is independent of the other values of the row. In practical applications, it is often expected to return results related to other columns of the row, which can be achieved using the dashboard URL.   Below an example to illustrate that:  now has a table called the market analysis detail, as shown below  ┌──────────┬───┬──────┬───────┐│market          │year│dollars  │link       &NBSP;│├──────────┼───┼──────┼───────┤│&NBSP ;                  │2000│$282,113│click here││        &NBS P          ├───┼──────┼───────┤│atlanta      │2001│$474,691│click here││  &N Bsp                ├───┼──────┼───────┤│            &NB Sp      │2002│$74,545│click here│├──────────┼───┼──────┼───────┤│                   │2000│$85,595│click here││                  andNbsp;├───┼──────┼───────┤│birmingham│2001│$202,137│click here││                   ├───┼──────┼───────┤│                  &NBSP;│2002│$18,052│CL Ick here│└──────────┴───┴──────┴───────┘  where link is a custom column. Set "Treat text as HTML" in the column properties.   Edit Column Formula:  ' <a Href=saw.dll? Dashboard&portalpath=/shared/test/_portal/test&page=test&action=navigate&p0=1&p1=eq&p2 =markets.market&p3=1+ ' | | markets.market| | ' >click here</a> '   So, click here on the first line to display detailed sales information for that row's market.   The first three lines of "click here" actually point to:  saw.dll? Dashboard&portalpath=/shared/test/_portal/test&page=test&action=navigate&p0=1&p1=eq&p2 =markets.market&p3=1+ atlanta  Three lines of "click here" actually point to:  saw.dll? Dashboard&portalpath=/shared/test/_portal/test&page=test&action=navigate&p0=1&p1=eq&p2 =markets.market&p3=1+ birmingham  of course, using the Go URL can also achieve similar effects, but the final point is notis a dashboard, but a specific Oracle BI view.   3 Passing SQL or filters using the Go URLThis section describes how to pass SQL commands in the Go URL and how to pass filters to control Oracle BI view results, including the following:? (1), pass the SQL command in the Go URL;? (2), pass the filter in the Go URL. 3.1 Passing SQL commands in the Go URLThe format of the Pass SQL command in the Go URL is as follows: Saw.dll? Go&sql= can be used in conjunction with parameters such as &style,&options. It is important to note that the spaces in the SQL statement must be replaced with "+". For example: Saw.dll? Go&sql=select+region,dollars+from+suppliersales will return a column named Region.dollars from the name Suppliersales. 3.2 Passing filters in the Go URLThe  go URL can contain filters to filter the requested target. It is important to note that the column involved in the URL must be a column in the view that contains the filter hint itself.   Format:  &action=navigate &p0=n n Represents the number of columns to be filtered, with a value range of 1~6. The value of the  &p1=op op and its meaning are shown in the following table. .  parameter Description------------------------------------------------eq equals or does not equal in NEQ or not in LT less than GT Greater than GE greater than or equal to bwith start at ewith end in Cany contains any (values in &AMP;P3) call contains all (values in &p3) like use%25 instead of the regular% wildcard top &p3=1+n, n is the number of items to display bottom &p3=1+n,n is the number of items to display bet between (must contain two values in &AMP;P3) NULL is null (&AMP;P3 must be 0 or omitted) Nnull is not empty (&p3 must be 0 or omitted) &AMP;P2=TTT.CCC TTT is the table name, CCC is the column name, the space must be replaced with%20 &p3=n+xxx+yyy+zzz N is the number of values, XXX,YYY,ZZZ is the actual value   for example:  Return records for Central and east:  saw.dll? go&path=/shared/test/testform&action=navigate&p0=1&p1=eq&p2=customers.region&p3=2+ Central+east returns the record of the region name starting with E: Saw.dll? go&path=vate&p0=1&p1=bwith&p2=customers.region&p3=1+e  returns records in region named E....T format:  saw.dll ? Go&path=/shared/test/testform&action=navigate&p0=1&p1=like&p2=customers.region&p3=1+e% 25t back to the top two records in the sales area:  saw.dll? go&Path=/shared/test/testform&action=navigate&p0=1&p1=top&p2= "Sales%20facts". dollars&p3=1+2  returns records with sales between 2,000,000 and 2,500,000:  saw.dll? Go&path=/shared/test/testform&action=navigate&p0=1&p1=top&p2= "Sales%20Facts". dollars&p3=2+2000000 +2500000  returns records with the region name beginning with E and sales exceeding 2,000,000:  saw.dll? Go&path=/shared/test/testform&action=navigate&p0=2&p1=cany&p2=customers.region&p3=1+e &p4=gt&p5= "Sales%20facts". dollars&p6=1+20000000  Note that the Go dashboard can also pass filters using similar formats and parameters.   4 using JavaScript for filteringOracle BI provides some javasript functions that can be used to implement and use hints and filter-like effects. These functions are defined in oraclebi\oc4j_bi\j2ee\home\applications\analytics\analytics\res\b_mozilla\viewhelper.js. 4.1 Gonav & Gonavex  These two functions are used to control a particular Oracle BI view.   Function Prototypes: Gonav (Event, spath, STBL, SCol, Sval, Starget)   Where:  event: Event indicator, typically set to 1sPath: Target Oracle Path and name of BI Scol: The name of the table you want to filter Sval: The column name you want to filter starget (optional): Set to _blank to show results in a new window   example:  <a href= "javascript: Gonav (1, '/shared/paint demo/sales summaries/regional analysis/market Analysis Detail ', ' Market ', ' Market ', ' BOSTON '); >click here to navigate to Transaction Details with ' Some value ' </a>  the page to which the link is displayed displays a view named Market Analysis Detail , Markets.market is a record of ' BOSTON '. The Gonav function calls the Gonavex within it. Gonavex can be treated as a multi-parameter version of Gonav, and you can filter multiple columns (up to 4) in the same view at the same time.   Function Prototypes: Gonavex (event, Spath,starget,stbl1,scol1,sval1,stbl2,scol2,sval2,stbl3,scol3,sval3,stbl4,scol4,sval4 The meaning of each parameter is similar to the meaning of the parameter in Gonav.   Note that in Gonavex, Starget must be set and cannot be omitted.   Example:  <a href= "Javascript:gonavex (1, '/shared/paint demo/sales summaries/regional Analysis/Market Analysis Detail ', ' _blank ', ' market ', ' Market ', ' ATLANTA ', ' Periods ', ' Year ', ' 2001 '); >click here to navigate to Transaction with ' Some value ' </a>  the page that the link points to shows a record named ' ATLANTA ' and Year ' 2001 ' in the view of the detail. ?  4.2 Portalnav & Portalpagenav These two functions are used to control a particular dashboard. Function prototype: Portalnav (event, Sportal,stbl,scol,sval) Where: Event indicator, typically set to 1sPortal: path and name of the target dashboard SCol: The name of the table to be filtered sval: The name of the column to be filtered for example: <a href= "Javascript:portalnav (1, '/shared/test/_portal/test ', ' Periods ', ' Year ', ' 2001 ');" >click here to navigate to Transaction with ' Some value ' </a> the link to the page that displays the record named Test in Dashboard, year is ' 2001 '. The Portalnav function calls the Portalpagenav within it.  Portalpagenav can be considered a multi-parameter version of Portalnav and can be filtered at the same time for multiple columns (up to 9) in the same dashboard. Function prototypes: Portalpagenav (Event,sportal,null, Stbl1,scol1,sval1,stbl2,scol2,sval2,stbl3,scol3,sval3,...... sTbl9,sCol9, SVAL9) The meaning of each parameter is similar to the meaning of the parameter in Portalnav. For example: <a href= "Javascript:portalpagenav (1, '/shared/test/_portal/test ', NULL, ' Market ', ' Market ', ' ATLANTA ', ' Periods ', ' Year ', ' 2001 '); >click here to navigate to Transaction with ' Some value ' </a> the link to the page that shows the dashboard named Test, Markets.market as ' ATLANTA ' and a record with a year of ' 2001 '.

Using HTTP in Oracle BI