Error throws when I created the new group in analysis

Arun Natarajan-OC

Dear Team,

We have implement OBIA project analytics.

Following error throws when I am trying to create the New Group in Analysis.

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 42047] There are at least two different lookup functions in a single conditional expression in the filter. (HY000)

SQL Issued: SET VARIABLE PREFERRED_CURRENCY='Global Currency 1';SELECT s_0, s_1, s_2, s_3, s_4 FROM ( SELECT 0 s_0, "Project - Performance"."Financial Resource"."Resource Type Name" s_1, "Project - Performance"."Project"."Project Name" s_2, "Project - Performance"."Project"."Project Number" s_3, "Project - Performance"."Fact - Project Budget"."Original Budget Cost" s_4 FROM "Project - Performance" UNION ALL SELECT 1 s_0, CAST(NULL AS VARCHAR(1)) s_1, "Project - Performance"."Project"."Project Name" s_2, "Project - Performance"."Project"."Project Number" s_3, "Project - Performance"."Fact - Project Budget"."Original Budget Cost" s_4 FROM "Project - Performance" WHERE ("Project - Performance"."Financial Resource"."Resource Type Name" IN ('Advertisement - Domestic', 'Advertisement - International', 'Commission On Sales', 'Entertainment Expense', 'Sales Promotion Expense', 'Sponsorship', 'Tender Document Charges')) UNION ALL SELECT 2 s_0, CAST(NULL AS VARCHAR(1)) s_1, "Project - Performance"."Project"."Project Name" s_2, "Project - Performance"."Project"."Project Number" s_3, "Project - Performance"."Fact - Project Budget"."Original Budget Cost" s_4 FROM "Project - Performance" WHERE ("Project - Performance"."Financial Resource"."Resource Type Name" IN ('Bank Guarantee Charges', 'Bill Discounting Charges', 'Bank Charges', 'Interest On Bank Overdraft', 'Interest On Term Loan', 'Interest On Vehicle Loan', 'Others Charges')) UNION ALL SELECT 3 s_0, CAST(NULL AS VARCHAR(1)) s_1, "Project - Performance"."Project"."Project Name" s_2, "Project - Performance"."Project"."Project Number" s_3, "Project - Performance"."Fact - Project Budget"."Original Budget Cost" s_4 FROM "Project - Performance" WHERE ("Project - Performance"."Financial Resource"."Resource Type Name" IN ('Depreciation - Building', 'Depreciation - Vehicles')) UNION ALL SELECT 4 s_0, CAST(NULL AS VARCHAR(1)) s_1, "Project - Performance"."Project"."Project Name" s_2, "Project - Performance"."Project"."Project Number" s_3, "Project - Performance"."Fact - Project Budget"."Original Budget Cost" s_4 FROM "Project - Performance" WHERE ("Project - Performance"."Financial Resource"."Resource Type Name" IN ('401k - ER-Contribution', 'Bonus', 'Central Provident Fund - CPF', 'Certification Reimbursement', 'Club Facilities To Employees', 'Contractor Cost', 'Dental Insurance', 'ESI', 'Food Allowance', 'Gratuity', 'Incentives', 'LEAVE TRAVEL ALLOWANCE', 'Leave Encashment', 'Leave Travel Expense', 'Life Insurance', 'Medical Allowance', 'Medical Expense', 'Medical Insurance', 'Overtime', 'PASI', 'PF-Administrative Charges', 'PF-EDLI Charges', 'Payroll Tax - US', 'Provident Fund', 'Rent Free Accomodation', 'SALARY', 'SCP Contribution', 'Shift Allowance', 'Sick Leave', 'Stipend', 'Tap Contribution', 'Variable Pay Performance Pay')) ) djm FETCH FIRST 65001 ROWS ONLY

I have added following columns

Project Name,Project Number,Resource Type Name, Project Budget Cost.

I have created New group based on Resource Type Name.

Kindly help me resolve this issue.

Thanks & Regards,

Gauthaman S