If I correctly understood the question these two columns come from Purchasing transactional tables, but are secured by Procurement Data Security, NOT by AP, AR, or SLA privileges. The user’s custom role does not have the required data security policies, so the measures return blank (not even 0 just empty), Hope it helps!

If the user is a normal employee or HR person without special "shared access", then: No rows will exist for them The query returns no data This is expected behavior This table usually remains empty unless your organization has turned on Workforce Sharing. The Share Data Access task adds rows to PER_SHARE_INFORMATION, and…

Most likely security issue, please check if the other user has access to the subject areas, security contexts, or data roles required by the DM.

I believe there is a Subject Area on Security - Users. If yes, pls explore along with Suppliers Subject Area. Hope it helps!

As per my understanding, Shipment subject area and Order Base Line subject area cannot be mixed directly unless they are logically joined in the RPD (repository). I think we might need to check the logical source for these and check if there is a common key to logically join these. Hope it helps!

Without the access, it is not going to be easy to answer. I am hoping you have already looked at this doc https://docs.oracle.com/en/middleware/bi/analytics-server/user-oas/use-url-navigation-data-action-pass-parameter-values.html

Can you try to re-upload or re-publish the Spreadsheet Dataset in Prod? You might need to delete the broken dataset in Prod.

These are the best questions that get self-answered with in few minutes.

Thanks.

There is no 1-to-1 table mapping between these schemas. This is because: Data is extracted, transformed, and loaded (ETL) via Oracle’s OTM Analytics ETL / ODI mappings. The HDOWNER schema is a star-schema warehouse, so data is denormalized and reorganized. Subject Areas in OAC (Shipment, Order, Freight, etc.) use…

When you set up Oracle Analytics Cloud, you select an update cycle that's appropriate for your environment (either Early or Regular ). You can review your selection from the Instance Details page. Please refer , following doc to further look at the steps to verify the update cycle.…

It should behave on macOS the same way as Windows unless it is documented as a known issue. Please log a SR with Oracle Support. Thanks

Thanks for considering the idea and putting in the Planned Phase.

Thanks for considering the idea and putting in the next state, appreciate it.

Thanks for updating and putting in the Planned Phase. Do we know the timeline for this phase? Reason for asking is to set up the right expectations for the future client conversations.

Did you try @?

So just to confirm, Copy/Paste work from the Right Click but not from Keyboard shortcuts.

It's a while I have looked at it, but can you see if it there is an option to create a calculated field. If yes, then create it by checking value is 0 or not. Now you can use this field as a filter. Hope it helps!

Please explore using session variables that evaluate dynamically for the users.

Yes, it is not currently supported and vote for the idea as mentioned above. As an alternative, consider using an external system / ETL tool that does support pivot, then bring the transformed data into OAC.