Author Archives: hiteshworld

Change ‘GO’ button name of OBIEE Dashboard prompt


By default, default prompt appears as follows:

 

 

 

 

 

You can change the name through following steps:

Navigate to: OracleBI/web/msgdb/l_en/messages

Open globalfiltermessages.xml file

Locate the following text:

<WebMessage name="kmsgGFPGo"><TEXT>Go</TEXT></WebMessage>


Edit the following text and replace it to desired one

(Please take backup of that file)

I am replacing ‘Go’ with ‘Enter

<WebMessage name="kmsgGFPGo"><TEXT>Enter</TEXT></WebMessage>


Save the changes to the file

Restart Oracle BI Presentation Service

 

 

 

 

 

 

Final output would be as follows where ‘Go’ has been replaced with ‘Enter’

Advertisements

Suppressing Null values

 

Suppressing Null values

When working with pivot tables, in rows or columns combination, if a value is present in database it is been displayed otherwise it displays blank value, as it seen here for Year Ago Dollars column.

 

 

 

 

 

 

We cannot suppress this value using ifnull(measure,0)

What we can do is replace blank with hyphen.

Edit the column properties for that particular column and in conditional format

Select operator as is null

In Edit format option select Strikethrough from effects drop down list.

 

Blank values will be replaced by hyphen (-)

%d bloggers like this: