Exoinsight dynamically pulling trailling 12 months data

[wenyg]

Hi does anyone know how to use Exoinsight to dynamically pulling trailling 12 months data for users?

[BrandonB]

I'm not an expert in Exoinsight, but I believe that you can write MDX with a where clause in which you could dynamically pull the last 12 months. You can see this described here: https://community.alteryx.com/t5/Analytics/Alteryx-ExoInsight-Enabling-Analytics-on-Oracle-Essbase-a.... I'm not sure on the exact syntax, but this is generally the approach you would take with any other query. 

[CarrHarriman]

Hello,

Great question! ExoInsight has built-in capabilities to define dynamic data variables that you can then embed into your ExoInsight queries. ExoInsight Variables are variables you can define directly in ExoInsight to make your queries more dynamic, and ExoDate variables are a subset of ExoInsight Variables built specifically to allow dynamic run-time evaluate of date variables. You can utilize the offset capability to define any type of trailing date logic you like.

Please see the following help desk guide for more information:

https://casabasesoftware.zendesk.com/hc/en-us/articles/5207980394388-ExoDate

Regards,

Carr Harriman

Casabase Software