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…

What's really odd is that when you export a workbook, you have the option to "not include Connection information" but then you do the import and it's clearly being included regardless of what you pick on that screen. @Bret Grinslade - Oracle Analytics-Oracle Any updates or comments on this behavior?

I know this an old item, but what if you have a semantic model in Dev and you want to promote to a higher environment? It seems like then your connection information would potentially break as well? Haven't tried the semantic modeler yet to see if this is the case. But the overwriting the connection when importing…

Has anyone come up with any workarounds for these issues?

I was able to add the group using the WLST commands @Gianni Ceresa provided. That will probably need to be the fix while we start to think about a possible alternative for our group management. Thanks!

Thanks yes, going to get the WLST going, try the command, and see what happens. I haven't had to spend very much time if any in the WLST so this be a slight lift for me. Need to finish that Weblogic training ;)

@SteveF-Oracle Am not able to add groups to roles in OAS2022 Console either, but am able to do so in EM

@Gianni Ceresa I guess the big question I'm seeing here… Do I have run that for every single role we have, or is there a global setting to set the force validation to be false rather than true?