CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

Analytical Reports created is showing unexpected result during excecution

I have created an OTBI Analytical Report with say, columns 'A' and 'B'. I need to update the column 'B' to 'C' making it dependent on 'A'. The logic to be executed is as follows:

C --> case when A=0 then 0 else B end.

I have 2 rows in this Report where this logic should work. Columns A and B are individually giving expected outputs. But when the mentioned condition is applied, the else case is not working properly. There is a reduction in the B value. I executed the report with small change in the logic as follows:

C --> case when A=1 then 0 else B end. also,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center