Syntax Error in Filter with USING
TMannFeb 7 2013 — edited Feb 7 2013I have an expenditure and I need to select it for a particular group value. To display it in the OBIEE analysis, I am using a Pivot table and Summary Group is the measure label.
My issue is I have a condition that the Expenditure for a particular summary group <> 0. Below is what I had and then received the error.
My Filter is:
Column = "Fact - Snapshot Aggregate"."Fye Dc Expenditure" USING ("Summary Group"."Summary Group" IN ('Agency Fees', 'IDC'))
Operator = is not equal
Value = 0
When doing so i receive the following error:
Formula syntax is invalid.
[nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 27002] Near : Syntax error [nQSError: 26012] . (HY000)
SQL Issued: SELECT "Fact - Aggregate"."Expenditure" USING ("Summary Group"."Summary Group" IN ('IDC')) FROM "Grants Snapshot"
I don't see what is wrong with the syntax. Any help is appreciated