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)

OAC can connect to EPM FreeForm either directly or via semantic model, it is different connector from the Essbase connector. In order to use PowerBI on EPM FreeForm data you would create a subject area within the semantic model then connect PowerBI to that subject area. Be aware it will be very labor intensive to create…

Take a look at the Rest API commands https://docs.oracle.com/en/middleware/bi/analytics-server/oap_rest_api/op-v1-reports-reportpath-run-post.html

Connect Directly either via semantic model or the direct connector

Without seeing your workbook and reviewing logs I am not able to help any further. I would suggest looking at the Developer tab and looking at the physical query that is being generated.

Remove the Account Name Filter. Drag Hierarchy to Filter and use Selection Steps. You might need to enable it in advanced settings

Just like you would do a Smart View retrieve, you need to create a Point of View (POV). Every dimension needs to either be a row, column or filter. If you have a SME that provided a Smart View retrieve, try to replicate in OAC

You need to essentially build the POV via Filters. You will also need to change properties on filters to not limit values based on other dimensions

@Santhosh_N Please show me the list of dimensions and the filter bar.

When you work with EPM Data in OAC you need to set filters for all dimensions or have on pivot, like you would with POV in Smart View.