I've built a cube using analysis services. With Query analyser I use OPENQUERY to run an MDX statement. It doesn't always work...
It seems that the length of the column name is too long depending on the members name.
When it works it returns something like:
[table name].[level 1].[level 2].....[member name]
I think When there are more than 128 caracters it doesn'T work.
Why openquery is returning the whole hierarchy?
Is there a way to rename the column to get only the member name as column name?
Thanks!!
It seems that the length of the column name is too long depending on the members name.
When it works it returns something like:
[table name].[level 1].[level 2].....[member name]
I think When there are more than 128 caracters it doesn'T work.
Why openquery is returning the whole hierarchy?
Is there a way to rename the column to get only the member name as column name?
Thanks!!