OWC Truncating Cube Name.

K

Karl

Hi,

I'm trying to access a cube through OWC 11 Pivot Table, using the code
below. I'm getting the following error message:

"The query could not be processed. The cubename 'Meta Quant Agrupado Padr'
is invalid."

OWC is truncating the cube name in the MDX sentence.


Does anyone know how to fix this error? Thanks.


oPivot.ConnectionString = conn; //Connection string.

oPivot.DataMember = "[Meta Quant Agrupado Padrao]"; //Cube.

oPivot.CommandText = "SELECT { [Measures].[Dia],
[Measures].[Mês],[Measures].[Trimestre]} on columns,non empty {
[TEMPO].[dia].members } on rows from [Meta Quant Agrupado Padrao] where (
[Produto Meta Agrupado].[QTDE] , [Unidade].[TODOS] , [Cliente].[TODOS] )";
//Query MDX.
 
Top