Maybe these will help you what you're looking for https://www.enginatics.com/reports/gl-trial-balance-detail/ https://erp-integrations.com/2017/01/23/query-to-check-gl-period-begining-balances-with-previous-period-ending-balancecompare-period1_end_balance-with-period2_begin_balance/…

Nice work and useful workaround for this scenario

Interesting suggestion and would be useful feature. up voted

Also check out https://community.oracle.com/products/oracleanalytics/kb/articles/32-product-roadmaps

This YouTube video might help https://www.youtube.com/watch?v=A5r8EYCH8CI

The problem mights be with the quotes around the number. Try something like this CASE WHEN "HCM - Workforce Core"."Legal Employer"."Legal Employer Name" = 'Legal Employer' THEN CASE WHEN "HCM - Workforce Core"."Time"."Month" = '2026/01' THEN 184.0 WHEN "HCM - Workforce Core"."Time"."Month" = '2026/02' THEN 188.0 WHEN "HCM…

While a lot of work has been done to the website, I do feel certain areas need more work and to make certain things a bit more obvious to the new user of the tools/platforms as well as for the experienced user. Some analytics on the number of page views should help you identify part of the site that are getting the most…

try wrapping your parameter in a TO_DATETIME or CAST function within the filter expression to explicitly tell the engine the data type. For example, EXTRACTMONTH(CAST(parameter AS DATE))

You should have posted in the OAC related forum https://community.oracle.com/products/oracleanalytics/categories/oac-oas I believe this forum will be used for the OCI AI Services https://www.oracle.com/europe/artificial-intelligence/ai-services/

Also check out this post https://www.ateam-oracle.com/methods-to-extract-audit-monitoring-data-from-fusion-applications

try DELETE https://<your-oac-host>/api/tcm/v1/dbcache. or you can execute this from your VM using a standard cURL command. curl -i -X DELETE -H "X-ID-TENANT-NAME: <your-tenant-id>" -u <user>:<password> https://<your-oac-host>/api/tcm/v1/dbcache

Try following these examples https://docs.oracle.com/en-us/iaas/Content/Identity/api-getstarted/Exporting.htm https://docs.oracle.com/en/cloud/paas/analytics-cloud/acabi/export-data-csv-and-tab-delimited-files-text.html…

Check Internal Port and Hostname Configuration If the service is running but still refusing connections, there may be a mismatch in how the components identify each other post-migration. • instanceconfig.xml: Verify that the Presentation Services configuration points to the correct hostname and port for the Scheduler. •…

The loss of precision (e.g., 145677.755 appearing as 145677.00) following a migration to an Oracle Analytics Server (OAS) instance with a Databricks backend is a recognized challenge related to how the BI Server interprets numerical data types across different database drivers. While individual column formulas can be…

To generate a direct link to your Oracle Analytics Cloud (OAC) workbook that passes a specific parameter value, you can use the syntax demonstrated in your example or the positional parameter syntax described in the sources. Direct URL Construction Based on the values provided, you have two primary methods to construct the…

"TRIM" or "CAST" Trick Force the BI Server to evaluate the level value as a clean string. This is the most common fix for level-based columns that appear to "ignore" logic:• CASE WHEN TRIM("Parent Account 9") WHEN 'REV' THEN 1 ... CASE WHEN CAST("Parent Account 9" AS VARCHAR(10)) WHEN 'REV' THEN 1 ...

Makes sense given the product overlaps

Interesting data set to visualize and share, although the text size is a little small for me, maybe it's my old eyes :-)

MOS has been a challenge to use over the last couple of weeks in December. Some work ongoing to make improvements which are starting to come through

Interesting visualization and use of different viz. For me, coler scaling to needed help with reading the boxes.