You maybe want to speak with product management about your decision to disable lightweight SSO. A PM told me explicitly that in OAS lightweight SSO should not be disabled because it does prevent OAS from working correctly (not like OBIEE 12c when it was fine to disable it). That it isn't expected to run OAS with disabled…

Good spot! The XDO is one of those catalog objects that while showing as "object" in the UI, is physically a folder containing a number of files (there are a few others being like that). The XDO folder can contains configuration, a picture with the preview of the report, RTF templates etc. I believe one of the webservice…

Hi @Muthu S , The deleteItem method definitely exists in the WebCatalogService (and was there already many years ago, it isn't something new). I don't know the full call you are doing, but because you said that by creating a shortcut (a catalog shortcut) you can successfully delete the shortcut, I would say your call…

Hi @Sa_De_Or , would you mind posting a new question with all the context information related to your issue? This thread was answered and your question isn't really the same thing (your is an analysis based on a subject area of some kind, while the original question here was about a DDR analysis). When you ask the new…

Hi, Did you try using it? The wording of that sentence is maybe poor and misleading: a "presentation level" is a kind of object, it's the levels of an hierarchy exposed in the presentation layer. Therefore I read it like if you can't control visibility on the hierarchies levels because it isn't implemented yet. But it…

Hi, If you want to know what your users are executing (all the queries = data they see in a way or another), setup usage tracking and you get all the details. Or maybe you look for something else? In that case you could expand on what you mean by "know what data are fetching by particular user" and how that related to act…

Hi, You are creating a filter based on an expression, but your expression isn't a filter at all, just a value. A filter should be a condition: something = something else, something < something else, etc. In your case you are just defining one part of the filter, a value. Now add the operator and the other part of the…

Adding to Sumanth message, there is no replacement VM or newer version released after SA607. There are demo/display instances of OAC available with a number of example workbooks deployed to give an idea of what is possible. And with OAC only requiring 3 clicks to create an instance, there wasn't a need anymore for a VM…

You could just use the catalog manager for this, by archiving on one side, and unarchiving on the other side. Or you can use the webservice (which is what the catalog manager does anyway). Catalog manager has a fully CLI, therefore you can automate it quite easily. Both options require that you use an account having…

Just a comment: it maybe take 5 minutes to ask that question (3 to find the forum, 1 to find the right category, 10 seconds to write a title without any content [that's not a good quality post!] and 50 seconds to post it), and it would have taken about the same time to open a model in semantic modeler and try to add a…

If your API always requires a body, then you should consider posting an idea requesting the feature (or upvote an existing one if already there). The REST API source is quite “new”, added only recently (1 year maybe as preview first?). Therefore it is a simple one for now. As workaround, in the meantime, can’t you use a…

Hi, As far as I know, it is not possible. The REST API connection doesn't expect any "body" content, just the URL of the REST APIs that you can retrieve, passing parameters in the URL itself at best. Your endpoint isn't really a "static" API, it's a fully dynamic one where you can dynamically query various things passing…

Hi, You could use the TOPN function and apply it by "Service Type", because only 'Service' has more than 10, the other values of "Service Type" will always shows all the "Service Description". Something like RANK(Total by Service Type) < 11if you want it as explicit filter. You can also look at TOPN, which will do…

You could use another dataset that will contains all the parameters you need, and then you join it with your data in the dataflow and by using join conditions you can "filter" your data based on that variable value you have in the parameters dataset.

You need a proper "time dimension", a source of data with all the days, and then join it to your current data to generate the status of each record at any point in time. There isn't a thing doing time based trends out of a line with start-end or open-close, you need to transform your data into a row per each record and…

Hi, You should consider providing more information, more context, about your question. Keep in mind that what is probably obvious for you because you have been focusing on it for some time, is unknown to everybody else here in the forum. Starts by describing what product (and version) you were using (from where you did…

existing application roles from production What is "production" for you? A product name and version would help in understanding where your application roles are from. In OAC your application roles would be imported from another OAC via the BAR you will deploy. I assume your "production" is something else than an OAC…

It's fairly obvious, and expected, to have new features and changes in a product between versions. Also keep in mind OAS 5.9 is not supported anymore: it was released in 2021 and support ended in spring 2023. Sounds like you have another reason to upgrade: have a supported environment, and having access to the new features…

Hi, Your question is about a move to cloud of your EPM solutions, not Oracle Analytics. This forum is only about Oracle Analytics. You should ask in a forum about EPM/FDMEE products. I can't remember off the top of my head where they are, have a look in the following forums: https://community.oracle.com/customerconnect…

@Mr.Bai , This forum is only for Oracle Analytics products. For general Oracle Cloud questions, you should go to https://forums.oracle.com/ords/apexds/domain/dev-community and find the best matching category (or, as suggested above, handle it with Oracle Support).