@Kevin M Storrie , Is yours a Publisher question? Double posting is something that isn't well accepted in the forum, ideally this question should have been moved to the right category, but you weren't informed correctly about it. Now the question is to figure out if yours is a purely Publisher question (and therefore the…

If what you expect is the analysis to run without any filter the first time you open the page (beware that this could generate a very slow query that everybody execute all the time before to start filtering), you need to add some more logic to the filters of the analysis to handle the case when the variables aren't set (=…

Because many of you seem to relate this issue with a recent update of Office 365, there is maybe not a quick-fix (because it could be something that Microsoft changed without really telling anything to Oracle). Did somebody raise a SR? That's the fastest way to report a problem that could require Oracle to release a fix of…

Hi, You need to start from a date, being a day in the month and year you need to know the number of days (because February has different days depending on the year). Then, what you can do is to add 1 month to that date and remove the number of day of the month of your date and get the number of day for the date you got (it…

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…