Hi, Sorry for not giving more details and an example. Let's try now. Let say I have an analysis that is a not really yours but you will probably easily match it with your case. I have a simple filter of a column = a presentation variable. To replace that filter with the logic mentioned in previous replies, I edit the…

Hi, That is a filter, it would go in your analysis in the filters' section. It currently has 8 filters with a AND condition (at least based on the screenshot posted above). Each one of those filters that require to be applied only if it has a value needs to be replaced with the logical expression posted above as example.…

Hi, Any chance that you can open the log file (the path is right there in your screenshot) and post back the full error message? The screenshot only show part of it, therefore nothing can really be said. Also: what linux distribution and version are you installing on? On a different topic: this OAS version will still have…

Hi @ashraf817 , Because you are using Oracle Analytics Desktop, you don't have access to the semantic model (semantic model = RPD). In your case, how about not doing the average calculation in the database? Because that average is the one giving you issues as you did calculate at a fixed level (that's what the database can…

Double posting (not your fault @Farah Alajou , you have been told to so…), closing this

@User_0KWXQ , you should identify yourself as an Oracle employee by defining your profile name (you must have internal rules on the usage of public forums). Double posting (the thread had to be moved instead of telling OP to post it again). Closing this one.

Hi, My guess is that you should ask your IT department for the printer details, because those are the details of a real printer.

And while this isn't going to help you much, this seems to be a topic posted every few months in all kind of forums (some for Fusion, some for Publisher, some for OBIA). There seems to have been SRs raised, leading to ERs, but no idea if they ever got implemented. Apparently it goes down to: "you can get XLSX files if you…

I can understand the frustration of just being moved left to right without replies… I actually can't open the post you did 2 years (I have access denied, some parts of that forum are weirdly restricted if you don't signup to the newsletter of that product or things like that), therefore I couldn't see what it was about.…

@user1748805 , delete your browser's temp files/cookies and try again. After some time, some of the cookies get too big and the portal does refuse the request with the error you see: open the browser's dev tool extension when you are on the page with the error, go to "Application", "Cookie" and delete the cookies for the…

@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…