Don't tune OBIEE ... tune the approach to information in the enterprise ... novel concept!

NOTE: There is no predicate filtering with an opaque view -- you may have performance issues depending on what you are doing with it.

"One of the requests from the auditors is for a detailed change report, meaning they would like to see a report that list any changes to the environment over a given period, who made them and what the changes entailed. So my question is can this be done? Has anyone here ever had to do this for SOX compliance." This is a…

You want a RSUM() on your COUNT(by month)

what about 'removing' the outlier and then having a sibling analysis that highlights the 'removed' outlier?

Adding clarification: you are using SQL Developer to just monitor DB sessions?

"It is not a problem of modeling, it is as simple as wanting to place a calculated column" "Simply wanting to place a calculated column" -- success depends on the model ... ALWAYS

Could help someone down the road if not today ... i'm optimistically belligerent

It's not a requirement - it's a wish. It's a wish that comes when no one is vetting the capabilities of the system being used. How many discreet values can you put in an IN clause in SQL? Oracle chokes: ORA-01795: maximum number of expressions in a list is 1000 So ... why would you allow users to possible select even 1001…

you want 3-month running sum of max values by month ... you've got the max already so do an MSUM(max,3) and make sure your months are sorted correct ... Example This example shows a query that uses the MSUM function, along with example query results. select month, revenue, MSUM(revenue, 3) as 3_MO_SUM from…

You've got a few posts on Brio to OBIEE ... ONE question: are you doing a report to report conversion OR are you developing an information model that supports the decisions made from the sun-setting Brio reports? If the former - good luck (I've turned down a lot of work and $$ because it isn't worth it) ... if the latter,…

6 days ago ... "If this is against Oracle DB then default date data type typically has default date format of DD-MON-YY i.e. '21-SEP-18' - have you tried this?" the ORA error is because your literal is not right (no matter what the Admin tool shows - the query isn't run in the admin tool but on the database)…

"Nothing more permanent than a temporary solution" is often the result ... if there's no time to do it once right, when we the time be had to do it again?

Jerry ... and then have to repeat that for any/every report he wants the hierarchy in ...

There is a Employee ID that returns with one employee per row and then Manager ID is split up into 10 separate fields (Manager 1-15). 1 being the direct manager that the employee reports to and then as it moves down the columns it post the next manager in the line until it reaches the CEO and then any remaining columns are…

isn't that what I said yesterday? Now 3283945 ... when you pass one value from an ANALYSIS to another you are doing so as a filter ... you are better off showing both reports and letting the user input the target (value from ANALYSES 1) and use that in ANALYSES 2 ... you really aren't filtering with that value, rather you…

Zoom isn't the issue ... data visualization design principles are not coming into play - that's your issue. Even if you get 'zoomed' you are going to have too many lines for anyone to make sense out of ...in any case, have you tried force setting a minimum on the Y axis?

Mr. Berg - You asked for clarification and the OPster copied the OPost ... no wonder you lose it! Now 3283945 ... when you pass one value from an ANALYSIS to another you are doing so as a filter ... you are better off showing both reports and letting the user input the target (value from ANALYSES 1) and use that in…

Anything in here help you out: OBIEE: Reset button on OBIEE 11g Prompts

Seriously ... time to build one ... it's foundational