Greetings,
I have an issue where MDX is taking a significant amount of time to run when executed through Smart View. In EAS it is blazing fast. I can change criteria in the query before executing it in EAS and it is still quick (<.03 seconds) when it is pulling triple the accounts and aggregating YTD December instead of YTD April.
The first entry in the log at the bottom is a query I ran in Smart View, the second entry is from when I copied the query from the log and executed it through EAS's MDX editor.
I turned on query tracking and noticed that the exact same MDX script in Smart View has a total query cost 3000x larger than when executed in EAS, and 8000x more Kernel Queries Tracked. I reset the query tracking in between executions.
Smart View:
EAS:
Thank you, I appreciate any assistance if you've come across something like this before.
Jared
Essbase version 11.1.2.1.103
Smart View version 11.1.2.5.210
===============================================================
Following MDX query executed at Wed Nov 07 12:10:11 2018
===============================================================
SELECT NON EMPTY {{CrossJoin({[Period].[04_2017]
}, {CrossJoin({leaves([Approver_Preparer].[John Doe])}, {CrossJoin({Descendants([Msr].[Msr],99, LEAVES)}, {CrossJoin({Descendants([Co].[Co],99, LEAVES)}, {Descendants([PC].[PC],99, LEAVES)})})})})}} ON ROWS, {{[Ledger].[BigCo IFRS Leading Ledger]}, {[Ledger].[Local GAAP ledger]}, {[Ledger].[STAT]}, {[Ledger].[MVBS]}} ON COLUMNS FROM [Recon.Recon] WHERE ( [Status].[Ledger Balance] )
=== MDX Query Elapsed Time : [32.395] seconds ===================
===============================================================
Following MDX query executed at Wed Nov 07 12:11:16 2018
===============================================================
SELECT NON EMPTY {{CrossJoin({[Period].[04_2017]
}, {CrossJoin({leaves([Approver_Preparer].[John Doe])}, {CrossJoin({Descendants([Msr].[Msr],99, LEAVES)}, {CrossJoin({Descendants([Co].[Co],99, LEAVES)}, {Descendants([PC].[PC],99, LEAVES)})})})})}} ON ROWS, {{[Ledger].[BigCo IFRS Leading Ledger]}, {[Ledger].[Local GAAP ledger]}, {[Ledger].[STAT]}, {[Ledger].[MVBS]}} ON COLUMNS FROM [Recon.Recon] WHERE ( [Status].[Ledger Balance] )
=== MDX Query Elapsed Time : [0.015] seconds ===================