Have a look at OCI Logging, it could give you a way to get what you look for. I believe it's most "details" you can get, don't expect access to those tables when using OAC. Another option could be to just look at what API calls is made by the monitor deliveries page and write a script to get data out of it and then do what…

Adding on Christian comment: migrating the security, mostly when migrating from such an old version to OAS 2023, will anyway result in you losing some admin privileges because of new policies that aren't there in the migration. The forum has such kind of post every 1-2 weeks. Migrating the security from your OBIEE 11g to…

Hi @User_VZB5D , Could you please post a new question in https://community.oracle.com/products/oracleanalytics/categories/obiee ? This is a 6 years old discussion, and you will get more chances to receive helpful replies by posting a new question. Don't forget to provide all the required details: product name and full…

@RanaAshutosh-Oracle , the post is already in the category you mention...

What product (the full name) are you asking about? Because by default no subject area exists, OBIEE is just an analytical platform but is empty. From your question, despite the lack of context, it sounds like you are working on some pre-packaged content that come from some other product (and OBIEE is maybe just an…

@User_9BUCP , No need to post your question again, it has been moved to the Publisher category.

How to make something very different fit into something old. There are generally 2 ways to maintain a kind of backward compatibility: extend the existing to add the new pieces of info needed in new columns, maintaining the existing ("classic") behavior as much as possible, or force things to fit in what is available in a…

Hi, You should ask in a forum that cover the product you are using. That isn't Oracle Analytics Publisher / BIP. Is that a Fusion / Cloud app? If yes, then you have to visit the parallel forum covering those products: https://community.oracle.com/customerconnect . If not, post the full name of your product so that you can…

@JDCal , Your question is about data in a Fusion application, you should ask in the forum that look after that product. BI Publisher is only the technical platform where your query will be executed, not really the topic of your question. Fusion is covered in a parallel forum (the question can't be moved there):…

Hi, You should ask in the forum of that product. BIP doesn't store attachments, therefore you look for data stored by another product than BIP. If it's a Fusion app, those products are covered in a parallel forum: https://community.oracle.com/customerconnect

You have a data modelling issue for that... You have 2 different dates, but want them to behave like they were the same date (that's how a single chart with a single time X axis could work). If you have a time dimension that you connect once to your order date and once to your ship date, you can display amount of sales…

Not answering your question directly, but more thinking at something else that could have helped you. You seem to be doing everything with datasets. Didn't you consider using the semantic model to model your DW tables and expose them to your users? That gives you central control by default, and also comes with simple ways…

Hi @User_27DEY , This is a 6 years old thread, not sure it will really take you anywhere. Post a new question providing your context (product name, exact version), what you are trying to do, what you did so far, what was the result etc.

its own private cloud setup Do you mean the customer has an OCI dedicated region? Keeping it simple: their own Oracle cloud region in-house? In that case the dedicated region should also be able to run OAC (in theory a dedicated region is supposed to offer the same services as public regions).

Hi @User_FD52V , There isn't an absolute rule of how many concurrent users can be handled by 1 OCPU. As @Shantaram-Oracle said, there are a lot of elements to consider. The key point is just to ignore the total number of users because you will definitely not going to by "per user" license (450 users costs a bit more than…

More than the total number of users, you should consider the concurrent users. With your 450 users, you will definitely not adopt a "per user" license but use a OCPU based license. Therefore what matters to define the ideal sizing of your infrastructure is the number of concurrent sessions and an idea of the workload you…

Hi, This is not the right forum for your question, this is only about Oracle Analytics products. Have a look at the developers community forum: https://forums.oracle.com/ords/apexds/domain/dev-community Find the best category and post there. Thanks

Hi Anant, You will need to provide a lot more info than this... Everything is logged in OAS, if your managed server doesn't start, look at the logs of the managed server, then also have a look at the admin server log to see if there is something going back there, and also have a look at the node manager logs.

Those extra info you see in the path is because a DV workbook is a bit the equivalent of a "dashboard": it has "pages" (canvases) and contains visualizations. Each single one generate different queries. Therefore the path identify them in a unique way going deeper than just the workbook itself (a workbook could contains…

As said, the usage tracking doesn't have the "owner" info because it doesn't bring any useful information: that data is focused on the usage of objects, not the properties of the objects. The owner of a catalog object is stored in the catalog, it is one of the many attributes attached to every single catalog object. The…