Wayne Van Sluys

to use shared values for prompt you need to use parameters in the filter. There is no way to join EPM data to ADW data in the workbook. Thinking outside of the box…Not sure if creating a Subject Area on the EPM connection would get you closer. You can create Datasets from the Subject Areas and maybe then join them for…

in EPM Cloud data(RealTime) and ADW data validation through OAC Comment by Wayne Van Sluys Feb 26, 2026 8:34PM

Use Data Flow and create a dataset

in Building a union report option via subject area is missing OAC DV. Comment by Wayne Van Sluys Feb 24, 2026 10:09PM

Would this work for you

in In Oracle DV , Unable to repeat the values in Pivot table. All the columns are suppressed by default Comment by Wayne Van Sluys Feb 24, 2026 10:08PM

Submit to Idea Lab https://community.oracle.com/products/oracleanalytics/categories/ideas

in In Oracle DV , Unable to repeat the values in Pivot table. All the columns are suppressed by default Comment by Wayne Van Sluys Feb 24, 2026 9:58PM

Quite easily

in Need to unpivot a dataset in a tabular format in DV workbook Comment by Wayne Van Sluys Feb 24, 2026 9:55PM

https://community.oracle.com/products/oracleanalytics/discussion/comment/73868#Comment_73868 I am asking about regular OAC not the OAC that comes with FDI

in Workbook Check-up Tool Comment by Wayne Van Sluys Jan 21, 2026 3:55PM

Nice feature in FDI. I do not see it available in OAC. Do i need to download and install an extension?

in Workbook Check-up Tool Comment by Wayne Van Sluys Jan 19, 2026 10:17PM

try multiplying by 1.0

in OBIEE Dashboard Gauge not displaying decimals for custom formulas. Any work-around? Comment by Wayne Van Sluys Dec 8, 2025 4:44PM

What does your formula look like?

in OBIEE Dashboard Gauge not displaying decimals for custom formulas. Any work-around? Comment by Wayne Van Sluys Dec 8, 2025 4:10PM

Check this posted thread and see if it works for you https://community.oracle.com/products/oracleanalytics/discussion/24609/using-session-variables-in-data-filters-for-datasets-oac#latest

in Row Level Filtering/Security at the Datasource level Comment by Wayne Van Sluys Nov 13, 2025 8:57PM

Check the settings This makes values in 1 prompt limited by another

in OAC-Dashboard Filter - Values removal on selection of other filter values Issue Comment by Wayne Van Sluys Nov 11, 2025 7:30PM

Yes, though you cannot stack in autofit.

in Conditional Visibility of Filters based on selected Parameter Value Comment by Wayne Van Sluys Oct 22, 2025 8:27PM

Use Freeform layout. Then use Visibility on sections tied to parameter. You can stack the filters

in Conditional Visibility of Filters based on selected Parameter Value Comment by Wayne Van Sluys Oct 22, 2025 3:55PM

No way that I am aware of. though you can look at the developer tab for the dataset

in Is there a way to export the metadata for a dataset? Comment by Wayne Van Sluys Oct 21, 2025 8:19PM

Here is SR # 4-0001039874

in Save Dataset Fail Comment by Wayne Van Sluys Sep 4, 2025 8:29PM

Thanks I plan to open SR. Waiting on Client's subscription ID

in Save Dataset Fail Comment by Wayne Van Sluys Sep 4, 2025 8:12PM

Check out these resources https://community.oracle.com/products/oracleanalytics/discussion/25066/how-to-enable-ai-assistant-feature https://blogs.oracle.com/analytics/post/oracle-analytics-ai-assistant-getting-started-in-3-steps https://www.youtube.com/watch?v=P3vXpTDxnCU

in Not possible to use AI Assistant to built Dashboard cause the Language Model is not enabled Comment by Wayne Van Sluys Sep 2, 2025 3:14PM

That is fine, I need the calc to be dynamic with the denominator changing. I am trying to calculate this measure where the number of patients could change per site. GMLOS (Geometric Mean Length of Stay) for healthcare report… Gather data: Collect the length of stay (number of days) for each patient within a specific group…

in DV Calc using Power inplace of Root Comment by Wayne Van Sluys Aug 22, 2025 2:55PM

I would suggest having an EPM person create a Smart View Retrieve and use that to guide you into using a combination of filters and rows and columns. The Hierarchy columns to filter bar should support Selection Step. It takes a lot of picking away to get data and really is not that great of performance. I have been told…

in NSAW - EPM Connector Comment by Wayne Van Sluys Aug 19, 2025 10:17PM

how are you getting the YoY? Semantic Model or DV Calculation?

in How to do this in Pivot graph in OAS BI Tool Comment by Wayne Van Sluys Aug 18, 2025 3:07PM

Welcome to the Oracle Analytics and AI Community

Wayne Van Sluys Mod

Comments