https://community.oracle.com/tech/apps-infra/discussion/4503497/recover-deleted-folder-in-catalog-obiee-12-2-1-4 Short answer: no Longer answer: how should you be able to recover something deleted without using a backup? You would need the "thing" (in this case it's the OBIEE catalog) to have a kind of trash folder just…

You can't, HTML doesn't have conditional logic, it isn't a scripting language. You either have to find another way, or use JS for the job.

And did you enter the same exact password? Because there aren't 10 different password: you set it with the download command and that's it. Nothing else influence that password...

How did you try to open it? And are you having the right versions of all the tools? If you are in offline mode I don't really see why there is even a logon attempt...

If you use that expression to populate the options in a prompt, aren't you overdoing it? Just write the 2 static values in the prompt, don't disturb the server by running an expensive query (because it needs to go down to a data source and do some cooking) to have 2 values back, mainly if you are asking yourself why don't…

https://community.oracle.com/tech/apps-infra/discussion/comment/16846497#Comment_16846497 Sure, go in the OAC forum, in the idea space, https://community.oracle.com/customerconnect/categories/idealab-oracle-analytics-cloud-and-server , and open an idea asking for an equivalent of "act as". The functionality is flagged as…

And not only it's called "Act As", but what you try to do will just not work. Don't try to hack the security implementation of your OBIEE/OAS. There are other ways to "see what the user has access to", well documented and officially supported like Act As, or simply by being in control of your security model. You are…

And my reply will still be the same... You can decide to ignore 95% of what the product is by using a DDR, but at some point you either follow the product rules or just don't use the product.

If you compare '<' or '>' to IS NOT NULL : what is the operator and what is the value? '<' or '>' == IS [NOT] , value == NULL (it isn't exactly that because IS [NOT] NULL is an unary operator, but it gives you an idea of the behavior of your variable and the default value). Your variable is replaced in the query, what does…

How do you imagine this to work? OBIEE isn't a database or a data warehouse able to independently store data forever. Kafka is all about streams: when a consumer read data, the data is read live and gone. So what kind of behavior would you expect? What should OBIEE do exactly? Keeping it simple: OBIEE has a long list of…

https://community.oracle.com/tech/apps-infra/discussion/4502786/could-you-please-tell-me-the-steps-of-obiee-12c-catalog-delpoyment-process You have a backup procedure and not a restore one? There isn't such a thing as a catalog deployment process because it all depends on how you do your backup in the first place: a unique…

How to solve the error? Uninstall everything and restart on a supported OS: https://docs.oracle.com/en/middleware/bi/analytics-server/administer-oas/certification-systems.html The list has a good number of options, but a desktop OS isn't certified for an enterprise server application. If you use a supported OS it just…

Setting the agent to run as a specified (static) user doesn't mean adding new recipients (more than one). And when you do that, it isn't you who needs to be able to find in the catalog the content delivered by the agent, but that user you specified. When you set an agent to run as a specified user, the tool will create a…

Of course you can install it on your laptop, as long as you have enough RAM and CPU. But you can't install it on your desktop Windows 10 or 11. You should only use certified OS for the install (you can search the forum for the long list of people who thought they were above the certification and couldn't make it work...).…

OBIEE works with SQL queries (assuming your source is a database), so how would you solve this one in SQL? You will probably to a subquery or a join, there you go for a solution to this in OBIEE as well. Model is correctly and you will get what you need. If you model it with a self-join in the RPD you can have a flag…

If your source column has a time component, in your SQL query do a TRUNC() on it. It will remove the time component and DV will maybe stop doing timezone manipulatons on something not having a time.

Hi, Isn't it a timezone thing? What you see as date is maybe a full date & time field, and DV does apply some timezone offset to translate it into your own timezone. If you were to see the time part of the field, it would be more obvious, but when seeing only the date you maybe see it 1 day later before it did add a bunch…

The navigation passing parameters works well even if you have a CASE WHEN formula or whatever else in the target analysis. Of course the filter should still be on the column itself, even if it isn't part of the selection criteria. The navigation URL is quite simple (also documented in the documentation) ?Go => navigate to…

You have to write the URL with the filter expression yourself because of using 2 different columns. https://datacadamia.com/dat/obiee/obips/url_filter Here you can see the format of passing a filter to an analysis. The receiving analysis can use "is prompted", because it will not see the value comes from a different column…

https://community.oracle.com/tech/apps-infra/discussion/comment/16844645#Comment_16844645 If you do as described above, you get what you are after: you have a LOCATE function, you have basic arithmetic operators, you have the SUBSTRING function. With these you get what you want, it's all about simple logical formulas. Get…