Issue with OBIEE 11g Filter Function in RPD

Question

Hello All,

I have created a Measure using Filter Function in RPD (logical layer) eg. MEASURE_QTY= FILTER(MEASURE_COL using Dim_Attr ='ABC').

Issue is when I apply another FILTER function at REPORT LEVEL.. it throws an ODBC error... eg. FILTER(MEASURE_QTY USING DIM_ATTR2 ='CSF').

Could you please let me know.. if obiee supports this approach or not? If not, what could be the alternative (apart from CASE statement)

Thanks in Advance!!

Chaitanya · Answer

Hi ,

MEASURE_QTY=FILTER(MEASURE_COL using Dim_Attr ='ABC'). This is what you have mentioned in the thread.  what is MEASURE_QTY ? that column is a calculated column or you just assigning  the value to the Measure_Qty?.

If , Just remove Measure_QTY and try? I'm not sure about the approach, but try like this.

Regards,

C.

SriniVEERAVALLI · Answer

I would suggest to change your approach to broader way, you may use CASE instead of FILTER.