Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

Can we use a DDR in filter condition of another report which is built using data model?

Received Response
41
Views
3
Comments
User_U5PJ2
User_U5PJ2 Rank 1 - Community Starter
edited Oct 6, 2023 3:50PM in Oracle Analytics Forum

I have a DDR created in BI, and I want to use it in filter condition of another report which is built using data model. Is it possible?

I am getting error when doing so. Please suggest

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    What product (and version)?

    Is your "report built using a data model" a BI Publisher report?

    I am getting error when doing so.

    What did you try? What error do you get?

  • User_U5PJ2
    User_U5PJ2 Rank 1 - Community Starter

    Error Message

    "An unexpected condition occurred (internal diagnostic message: Error: column formula cannot be extracted from the column)"


    I am using semantic model, subject areas to create a report and trying to add a filter condition to lookup some values from DDR report

    We are using OAC

  • User_G085A
    User_G085A Rank 1 - Community Starter

    Any solution for this error?

    I have similar requirement…where I need to have the DDR output values as filter to my OBIEE report.