Thank you!

We've done an inventory of patches across all of our environments, and all are the same — which is good. It would seem that our issue is actually being caused by the way we 'promote' changes from one environment to the next. (In the past this way has worked for us — but since upgrading from 6.4 to 7.0 recently, this seems…

I am going to have an admin run an OPatch Inventory on all tiers and see what we come up with. I'll report back. Thank you!

Thanks Christian. This gives me something to think about & bring back to my team for discussion. Thanks for clearing this up for me!

We ran into this issue in 12c. We went into the dashboard properties and changed the Style to be 'SkyrosCloud' and that fixed the issue. Now the users are able to see the graphs using IE. Give this a try and see if it helps.

Maybe I am missing something but as far as I can tell, my advice on how to add conditional formatting to your analysis is still sound -- even when using union queries. You would just do as Joel Acha said and put the formatting on the Result Columns. From there, you would follow the steps that I have already provided in my…

(1) Go into the Column Properties of your Ratio column & go to the Conditional Format tab. (2) Click Add Condition and select your Ratio column. (3) Set Operator to is less than (4) Set Value to 10 (5) This will bring you to the Edit Format box. Set your desired formatting here -- such as setting the font to RED Hope this…

OK...so I kept looking at this calculation formula and something came to me. I realized the SUM function was being used in the calculation when it probably did not need to be (being that the default aggregation for "Perm Rev Snapshot"."Collected Rev" is already set to SUM in the RPD). There was definitely some redundancy…

@ Christian Berg Well, the calculation that I have been showing in this thread is just for example -- for the sake of being able to display the issue. In reality, we are seeing this in almost every place that we do any sort of division in 12c. And the problem being that many of these instances (where this type of division…

Some very odd things here though... The measure I am using ("Perm Rev Snapshot"."Collected Rev") in my calculation is DOUBLE already. I would think that no matter the calculation, as long as all measures in the calc are the same datatype, then it would work itself out. This obviously isn't the case in 12c. The deeper I…

Thanks for the replies EVERYONE. With everyone's answers, I believe I have gotten some great information -- exactly what I was looking for.

Have you tried just using the pipes to concat? Something like this: CAST(YEAR(CURRENT_DATE) as CHAR)||' Q'||CAST(QUARTER_OF_YEAR(CURRENT_DATE) AS CHAR)

I have a pretty simple mind, so maybe I am not understanding the OP's question & I'm just thinking of something WAY more simple than they are asking... But the place where is says 'Total'....you mean here? Because if so, you can just do that by editing your table: My apologies if I've misunderstood and I just posted…

OK...that is what I was afraid of. That is sad...it really gave us all a way to sometimes collaborate on things. Oh well, it was nice when we had it. Thanks everyone for your input!

You can certainly set it up to where only 1 click will run all 74 agents. But it seems like you've already got that part figured out -- by adding each agent to in the 'Actions' of the 'Master Agent'. As far as I know, the only way to do it is to add each agent one-by-one in the Actions section. If there is a better, more…

Also, you can have one agent (think of it as a 'Master Agent') that when invoked, its only job is to run other agents. We currently do this. We have the 'Master Agent' that does nothing but run 5 other 'child' agents simultaneously.

Here is another solution for refreshing dashboards on desired intervals. You may want to give it a try: https://www.jamescoyle.net/how-to/1907-javascript-to-refresh-all-obiee-dashboard-analysis

You haven't given much information here, but I'll do my best to help. Say you are using a TRANSACTION_DATE to drive the date dimension in your report... And assuming your report is running on the 20th of every month... If that report were to run on November 20th, 2017, you could use the following filter on your report:…

Take a look at this: https://www.jamescoyle.net/how-to/1907-javascript-to-refresh-all-obiee-dashboard-analysis?v=7516fd43adaa We used it & it worked very well for us. Just be sure to also bypass the presentation server cache & bi server cache within whatever reports you are trying to auto refresh. To do that, you'll want…

I believe to bypass the client side cache, you can: 1)Go to Advanced tab of Report 2)Go to Advance SQL section 3)Check the 'Bypass Oracle BI Presentation Services Cache' check box And to bypass the server cache, you can: 1)Go to Prefix Section 2)Write the below command: SET VARIABLE DISABLE_CACHE_HIT=1; or SET VARIABLE…