Pubudu Dewagama

OBIEE 11g :- Usage of CONCAT Formula.

Concatenates two character strings. In here, going to cancatanates MONTH_DESC and YEAR_VALUE. Result will be as below. Thank you !!! ...

OBIEE 11g :- Usage of CONCAT Formula.

Reviewed by Pubudu Dewagama on 9:59:00 PM Rating: 5

If you need to convert your string to upper case, we can use this formula. Syntax :- UPPER(expr) expr is any expression that evaluates t...

OBIEE 11g :- Usage of UPPER Formula.

Reviewed by Pubudu Dewagama on 8:18:00 PM Rating: 5

In here We can do string manupulation. SUBSTRING(expr FROM startPos FOR length) expr is any expression that evaluates to a character st...

OBIEE 11g :- Usage of SUBSTRING Formula.

Reviewed by Pubudu Dewagama on 9:44:00 PM Rating: 5

Step 1:- According to My subjet area Drag and drop SUPPLIER NAME, SUPPLIER_ID and agian SUPPLIER NAME. Step 2:- go to result page and ch...

OBIEE 11g :- Usage of REPEAT Formula to duplicate the same value

Reviewed by Pubudu Dewagama on 8:27:00 PM Rating: 5

Pubudu Dewagama 11:22:00 PM

Step 1:- In my database , I have created two tables called A_ORDERS and A_SUPPLIERS. Data is available as below. A_ORDERS Table A_SUPPL...

OBIEE 11g: How to Replace Null Values in a Pivot Table

Reviewed by Pubudu Dewagama on 11:22:00 PM Rating: 5

In here, I am going to express how to lookup two table and and insert both table’s data into one table by combining. for that you have to ...

ODI 12c: Lookup two table data and insert into one table using Oracle Data Integrator 12c

Reviewed by Pubudu Dewagama on 9:07:00 PM Rating: 5

Pubudu Dewagama 12:53:00 AM

Step 1:- In this step,need to check ‘ S_NA_ACCT’ table avaiable in the dev_biplatform Schema user in DW repositary. St...

How to Enable Usage Tracking in Oracle BI 11g ( Version : 11.1.1.7.150120 )

Reviewed by Pubudu Dewagama on 12:53:00 AM Rating: 5