This content has been marked as final. Show 4 replies
in the thread
[url https://forums.oracle.com/forums/thread.jspa?threadID=982497] Using FILTER function in oracle answers
a similar question is handled.
and the error-message
FILTER("Organization Dimension"."Company Location" USING ("Organization Dimension"."Company Location" != 'Cebu') AND ("Interaction Call Detail"."Interaction Type" 'Escalate') )
Function FILTER requires at least one measure attribute in its first argument.
indicates that all your arguments are dimensions. In your code this seems to be the case too. (Datatypes are missing, so I can only judge by column-names)
Your working example
shows a fact as first argument.
FILTER("Dispatch fact"."Dispatch Ticket Count" USING ("Business Residential Dim".BUS_RES_DESC = 'RESIDENTIAL'))
Those non-working-examples use only dimensions as arguments.
As the FILTER-function needs at least one measure. One gets the quoted error-message.
So please take a closer look at the thread mentioned above and the corresponding ORACLE-Docs.
Thank you so much for the feedback. This was very helpful
you are welcome. But the thanks go out to the users of the mentioned thread.