Author Archives: hiteshworld
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:
Edit the following text and replace it to desired one
(Please take backup of that file)
I am replacing ‘Go’ with ‘Enter’
Save the changes to the file
Restart Oracle BI Presentation Service
Final output would be as follows where ‘Go’ has been replaced with ‘Enter’
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.