Hi... my customer is trying to add a string measure to the cube browser of SQL Server 2005 Business Intelligence Manager. He does not want to show it as a dimension. Only measures could be added to the column fields area or the cube browser, so I tried to create a text based measure but, when implementing the cube, SQL sends the following error:
"Errors in the metadata manager. The data type of the Name measure is not valid because the data type of the measure is a string type".
Any idea? Thanks.
"Errors in the metadata manager. The data type of the Name measure is not valid because the data type of the measure is a string type".
Any idea? Thanks.