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…

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…

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

Could you do it via the Parameter feature? Then Use it in the title of your Vis

You cannot calculate across rows. why can you not do as columns? How is logic different for CEO and Emp Co ?

you cannot calculate across rows.

Do you have nightly snapshots?

In Calculations you can CAST to a different data type. Or you could create an aggregation…Count(Contract Number)