Creative Me: text

Showing posts with label text. Show all posts

Wednesday, November 23, 2016

How to use Server Variable in IBOTs/Delivers/Agents to show Dynamic text in OBIEE 11g/12c

IBOTS are Intelligent Bursting and Output tool, used in OBIEE, They are triggered by a schedule or a condition to deliver reports to recipients.

Sometimes the business requirments are to deliver the Reports as an attachment, with Dynamic text and Subject/Header.

So here i am to discuss the solution to use Server Variables for fulfilling the request. Lets start with using a server variables in Ibot Subject/Header.

ABC @{NQ_SESSION.VariableName} and EFG @{NQ_SESSION. VariableName1}

Now to use a server variable in IBOT attachment note, is little different. Many places , many syntax are mentioned . But for me only this worked :

ABC @{biServer.variables['NQ_SESSION. VariableName']} and EFG @{biServer.variables['NQ_SESSION. VariableName1']}

So use it an provide more efficient solutions to your client !

Cheers :)

Wednesday, September 07, 2016

Different Tool tip for different column values in OBIEE11g/12c

In OBIEE 11g or 12c, we can add ToolTip to the report on columns. Last week i had a requirement to display different tooltips/text on every column value to users when user hovers on different row in that column of a report.
This is not an OBIEE feature. To get a solution to it, we can try using Javascript in Narrative view. But i tried a different solution.

Req: We have to display different text over different column values. For example below, we have to show Response values in ToolTip, when users hovers over the Product column. Responses can differ.

Step 1: So we created a Dummy KPI in RPD, called Responses and stored the different values (Good/Fair etc ) in it.
Step2: Now in Obiee Report, over the Product column made few changes:
     a) In the 'Column Properties' , under 'Data Format' tab, I am choosing HTML
   b) In column edit formula wrote below:

<HTML> <span title= ' || "Dim"."Responses"|| '>' || "Dim"."Product" ||' </span> <HTML>

Note:
i) You can skip using HTML.
ii) You can write a Case formula in place of Product column, ie column on which you want the hover text.
iii) For Numeric column value, use Cast function to convert it to Char().

Courtesy: Google

Saturday, September 15, 2012

Adding Mouse hover text on column Rows/data in OBIEE 11g

Creating a report that contains HTML links or mouse hover is quite easy now. You can even “parameterize” the HTML link to include values from other columns on a row by row basis. For example, if you have a product column, and wish to create a column containing a URL which will redirect the user to a Google search using the Product value as the keyword, here are the steps to implement it in OBI report :

1. Create a report, and add any column

2. Choose the Edit Formula for that column

3. Enter in HTML using OBIEE syntax, such as this in formula area:

a) to add hyper link:
‘<a target=”_blank” href=”http://www.google.com/search?hl=en&q=’ || Products.Name || ‘&btnG=Google+Search”>’ || ‘</a>’

b) to add mouseover :

‘<a title=”Product Revenue Loss/Profit”>”Column_name”</a>’

4. The single quotes signify a string

5. The pipes || (in hyperlink) act a string operator to concatenate HTML with an actual OBIEE column.

6. NOTE: we’ve added the target =”_blank” tag to open the URL in a new browser window

7. NOTE: if the column values contain spaces, you may need to enclose the column in a REPLACE function to replace spaces with %20, which represents a space in a URL.

8. NOTE: In mouseover HTML text, you can place the mouseover text in quotes and then mention the column name.

9. Once you are finished editing the formula click OK and then go to the

Column Properties -> Data Format tab. Override the Default Data Format and select Treat Text As : HTML

Blog Categories