@Indra Sardana-Oracle and a screenshot, because as said: it works perfectly as designed in the example I just did on a new instance. What is the behavior you are observing (with a picture or detailed example)? How did you build your analysis? What behavior were you expecting instead? There are at least 10 possible expected…

Slightly confusing to get where you are doing what exactly... You say report, which means BI Publisher, but you have a tag "analysis" which means "classic" Oracle Analytics Answers. Can you clarify this point? Where are you setting sorting? As a criteria condition or in the view? Tried right now, works as expected. You…

@SaurabhJaiswal-Oracle , keeping it simple what you asked never existed as a feature in the product, and not even worth raising an ER for it because it doesn't really fit in with the architecture of the product. Usage tracking is a technical feature, Oracle Analytics is still a single-instance product (they did try adding…

The product never supported that. They can setup an ETL process doing the job: reading usage tracking from the central place and pushing the relevant rows around to the various databases. Or more simply just sending the whole content. Can be batch based or near real-time with the the various options the various ETL tools…

What would be the need? Do you have the usage tracking tables split in 2 different databases? Or do you expect "double" insert in 2 different places in parallel duplicating all the rows? Quite sure that for usage tracking the connection pool has always been one, even in OBIEE 10g, 11g and 12c.

As there isn't a function doing that in one step, you need to get there by some logical operations. There is a function calculating the number of days between 2 dates, that same function can give you also the number of weeks between 2 dates (or you can take the days / 7). You then only need to adjust things a bit to cover…

Oracle Sans is the default font with the Redwood theme, now the question is when Redwood theme has been added to OAC. Based on https://docs.oracle.com/en/cloud/paas/analytics-cloud/acswn/index.html, Redwood was added as an option you could enable in OAC 6.1, while it switched to the default theme in OAC 6.4. The Alta theme…

Give me a simple universal definition of a "business day" and I give you a simple function for it. Every single business has a personal definition of "business day": different countries work different days, same country but different fields work different days, and it's better to not even talk about holidays (I'm in…

You asked the same in the MOSC forum and got answers (including one you accepted as correct). https://community.oracle.com/mosc/discussion/4512484/can-a-dv-consumer-access-a-dv-project-in-any-shared-folder-or-would-s-he-need-access-permissions-fo Feel free to close this thread.

Hi Deepa, You can do the same thing Michal is doing in the database for OAC as well, but of course not via SQL. You can either export a snapshot as BAR of your OAC and work on it as it comes with the whole catalog and all the datasets (if you selected them). The BAR can be processed by a script to do exactly what you ask.…

You can do it in your browser, you can do it by script as well. There isn't a public documented API for it (it's coming), so you have to performs the same actions as you do in the browser. Technically doable but fully hand-made code, to get a valid session first and call the needed URLs to create the snapshot first and…

https://medium.com/@insight2action/oracle-analytics-embedding-tech-talk-b2f2cb0c1962 Or also https://acesathome.com/sessions/2020/05/06/mike-durran-embedding-with-oracle-analytics-cloud/

I assume the offline RPD has been deployed and therefore your changes with the variable exists online, right? Did you try setting a default value for your variable? Does your query return a value for every single user? What product are you using exactly?

Sounds like this thread is dead as you asked the same in https://cloudcustomerconnect.oracle.com/posts/c06ff1d46e .

Hi, Any chance you could be a bit more precise? Do you mean DV projects or the classic analysis? OAC is this 2-products-in-1. Classic analysis come with a bunch of webservice available, more often people just want the data and not the charts, but there is a service for that as well. DV projects are a lot simpler to embed…

Mike Durran, PM Oracle, did a webinar yesterday exactly on this topic. Showing how you can integrate DV projects in other applications or webpages, including how to deal with security (there are many options). The slides and recordings are still not online, will post a link (if I don't forget) once they will be available.…

You don't have the permissions. Also the fact you aren't allowed to click on "Delete" point to a permission issue: you can probably consume it (open) but not edit (and renaming is editing or new+delete).

Google says a "lakhs" is supposed to be 100'000, so your dataset is supposed to have 1,5 millions rows? OAC definitely support that and even bigger, but depends on the resources of your OAC instance. As you can see…

It's available now: https://www.oracle.com/middleware/technologies/oracle-data-visualization-desktop.html Sending to eDelivery for the download this time and they renamed the app once installed as the "about" shows 'Analytics Desktop' as name now.

As said by others, Catalog Manager (the tool installed with the Admin tool) can get you that kind of list. If you want something more "scriptable" you can run Catalog Manager by command line to get the same extract as the UI, or call the OBIEE webcatalog webservice and get the whole list of what is into your catalog (and…