This is not a consistent issue. Today I was able to create a dataset in under a minute that took a very long time last week. It seems to vary a different times during the day and in prod or non prod. It's inconsistent.

That's great. I will check it out. Thanks, everyone.

Are the Web Services supported in OAC in the cloud?

I was afraid you were going to say that. I don't currently have that available. It's a client install and I don't have admin rights on my laptop so I need the company to create a software package that can be pushed to me. That is a long drawn out process. And it never ends because we have to upgrade regularly. Anyway, not…

Adam, We figured out how to get this to work. It's complicated for us because we have to go through the public LB, which is in a public Subnet. The LB DNS alias is configured using the public IP address. But OAC, which is in a private subnet, cannot reach the public LB via the public IP. We can't change the networking or…

It is a cert issue. But it's kind of complicated. We have OAC and Essbase deployed in private subnets in our VCN. Our internal certs are self-signed. OAC can't connect to the load balancer in the private subnet because of that. So, we have to connect via the public load balancer in place for EPRCS connections. But OAC…

So with the 6.4 update, when you hover over About Oracle Analytics you see that it's version 6.4. Now with the latest update, when you hover over it says March 2022 Update. The email notification said the update is the March 2022 (6.5) Update. Why doesn't the hover info include the version number?

That's what we've been trying but we get a connection error. Failed to save the connection. Invalid connection details were supplied. Please enter the correct details and try again. We're going to the load balancer url.

Thanks. I upvoted your idea.

I posted an idea about this a long time ago. We're just told it's on the roadmap. I was recently told it would be available in 6.4. Not there, yet. I don't understand why this isn't just standard functionality.

OK. Hidden functionality.

This is not the issue. If I run a Analysis that returns, say, 5.200 records (well under the 125,000 records limit for an instance with 1 OCPU) and export that to Excel, I get all 5,200 rows. If I run the Analysis in a Dashboard I get the first 1,000 records, based on the limit in the Analysis settings. If I export to…

This doc just covers uploading an rpd that you already have to OAC. There's no information on actually creating an rpd using the admin tool. And searching for OAC administration tool in My Oracle Support didn't turn anything up, either. Why is it so hard to find this documentation? There's so much documentation and it's so…

No. I didn't. I just found out from another source that I need to copy tnsnames.ora or sqlnet.ora to <AdminTool_path>\<BI_DOMAIN>\config\fmwconfig\bienv\core. That fixed the problem. The doc you referred to says for 12.2.1.4 and higher to copy your tnsnames.ora file…

I will check this out. Thanks a lot!

We will be moving to IDCS. Being able to get users and roles for reporting will be helpful. But we'll also want to know what those roles are allowing a user to do and see. Thanks.

This sounds like something I would want to do. Is this something you can share? Or give me some pointers on how to start? Thanks.

OK. Thanks.

Those docs seem to be for OBIEE. Do they also apply to OAC BI?

I saw this article. The problem I'm having is finding documentation. I followed the link in the article and searched the docs but couldn't find anything. Thanks.