Skip to Main Content

OBIEE 11g Front End Calculations with Presentation Variables Error

965464Oct 1 2012 — edited Oct 1 2012
Hi Guru's,

Long time user first time poster to the forums but hopefully you can help.

I have a requirement to perform an aggregation on certain fields with a dynamic grouping requirement (so users can select which grouping they require ie, sum profit by [outlets or companies or region]).

The approach I am using is a prompt setting a presentation variable with the possible groupings for the calculation as choices, and a column in the report with a formula to SUM("table"."column" by "@{variable}{default}") this also contains a dynamic column name containing the presentation variable too.

Where the column could be profit and the variable prompt options could be outlet, company or region (from the above example).

This is currently separate from the RPD due to the dynamic nature required with groupings changing at run time and is done in the front end.

However on selecting some columns via the prompt I receive this error:

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 22027] Union of non-compatible types. (HY000)

This only occurs on some field groupings, and is not a certain type in particular. (Including both short date, short time and varchars).

Any ideas where this problem could stem from?