"I wouldn't work on separate repositories for your 4 environments, because you kind of lose the benefits of git. You could use branches for your environments if needed, or tags as well to identify what make a release of all the set of features you then want to push to prod etc." Thanks, this is a more specific answer to my…

Thanks. I saw that blog. Unless I'm glossing over something, it doesn't really answer my questions. We have 4 OAS instances - Dev, Test, QA and Prod I'm more interested in how the repos are handled in this multi-stage full deployment lifecycle, not just a single server for all development, which seems to be what this is…

Yea, I tried "cleaning up" the aliases just now, and when I get to the end, I attempt to validate the certificate chain and it says no certificates found - which is pretty annoying. I'll try it with just leaving new aliases with the old ones and see how that goes. Possibly a move to OAC in the future so hopefully this…

Okay, it sounds like you are making copies of your keystores before import new certs with new aliases? Then you just swap in the new updated keystores and clean up the aliases when you are ready? To this point, I usually just end up starting over with brand new keystores + csr's then swap them in when I'm ready. Seems to…

Are you the owner of the connection you are trying to access? If not, have you been granted permissions to access the connection you are looking to use? Assuming there already connections that have been created that you want to use. If not, you will need to create them first and make sure appropriate permissions are…

Disregard. I figured out this browser caching, not in the application.

I don't have ODT.

Will keep that in mind re: BIPLATFORM. We need that for an audit trail on our reporting. We get requests for usage information all of the time.

I'm hoping we can get to OAC within the next year. No more server maintenance and patching please :)

Also, I think the workaround/takeaway for us is that we need to have connection objects that need to be fully available and not overwritten vs connection objects that are more volatile and will be overwritten when exporting/importing. Not idea, but sounds reasonable. So if have a Production Oracle data warehouse called…

@Dhaval Parikh Stantec Doesn't sound like there is anything else to add to this so feel free to close this. Thanks for following up!

@Gianni Ceresa Well, I appreciate your response as always, and confirming the behavior I was seeing with this. Hopefully someone can take this feedback and report it back to the product teams for consideration. In summary, it really just sounds like this feature was not intended for database connections… probably just…

I think this is part or the whole of the problem. When we import Snapshot data from older instances of OBIEE or OAS, several of the pre-defined application roles are getting overwritten and replaced by what's in prior installations/versions of OAS. It's entirely possible we had to create the DV roles manually, and just…

Thanks, as always, @Gianni Ceresa for your helpful insight. I don't see us rolling out the data visualization piece of OAS to our wider user base, so we're good there. This is mostly for a small group of analysts who want to do Tableau/PBI style analysis. We'll probably just give access on a case by case basis. Most of our…

Thanks for this Arjun! Yes, this is what we want to do, but for some reason, after clicking on Export → File, even for a simple table, there are no format options in the dialog box. This is unusual, right? Regards, Chad

I know this is over a year late, but I want to put in word of support for Manu. We are currently facing the same issue. This method used to work for us in in OBIEE versions and earlier. Not sure if it ever worked in OAS versions or not to be honest. Clear OAC cache automatically. One of the requirements that customers… |…

Yea, I was wondering the same thing. Currently in our analysis we see this: I'm not sure it likes the space in the "Cache Purge" connection pool name, so I shortened it to "CachePurge". When I do so and revalidate, the columns you see there go away. Hence, the expected 0 and got 2 error above.

I also noticed we have this in our odbc.ini file. I don't know if anything here needs to updated or not.

Also, if we did have productions for Prod/Dev versions of the same environment, that would require opening up firewalls that we currently do not allow to happen in our systems. For us, pointing a Dev environment to a prod a Production environment is a very big no-no.

I think the only way around this is to manage multiple connections on each server. So for instance, if I have a dev database and a prod database, I would need the dev workbook to already point to production database connection before I migrated the workbook. However, if I began work on dev database, I'm not sure that you…