Well... even with direct sql my problem will not be solved! Direct SQL does not allow conditional formatting for which all my struggles are!!!

Do we log a call with Oracle?If you have time to waste and a high level of frustration tolerance? Sure :-P Nope, I don't have either. I am busy finding an alternative solution using direct SQL.

You wouldn't. A performance tile doesn't know how to do that aggregation. And now??? Is this something that we can do in 12c? We are with 11g. Do we log a call with Oracle? Is this something not really necessary (that much)? I would really appreciate if you suggest a way forward. Thanks

Thanks for your response. We don't want to push the logic to RPD as it's very discrete and once off kind of request, probably will be used in one or two reports. Direct SQL, unlikely as we already have everything we need in the subject areas. If for a moment we forget that there are 12 unions. What if I have two unions and…

Oops! I should have indeed. Anyways... I have a union query. 12 union queries to show a growth for current month and then conditional format based on previous month growth. I have a complex formula using the result columns of the unions. Simple cast or dividing by 1.0 did not work, thus I am using sum by function. All…

Sorry guys, just figured out that the Accounts dimension was not actually tagged as Accounts in Essbase. Once tagged, it fixed the issue.

Thanks Gianni for your response. My data source is an excel file. I don't have such measure. Those numbers are calculated using multiple measures. As per the existing excel report, they are just headings.