Hi, Did you enter your domain where you are trying to embed the OAS page in DV > Console > Safe Domains as accepted for embedding? This is from OAS 2024 (aka 7.6), can't remember if that page was already like that in OAS 2023 (7.0). You can read some more details in the doc: PS: don't enable it for all domains, enter the…

Hi @Betty.ca , That "search" feature is actually a "virtual" feature that does loop over all objects of the catalog, apply your filter criteria on every single one and see if it matches or not. There isn't a webservice method for search (the Catalog Manager is a GUI on top of the catalog webservice), there isn't a search…

Do not mix the 2 key concepts: a calculation and a filter. If you want to filter YEAR = YEAR( your parameter ), then do this as a filter: it can be a filter in the workbook, it can be a filter in the visualization where you need it. Then if you need to extract the month from a date, you can do that with a calculation. But…

Hi, What should that calculation return for records with a date in 2023? You could use CASE WHEN "Year" = '2024' THEN MONTH("FAW_DATE") END But that calculation will return NULL for any other date not matching the year = 2024.

Hi, I believe BICC questions, mostly when about default PVOs, should be asked in forums looking after Fusion application as that's the one providing BICC and the PVOs. They are covered in a parallel forum: Look at the many categories available there and ask in the one that you believe is the most appropriate (source…

Hi, Our API Gateway does not allow us to configure variables/rules containing the %2F characters. I see what you are saying, but did you try asking your API Gateway provider to just support %2F (which is a perfectly valid component of a URL) instead of asking Oracle to rewrite the Publisher API? Because it isn't a…

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…