Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

END_SQL parameter use in OLAP Universe?

Folks,

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

Regards

Former Member
Former Member replied

Hi,

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.

Regards,

Didier

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question