Oracle^® Business Intelligence Answers, Delivers, and Interactive Dashboards User Guide > Working with Oracle BI Views in Oracle BI Answers >

Adding Text to Results Using Oracle BI Static Text View

Use the static text view to add or edit text to appear with the results. You can add markup that contains formatted text, and depending on the security settings of the Analytics servers, ActiveX controls, JavaScripts, sound bites, animation, specialized logos, variables and so on.

The markup may contain anything that is supported by your browser, but only formatting defined using the buttons at the top of the workspace will be displayed in PDF output.

To add or modify an Oracle BI static text view

1. In Oracle BI Answers, create or modify the request with which you want to work, and then perform one of the following actions:
   • To add a new static text view, click the Results tab and choose Other Views > Static Text from the views drop-down list.
   • To edit an existing static text view, click the Results tab, choose Compound Layout from the views drop-down list, and then click the Edit View button for the static text view.

     The workspace shows the static text view.

2. Enter the markup into the text box.

   To make text appear bold, in italics, or underlined, click the appropriate button to insert the beginning and ending HTML tags, and then type the text between the tag.

   NOTE:  To include a line break, use the Line Break button. Pressing Enter does not result in multiple lines of text.

   The following table lists and describes several examples.

   Static Text View Example	Description and Usage Notes
   HTML text	Paste or type the HTML (or appropriate formatted text) into the text box. You can also click the HTML tag buttons. Based on the format of the text you are entering, markup tags may be used to control the format of the text. The following are some examples of what you can do: To set font size and color: <FONT SIZE="4" COLOR="red">Red Text</FONT> To combine tags for additional effects: <B><FONT COLOR="red">Bold Red Text</FONT></B>
   ActiveX object	The Active-X object must be self-contained and supported by your browser. Paste or type the object into the HTML Text window, making sure to include the beginning and ending tags <object...> and </object>.
   JavaScript or VBScript	The script must be self-contained and supported by your browser. Paste or type the script into the text box, making sure to include the beginning and ending tags <script> and </script>.
   Audio	Make sure you know where the audio clip is located. If the audio clip is for use in a shared environment, it must be located on a network drive accessible to all users. Use the HTML tag <EMBED> to add audio. The following format is an example format. Your browser may require a different format. <EMBED SRC="audio" AUTOSTART="true" LOOP="true" HIDDEN="true"></EMBED> where "audio" is the location and name of the audio clip. To add an audio clip located on your hard drive, the following HTML is an example: <EMBED SRC="c:\mycomputer\MIDIfiles\wakeup.mid" AUTOSTART="true" LOOP="true" HIDDEN="true"></EMBED> To add the same audio clip from a shared location on your Web server, the following HTML is an example: <EMBED SRC="\DashboardFiles\wakeup.mid" AUTOSTART="true" LOOP="true" HIDDEN="true"></EMBED>
   Background image	The following example uses JavaScript. Make sure you know where the image to use as the background is located. If the image is for use in a shared environment, it must be located on a network drive accessible to all users. If the image is located in a shared dashboard files folder, the following is example HTML: <script language="javascript"> document.body.background = "/dashboardfiles/"NameOfGraphic";</script> where NameOfGraphic is the name of the file to use, such as bricks.gif or sand.jpg.
   Variables	The following HTML example includes variable expressions using the @{<variableName>}{<value>}[format] syntax: [u] Static Text View [/u][br/] Region: @{myFavoriteRegion} - Year: @{myFavoriteYear}[br/] System Time: @{system.currentTime}[dddd,MMMM dd,yyyy][br/] Product Version: @{system.productVersion}[br/] User ID: @{session.currentUser.id}[br/] [/br] Dashboard Path: @{dashboard.path}[br/] [br/]

3. To apply cosmetic formatting to the font used in the static text view, click the format view button.

   For information about applying cosmetic formatting, see Applying Cosmetic Formatting to Results and Dashboards.

4. To import the font formatting from a previously saved view, click the import formatting button and navigate to the saved view.
5. When you are done, you can save the request with the static text view.

Related Topics

Overview of Oracle BI Answers

Performing Common Tasks When Working with Oracle BI Views