Hello Board,
OBIEE Version: Oracle Business Intelligence 12.2.1.3.0
Encountered an analysis that needs updated with two additional columns. Went into said analysis and found that it was performing a union, fine. When I add the SUM(0) to one of the union's datasets, and SUM(column) to the other dataset, I am getting an error that says it does not recognize 'SAW_15' - which I assume is an alias for the new column I am trying to create.
Is there a way to get the report to recognize that new column?
How do I create the logic that goes in the 'result column' similar to the other already existing calculated column which houses this logic inside the formula:
ifnull(sum(saw_8 by saw_1,saw_13),0)+ifnull(sum(saw_9 by saw_1,saw_13),0)+ifnull(sum(saw_10 by saw_1,saw_13),0)+ifnull(sum(saw_11 by saw_1,saw_13),0)
This looks like some internal BI code, but unsure how to get this for new column as well as make the new column play nice with existing columns.
one note: the column that I want to add is already in the first calculated column, but will be doing different logic to the new addition.
please let me know if this does not make sense.
thanks,
Cameron