Cast Function in OBEE 11g

Cast Function

           Cast is to convert data type.

For e.g:

create table a as

Select CAST(hire_date AS CHAR(40))"H_DATE" FROM employees;

select * from a;

DATE_TIME_DISPLAY_FORMAT = "yyyy/mm/dd hh:mi:ss" ;

DATE_DISPLAY_FORMAT = "yyyy/mm/dd" ;

           TIME_DISPLAY_FORMAT = "hh:mi:ss" ;

Rank Function in OBIEE 11g

Rank Function

1) Select the columns necessary

2) If you are ranking Revenue then select Revenue two times

      3) Click on edit formula on the second measure

 

    4)  Select the rank function from the functions tab

   Functionf(…) -> Aggregate data ->Rank

       5)  Select custom heading to customize your heading (changing name of the column)

Click close once selected

    6)   Click on the measure again in the selected criteria and sort ascending.

Result:

Freeze Column header in OBIEE 11g(11.1.1.6.0)

Freeze Column header in OBIEE 11g(11.1.1.6.0)

We have a feature in OBIEE 11.1.1.6.0 that freezes the data column header. So when a user scrolls down to the bottom of the report, the column header stays in place and only the data rows move.

By default this Freeze option is not enabled. We need to turn ON by adding set of attributes in  instanceconfig.xml file under 

<Views> element, between<GridView>… </GridView> class.

To do this

Navigate to the path 
“<MiddlewareHome>\instances\instance2\config\OracleBIPresentationServicesComponent\coreapplication_obips1″

Open instanceconfig.xml file and add the below entry between <Views> and </Views> tag

<GridViews>
< DefaultScrollingEnabled>true</DefaultScrollingEnabled>
< DefaultRowFetchSlicesCount>200</DefaultRowFetchSlicesCount>
< DefaultColumnFetchSlicesCount>300</DefaultColumnFetchSlicesCount>
< DefaultFreezeHeadersClientRowBlockSize>60</DefaultFreezeHeadersClientRowBlockSize>
< DefaultFreezeHeadersClientColumnBlockSize>15</DefaultFreezeHeadersClientColumnBlockSize>
< /GridViews>

Note: Above entry freeze column header option is enabled when number of rows is greater than 200. You can specify the number of rows as you desire. 

1.       Save the file

2.       Start the Presentation Services. 

I configured for 200 rows, so if the record count increases after 200 records,

We can click on “Get more rows” to get more rows as shown in below screen

This is how table should look like: