Typically, OAS releases trail major OAC updates by 6–12 months, and only include features that are cloud-independent. Keep an eye on blog updates or webinars from Oracle Analytics product management or leadership

Please share your approach we also need it.

It is tricky , you might need to work with ORacle Support. Also, Instead of using the plain P0/P1/P2/P3 format (Go URL filters), you should pass the filter as a presentation variable, which can be referenced directly inside the analysis including conditional formats.

Can you create a derived column in In your data model / dataset, Example: CASE WHEN TRUNC("Your_Date_Column") = TRUNC(CURRENT_DATE) THEN 'Y' ELSE 'N' END AS Is_Today Now add this column to your canvas. Create a hidden filter Is_Today = 'Y' on to limit data to today’s date. Leave the List Filter for date visible, users can…

Did not get the question… What is the issue here?

Not sure if it will work for you but try by making your canvas dimensions match this aspect ratio as closely as possible. try setting canvas width = 816px and height = 1056px for US Letter. If you want landscape orientation, flip the values (width = 1056px, height = 816px).

Can you try this SQL in BIP (if available in your data model): SELECT ul.USER_NAME, ul.EMAIL_ADDRESS, ul.START_DATE, lh.LOGIN_DATE, lh.LOGOUT_DATE, lh.SESSION_ID, lh.CLIENT_HOST_NAME, lh.CLIENT_IP_ADDRESS, lh.LOGIN_TYPE -- e.g., UI, WebService FROM FND_USER ul JOIN FND_LOGIN_HISTORY lh ON ul.USER_ID = lh.USER_ID WHERE…

No experience with Snowflake but see if below works for you: Add an 'All' option with a null or special value, like '@ALL @' . Display Value Return Value All @ALL @ WHERE (:PARAMETER_NAME = '@ALL @' OR FIELD IN (:PARAMETER_NAME)) This makes it explicit: when @ALL @ is selected , skip filtering. I think this pattern is…

You can start with following query SELECT dept.ORGANIZATION_NAME AS DEPARTMENT_NAME, bu.BUSINESS_UNIT_NAME, le.NAME AS LEGAL_ENTITY_NAME, le.LEGAL_ENTITY_IDENTIFIER FROM HR_ORGANIZATION_UNITS dept JOIN PER_BUSINESS_UNIT_ORGS buo ON dept.ORGANIZATION_ID = buo.ORGANIZATION_ID JOIN FUN_BUSINESS_UNITS bu ON bu.BU_ID =…

It is a good question. For quick turnaround, consider taking help from Oracle Support by logging a SR.

It is tricky but see if you can make it work by using Payables subject areas like: Payables Invoices – Transactions Real Time Payables Payments – Transactions Real Time Procurement – Spend From these subject areas, you can get: Supplier Name Invoice Amounts (debited from AP) Payments GL distribution details (via invoice…

Please confirm if this question still needs answer otherwise consider closing it as Accepted Answer. Thanks

It is a good idea, but you need to consider creating ADW pipeline and obviously need to consider the cost as well. You can explore creating a Custom Object in ERP and SCM domain using Application Composer and it will give you an option to populate the data within Fusion and it will be available within OTBI Custom Subject…

Sometimes OTBI needs a metadata refresh. If you still don't see the DFF: Log out and back in. Navigator → Tools → Reports and Analytics Click on "Browse Catalog" Go to Administration → Reload Files and Metadata Also, it is worth checking …. Was the DFF segment deployed to the correct context (e.g., global or specific)? Are…

Checklist Real Time SA is particularly isolated and not directly joinable to other SAs unless you structure it specifically. One option to try is Start from "Worker Assignment Real Time" (base SA). Add fields from "Goal Status Overview Real Time". Then try adding only specific fields from "Checklist Real Time" – not the…

As per Analytics community guidelines, please accept the answer so that this post can be considered Closed and future community members can refer it accordingly.

Can you share the recording for the audience who cannot attend in person?

You have a valid point, please consider logging an idea in the Idea Lab.

If it is not showing up in the LOV then it is not available for now, you can consider logging an idea in the SCM Idea Lab.

If you have checked PVOs and did not find anything then try building a small BIP report that selects from the needed tables (with appropriate security filters), schedule it to output a flat file (CSV/Excel), and load that output into your ETL pipeline.