Pubudu Dewagama

OBIEE 11g :- Usage of INSERT Formula.

Inserts a specified character string into a specified location in another character string. In here, going to INSERT MONTH_VALUE in MONTH...

OBIEE 11g :- Usage of INSERT Formula.

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

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