New Features in OBIEE 11.1.1.9.0 release:

 Some more new features have been introduced in latest OBIEE 11.1.1.9.0 release:-

Analysis Enhancement:

1.     You can initiate a search within the subject area displayed in the subject area pane; the option is “Subject Areas Pane”.

2.     You can save columns to Presentation Catalog and reuse the same for other analysis.You can also change the properties of the new column in the Criteria tab but be aware that conditional formatting and conditional action links for the column are not saved to the catalog. Regular action links are saved for the column as well as the format properties.The saved column can be edited from the catalog pane and catalog page. All the changes that you make in the catalog are applied to every analysis that used this column. If you modify it inside a particular analysis, these changes are valid only for the analysis that you are working on.To be able to save new measures as columns you should have the Save Column privilege.

  

 

3. In this version we find a new new type of variables: the Global Variables. Global Variables can be defined in the context of an analysis and can be used in other analysis. Useful to do some intermediate reusable calculations.

4. Radio button and check box dashboards prompts can be showed horizontally. When you create a new dashboard prompt using check box or radio button under Options, you can select between horizontal or Vertical Layout appears under Options.

Export & Print options:

1.     In this version, you will find more options in the Print and Export Options dialog. You can select if you want to include charts, images and formatting or to specify column properties like the column width and to wrap the text in columns.

2.     Export menu no longer includes the Excel 2003 and PowerPoint 2003 options

3.     It is possible to set a limit to the number of rows downloading as CSV format

New RPD checkout option:

1.     If you need to check out an entire repository rather than using projects for multiuser development, you can use the Whole Rpd Checkout option

New Option in Administration Tool:

1.     Display Translation Key in presentation tree and Edit Presentation names options are now available in Administration Tool option for this release. Translation keys have been added to all presentation objects. The translation key is automatically populated and by default it matches the presentation object's name; however, you can modify the translation key. When you externalize display names in the Presentation layer and run the Externalize String utility, the results contain the translation key. You can right-click any Presentation layer object, such as a subject area, presentation table, or presentation column, and choose Externalize Display Names > Generate Custom Names or Externalize Descriptions > Generate Custom Descriptions to externalize strings.

Report/Dashboard Changes:

1.     Once you are in editing dashboard, you might see the Advanced Page properties option that set the scope of parameters in cases of Go URL, Prompted URL and Navigate to BI content:

 2. In Tables, Pivot and similar you can see Column properties from the edit window as well.

    
 















Courtesy :  Google :)

    

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