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

Column Filter Condition...

Received Response
42
Views
13
Comments
2»

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics & AI Strategist

    no where clause?  post the whole SQL statement ...

  • User_9GFDT
    User_9GFDT Rank 3 - Community Apprentice

    You want to see the Select D1.c... statement from the NQQUERY log or something else?

    Thanks

  • User_9GFDT
    User_9GFDT Rank 3 - Community Apprentice

    I figured it out, here was the problem. In the BMM in the RPD I had the Fact measure defined as COUNT(TABLE.COLUMN). Derived from existing columns...

    When I changed that to Derived from physical mappings and set the aggregation as Count, the functionality now works as expected.

    Thanks all for responding.