Performance Tile with Calculated Column

user 1208988

Hi,

Please, can anyone (specifically Christian Berg) assist?

My requirement is something similar as in the below post-

https://community.oracle.com/thread/3950062

But the given link does not open and I can't see the solution!

http://slc02okg.oracle.com:7780/analytics/saw.dll?Answers&path=%2Fshared%2FOTN%2Fcalculations

Please advise. Thanks

Gianni Ceresa

Hi,

Although I'm not @Christian Berg ... what isn't clear in the answer?

In your analysis you do not retrieve details but edit the formula to give you the total directly and that's your performance tile value.

PS: "something similar" ... you could at least spend 30 seconds to write your own thread with your own requirements and details about your context (versions etc.).

[Deleted User]

All public SampleApps have been removed and dont exist anymore.

WRT your question: more detail is needed but it sounds like an issue with forced levels of aggregation (or more likely granularity...)

user 1208988

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 working fine and displays correct results in a pivot table provided I change the Aggregation Rule to only Server Complex Aggregation (had to deselect Report-Based Total (when applicable)). (In Edit Pivot Table section, not column formula)

Now when I see the result in a performance tile, it's blank. I was assuming it's because I can't change the Aggregation Rule for a measure in performance tiles.

Please let me know if I am not understood.

[Deleted User]

12 unions into a perf tile...yeah that will be interesting

Any chance you can push the logic to the RPD?

Or worst case....to a direct db request?

user 1208988

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 the calculated column is of Server Complex Aggregation for Pivot. How would I even show that in a performance tile?

[Deleted User]

user 1208988 wrote:What if I have two unions and the calculated column is of Server Complex Aggregation for Pivot. How would I even show that in a performance tile?

You wouldn't. A performance tile doesn't know how to do that aggregation.

user 1208988

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

[Deleted User]

user 1208988 wrote:Is this something that we can do in 12c? We are with 11g. 

No difference between versions. Conceptually the performance tile just expects a single truth. Not a data set which requires front-end post-calculation.

user 1208988 wrote:Do we log a call with Oracle?

If you have time to waste and a high level of frustration tolerance? Sure :-P

user 1208988 wrote:I would really appreciate if you suggest a way forward. Thanks

If it's something special: Honestly go for a direct DB request which produces a result set that's formatted / calculated nicely.

user 1208988

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.

user 1208988

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