Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

LEFT & SUBSTRING functions not working in RPD

skullOct 2 2019 — edited Oct 8 2019

Hi,

OBI 11.1.1.9.0

Using OBI Admin Tool, I created 2 Logical Columns in BMM which is derived from an existing column using the below formula. However OBI is still displaying the data from the source column (NOE_FAMILY_1 column) in both the logical columns. The data from NOE_FAMILY_1 column is displayed as it is; as if the LEFT and SUBSTRING functions are not applied.

NOE_FAMILY_1 column contains strings (VARCHAR2).

Left("FIN"."D4 NOE"."NOE_FAMILY_1", 3)

Substring("FIN"."D4 NOE"."NOE_FAMILY_1" FROM 6)

However if I use the same functions in OBI, it works as expected.

I am not sure what am I missing in the repository.

Thanks.

Added on Oct 2 2019

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

4 comments

1,059 views