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 :)

Steps to Replace Null Values in an OBIEE Pivot Table with 'No Data' or 'N/A' or 'No Description' using Custom Data Format

Scenario: 

Sometimes it is necessary to display numeric values in specified format or replace the null values in table or pivot table with zeros or custom text. OBIEE Answers and Dashboards give us a possibility to customize the data masks for presentation. This could be useful when we want to change the display of data for the purpose of a given report. Using Custom Data Format feature we can change the masks for numeric values, change the display of null values or show dates in custom format. 

Solution:

1) Using custom data format we can specify the custom formatting of columns used in an analysis. This formatting will be applied in report’s tables and pivot tables. To edit a data format for a given column, right click on it and choose Column Properties.

2) Click on Data Format tab and check Override Default Data Format. Select Treat Number As Custom from the list.

3) Now wrt your requirement , type the below examples in "Custom Numeric Format" tab:

a) We can display the values in thousands with K (kilo) letter

     #,#.0,K

 b) Values in millions with M

    #,#.0,,M

c) Values in billions with B

     #,#.0,,,B

d) Add a currency symbol

    £# or $#

How it works is:

‘#’ is a number sign indicating significant digits.

‘#,#’ adds a comma separator for thousands.

‘.0’  indicates the number of decimal places (‘0’ for round number, ‘.0’ for one decimal place, ‘.00’ for two, etc.).

‘,’ is a thousands separator (‘,’ for thousands; ‘,,’ for millions, ‘,,,’ for billions etc.).

‘K’,’M’,’B’, ‘$’,‘£’ are characters that can be added after or before the number mask.

The syntax for custom data formatting for numeric values is:

positive value mask ; negative value mask ; null mask

If we specify the mask without semicolon, the changes will apply to both positive and negative values.

Dealing with null values in numeric fields

Using Custom Data Format we can also specify what should be shown instead of null values, ie we can replace Null values with  '0', 'No data' or 'N/A' .

1) For showing zeros (0) instead of nulls, use the below syntax:

    #,##0;-#,##0;0

(which can be read as: number with one decimal place for a positive value, minus sign (-) and number with one decimal place for a negative value, zero (0) for a null value)

The null values will be replaced with zero.

 2) Replace Null with custom text like ‘Not available’ or ‘No data’ or  '-':

 #,##0;-#,##0;no data

#,##0;-#,##0; -

Our pivot table now shows something other than null values.

Dealing with null values in text fields

For text values the syntax for custom text format is non-null value mask, null value mask.

Set Custom Text Format to: @;No description

The null values will be replaced with ‘No description’ text.

 Cheers :)

Customize Login,Header,Images and Logos in OBIEE 11g

 

To change background image for login page in Obiee 11g we need to follow below steps:

a) Delete existing image in below three locations and rename new image with background_blue_whitegradient_ and paste it in below three locations:

1) F:\OBIEE11g\Oracle_BI1\bifoundation\web\app\res\sk_blafp\login

2) F:\OBIEE11g\user_projects\domains\bifoundation_domain\servers\AdminServer\tmp\.appmergegen_1358364334516\analytics.ear\ukjjdc\res\sk_blafp\login

3) F:\OBIEE11g\user_projects\domains\bifoundation_domain\servers\AdminServer\tmp\_WL_user\analytics_11.1.1\silp1v\war\res\sk_blafp\login

b) delete browser cache and restart BIpresentation services in EM.

To change the Header Text next to the Oracle logo, navigate to the following path:

• E:\OBIEE11g_Home\Oracle_BI1\bifoundation\web\msgdb\l_en\messages\productmessages.xml

 

Edit the following position in the file:

• <WebMessage name="kmsgHeaderBIBrandName"><TEXT>abc</TEXT></WebMessage>
•  Restart the services.

Courtesy : Google