FYI and just a quick update I was able to finally find what the issue was - Apparently a very silly mistake. In the MOS document I linked to earlier - In the section titled: Installing New RCU Schemas In The New Oracle Database There is a step where it states to bring data over from the old schema to the new target schema…

Hi @Gianni Ceresa My bad! I actually am not too sure what the difference between the MOSC forums vs this forum - Hence wasnt aware it was a double post? These two forums have always confused me as to which one to look at

Hi @Gianni Ceresa Thanks for the tip on reading through the "Help" section in the admin tool. I actually read through most things and I think I see where I made a mistake. I guess in my case, my DEV and QA RPD should have been the same, or equal. So my DEV_ORIG should equal my QA_ORIG basically and as you said I guess it…

https://community.oracle.com/tech/apps-infra/discussion/comment/16777545#Comment_16777545 LOL - Sorry your "dont know what the halibut..." got me 🤣 I double checked the RPD and I think you nailed it on the head. At first I was thinking like what Gianni mentioned - The dimension table is joined to the fact table, so I would…

Hi @Gianni Ceresa I think I am still missing something fundamental here Digging in the RPD I have, I open up a small dimension and its logical table source -> Content tab and I see the following Its a dimension, so I see the one hierarchy its related to. So its only showing the hierarchies of this logical dimension table.…

Just got hit with this again These are the two latest patches I had installed So we are on OBIEE version 12.2.1.2.180717 - With applied patch Patch 27766951 as I noted last time, and having this patch did not seem to make a difference on my SND box server. The variables still did not refresh as expected unfortunately.…

Does/Has anyone tried using Google charts in OBIEE? Or seen the above error?

Thanks for posting that blog post Gianni I am still in the sandbox testing enviroment, so will need to take a look over to see how to make it work properly as you suggested. As I mentioned I was just doing a quick and dirty test in our sandbox enviroment to verify it works. But will need to do a more proper/formal way as…

Thanks very much for this Christian - I actually ended up going a different route (a quick and dirty way) to test this in our sandbox I ended up modifying the common.js file in the following two locations 1)…

Do you mind if I ask which patches you have installed? Could you do an [opatch lsinventory] or an [opatch lspatches] and paste the results here please? I would very much appreciate it

So heres my summary I have 4 enviroments (SND, DEV, QA, PROD) - All 4 of these enviroments have OBIEE 12.2.1.2.180116 I had installed the patch 28298611 which includes these patches/bugs fixed [24566569, 25586507, 27019889] on my SND server ONLY leaving the other 3 servers to see what happens. Not exactly on the same day,…

Many thanks for all the replies Generally the gist that I got is - Is it possible to let users self govern security? Yes -Is it easy/common place to do this sort of thing? No I will have to have a chat with my manager to explain all of this - My team recently got merged into another team, and thus there are a lot of…

Apologies, I forgot to note that I actually installed this patch in our sand box enviroment Patch 28298611: MERGE REQUEST ON TOP OF 12.2.1.2.0 FOR BUGS 24566569 25586507 27019889"> Patch 28298611: MERGE REQUEST ON TOP OF 12.2.1.2.0 FOR BUGS 24566569 25586507 27019889 This was the newest patch I could find for 12.2.1.2 that…

Ah I see what happened There is mention of that bug being fixed in the patch docs for OBI BUNDLE PATCH 12.2.1.3.180717 but strangely for OBI BUNDLE PATCH 12.2.1.2.180717 it does not mention it I will try installing the patch Oracle Support Document 2338889.1 that @Dimitris Karydis mentioned first and see if that fixes…

Hi Joel Sorry for the very silly question - But where can I find in the bundle patch the description of what this patch addresses? I see that this patch addresses a number of bugs, but when I attempt to click on a link or search the oracle support database I cant seem to pull up any info on the actual bugs?

My environments also failed to refresh the variables as of Aug 3, 2018 @Dimitris Karydis Which patch did you apply? Was it the one that was given by Joel Acha? Also, how did you test? Were you able to re-create the issue?

My server variables also did NOT refresh as of today - They got stuck on June 14, 2018 I find it VERY co-incidental that multiple users across regions are experiencing the same issue right around the same time.

Adding in my info I have 4 environments (Sandbox, DEV, QA and PROD) All my environments are single node and not clustered We are on version 12.2.1.2 for all 4 enviroments, and migrated from 11.1.1.7.140225 - We never experienced this issue when we were in 11g 3 out of my 4 environments failed to refresh the dynamic…

My apologies for the duplicate post, I was not aware that the two forums were linked up. When I was chatting with a colleague he mentioned to "go and try posting in this OTHER forum" I incorrectly assumed that the forums were seperate. For those that stumble across this thread, I am stopping in this thread and am hoping…

Ok my curiosity got the best of me and I logged into work remotely to see the contents of the OPSS schema None of the tables are really "labelled" (CT_##) If my users and security groups are stored in here, which table would it be? Again, I just want to be able to see which user is assigned to which group quickly. Which…