Hi,

I'm using views in Sql Server to get the data from linked server OLAP. When
I'm using MDX in OPENQUERY, nvarchar(numeric in OLAP) results,which values
are over 1000 can't be coverted to float. It's works when I'm using t-sql
statement.How can I receive numeric values from MDX? or How to convert the
nvarchar to float or double?

thx
Sobota