If you don't set default values for your filters using a variable, then the analysis can't return any data. I imagine (based on a picture you posted in the other thread) that what you call "show an error" is not really an error but the message that the query didn't return any data. It's an informative message saying that…

The main difference is that you have an analysis built on subject areas with LSQL, while OP had a DDR with SQL. And also, this thread has been marked as answered, it will not get much attention because it is considered as closed. Because your case is different, starting with a very different analysis in the first place,…

Well, I believe this can be turned in all the possible ways, it always get back to the basic point of: you disable a (key) feature of OAS providing a lightweight SSO between /analytics and /dv you want /analytics and /dv to behave like if there was SSO between the 2 One exclude the other. You either do 1) and forget 2), or…

Sounds like you want to use a brand new product, OAS, but use it like a 5+ years old product (OBIEE). Nobody should ever use the go-url with nquser and nqpassword for anything else than embedding an analytics page in a 3rd party website. If you do use that for real authentication of your users (each users having their own…

Thanks for the links Steve. I didn’t check if the database foreign key constraints on FILE_ID will do a cascade on delete. If they don’t, you can fully clean up your catalog tables by also deleting the record from the table with the object content, and you should also have a record in the table with the permissions. But…

Hi, I'm guessing here as I didn't give it a try in OAS 2023. There was (is, if you didn't patch) a bug that when you import a snapshot and restore it (that's what you did for your OBIEE 12.2.1.4 migration I believe), some objects could become like "zombies" in the catalog. There are there, but not really there: you can't…

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.