Try this

Are you using Admin Tool or Semantic Modeler?

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…

Use Data Flow and create a dataset

Would this work for you

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

Quite easily

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

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

try multiplying by 1.0

What does your formula look like?

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

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

Yes, though you cannot stack in autofit.

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

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

Here is SR # 4-0001039874

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

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

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…