Quite sure Ram is right, and the linked document tells you why it's happening: the product does what it is instructed to do. If your model says a column can be null, it does make sense that NULL is an option in a prompt, but NULL is not really a normal value, therefore it has to be handled in a special way, and that's what…

Hi @User_27SWQ , Welcome to the Oracle Analytics community. It looks like your post content is gone missing somehow, and only a title has been posted. Could you provide some more details? What version of OBIEE you came from? What version of OAS have you migrated to? How was the migration performed? Is the weblogic the only…

Hi, Welcome to the forum, but you are in the wrong place… OLAP is a database feature, not an Oracle Analytics product. Oracle Database is covered in a number of other forums, for example it has a number of categories in https://forums.oracle.com/ords/apexds/domain/dev-community . You could try to visit that forum, look at…

That confirms you don't have OAS as a product, but an embedded version of an Oracle Analytics product. And it also confirms the previous suggestions that you should work on it from the Taleo side because it's their choice what they allow you to use and how.

I mean the SOAP API that is being in the product for 10+ years. It was there already in OBIEE 11g, 12c and it is still there in OAS and OAC. It isn't a Publisher API. It does cover various service in the product, including the catalog. The link I posted above is for the data structure, and…

Hi, Do you have a value for "list" in your permissions? Historically the "execute" ACL had a double meaning: execute on objects supporting that, or traverse, for a directory for example, When I look at the doc you linked, the permission attributes, there is the "list" permission that I can't really map to the historical…

Is your OAS 2025 installed as standalone and point to Taleo as a source? Or is that an "embedded" version, and therefore it isn't really OAS? The screenshot is "classic" but your user has no permission to create anything there, if you have a full OAS try going to /dv to see if you have more options. Maybe you have some…

Hi, I would say that what you see is correct, even if not what you expected. You are facing a pre vs post aggregation behaviour: SUM(ABS(quantity)) <> ABS(SUM(quantity)). Is this a measure you need often? If yes, I would definitely add the ABS in the column mapping between the physical and the logical layer in the RPD, and…

Hi, While not sure I got your requirement correctly, it isn't something possible: if a user is allowed to manage permissions on an object in the catalog, you can't limit the security objects it can control the permissions for. Once a user has access to manage permissions on the catalog folder, they can add or remove any…

@User_A81NX , Maybe worth knowing that OAS 2025 has been released today. While we can hope it has been well tested, I would still wait at least some weeks before upgrading an environment to it (I would like the Oracle support time for OAS versions to be extended by 1-2 months after the release of a new version, just to…

The question isn't an OAC question, but an Oracle database question: OAC doesn't do anything the database user isn't allowed to do. OAC doesn't have any special access or extra features to display things the user itself can't see in the database. If you didn't configure the database user wrongly, it can see the other…

Would you like to be able to use the "Dashboard Filters" visualization? (it gives some extra controls on how the filters look like on screen) What could maybe be tested is to set parameters from a dashboard filter visualization and then use the parameter in the workbook pinned filters. This would give you a second GUI…

In addition to the above answer, so far OAS doesn't have this feature. It has been introduced in OAC not too long ago and therefore it is only an OAC feature for now (I don't know if it is in any OAC now or there is still a limitation on instances with more than a minimum number of OCPU or some regions). When the list of…

Hi Ajinkya, I'm maybe missing something obvious here, but … did you try pinning filters on top of your workbook? When you pin them, they applies in all canvases in your workbook.

@JobDeLuna , MOS (support.oracle.com) is only accessible to users with a paid support contract. If this isn't your case, then you can't access MOS content (and it can't be posted here publicly because it's a paid-content). If you have a CSI, link it with your Oracle Account to have access to MOS.

Hi, You can easily make your prompt a multi-select, having a single prompt with checkboxes just like your Power BI screenshot. The challenge is then that you need to have enough placeholder columns in your visualization to handle the various values. It is not possible to have a single calculation handling them all, you…

Hi Evelina, Welcome to the Oracle Analytics community. By your post I understand you don't have Fusion Analytics Warehouse (now called Fusion Data Intelligence), therefore you look for pre-delivered reports in your HCM Fusion application without any extra product like FDI (FAW)? If this is the case, you should consider…

Ok, my bad, apparently the SMTP settings in OAS are still (up to 2024) in the EM Fusion Middleware Control (OAC is in DV console, and OAS 2025 could also be the same). https://docs.oracle.com/en/middleware/bi/analytics-server/administer-oas/configure-email-and-agents.html#OASSG-GUID-4693A721-2030-4244-9157-83A199AF66A0 By…

@Tony_OAS_Apex_User , if you have 2 minutes, post an idea in https://community.oracle.com/products/oracleanalytics/categories/idealab-oracle-analytics-cloud-server about adding this feature. As it should not be extremely complicated, it could be added to the product.

Hi @Vrinda Choraria , by taking a shortcut in calculating your delta between 2 periods, you now got yourself into difficulty with the % calculation. What is posted above would work if you had a column in your criteria with the delta between your 2 months. But you are using a calculate item with a "relative" expression on…