Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Issue with OBIEE 11g Filter Function in RPD

Received Response
21
Views
2
Comments
bskumar.obiee
bskumar.obiee Rank 3 - Community Apprentice
edited Aug 13, 2024 6:01PM in Oracle Analytics Cloud and Server

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!!

Answers

  • SriniVEERAVALLI
    SriniVEERAVALLI Rank 6 - Analytics Lead

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

  • Chaitanya
    Chaitanya Rank 4 - Community Specialist

    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.