OBIEE12.2.1.4.0 - Can we achieve this in BI Answers

3822729

Dear Experts,

We are using OBIEE 12.2.1.4.0 on Linux environment. this is a brand new install with no patches applied. We are trying to meet an expectation on a report, but not sure if it can be done with BI Answers. What is required is highlighted in Yellow .

Please suggest how we can achieve this .

Thanks in Advance.

Rakesh

[Deleted User]

How about just having two level-based measures on the respective grand total level and then subtracting the one from the other. Standard fucntionality.

Gianni Ceresa

You create formula giving the total amount on the left, you subtract a formula giving you the total amount on the right and you have your number in a cell. You can then use a narrative view to display it the way you prefer.

Grand total in pivot views are automatically calculated by OBIEE aggregating at the required level the column you have. If you do the same yourself by hand using AGGREGATE(... AT ...) you can achieve the exact same calculation and get by a single formula the virtual total OBIEE shows in a table or pivot view.

EDIT: Or what Christian said if you have access to the RPD

3822729

Thanks Christian. Will try your suggestion and get back..

3822729

Thanks Gianni, I wili try this option and see if I can the delta in a cell. will test this and get back.