Error in OBIEE report
999602Apr 1 2013 — edited Apr 1 2013Hi Gurus,
I have a summary report and detailed report and a currency prompt in my dashboard. The summary report has to be displayed only if one currency is selected by the user. For this, I am using a condition in section and in the report I am using count('@{PV_variable}') and setting a filter on it i.e., count('@{PV_variable}')<=1 which returns result only if one currency is selected or no rows when more than one is selected.
But I am getting this error:
Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 15036] Logical table Fact - Processed Invoices needs a primary key to support count aggregates on that table.Please have your System Administrator look at the log for more details on this error. (HY000)
Please let me know if the logic I am using is correct and how to resolve the above error