How to Separate Concatenated Product Category Segments in OTBI

Summary

OTBI Shows Category Name values concatenated together.

Content

HI  All, 

I have a requirement to show each category segment in a separate column but currently in OTBI it's appearing as below. 

Fillers.Calcium Carbonates 1000-3000.

I am able to split it for BI Publisher using the below sample query but for OTBI , I am still searching for a solution. 

SELECT 

REGEXP_SUBSTR ('RM. Fillers.Calcium Carbonates 1000-3000','[^.]+', 1, 1)

REGEXP_SUBSTR ('RM. Fillers.Calcium Carbonates 1000-3000','[^.]+', 1, 2)

REGEXP_SUBSTR ('RM. Fillers.Calcium Carbonates 1000-3000','[^.]+', 1, 3)   

FROM    dual

--------------------------------------------------------------------------------

Please share if some one have used Evaluate(regexp_substr) function in OTBI to manipulate text such as convert text to columns based on certain values.