END_SQL parameter use in OLAP Universe?

[Former Member]

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 · Accepted solution]

Hi,

There is no equivalent to END_SQL for OLAP sources.

By the way, your suggestion is very good for a future enhancement.

MDX supports comments like SQL so we could imagine adding user, universe and other information at the beginning oif the generated query.

For instance here is a sample on what we could achieve when generating MDX queries:

-- User = MyUser, Universe = MyUniverse
SELECT
NON EMPTY  HIERARCHIZE ( DISTINCT( { HIERARCHIZE ( DESCENDANTS ([Product].[Product Categories].[All Products], [Product].[Product Categories].[Product], SELF_AND_BEFORE )) } )  ) ON ROWS,
NON EMPTY  HIERARCHIZE ( DISTINCT( { [Measures].[Internet Sales Amount] } )  ) ON COLUMNS
FROM [Adventure Works]

Regards

Didier

[Former Member · Accepted solution]

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