END_SQL parameter use in OLAP Universe?
We normally use END_SQL in our Universe parameters /Document Name :@variable('DOCNAME'),User ID :@variable('BOUSER'),UNIVERSE :@variable('UNVNAME')/ for all our relational universes to track - which users are running long queries.
We are currently using BO Universes built on top of Microsoft Analysis Services 2008 cubes. I am wondering if there is a similar way to track which user id's have fired the most resource intensive queries?
I tried using the same parameter in END_SQL for cube Universes, but i could see no impact on the generated MDX
I want to correct my previous assumption.
I had confirmation from engineering that we will support a new parameter for OLAP sources in XI 4.0: this parameter is END_MDX.
So in BOIE XI 4.0, we will have an equivalent features for both relational and OLAP sources with END_SQL and END_MDX.