Analysis Services - Step by Step: Errors related to feature availability and configuration

On page 56 of SQL Server 2005 Analysis Services Step by Step, I tried to DEPLOY the project, and it failed with this msg:

Errors related to feature availability and configuration: The 'Measure expressions' feature is not included in the 'Standard Edition' SKU.

Is it because of my Standard Edition? If it is, could I change the 'Measure expressions' some how to get by this msg and go on with the book?

Yes, you are running into this situation because you working against Standard edition of SQL Server Analysis Services.

You can install free trial edition from http://www.microsoft.com/sql/downloads/trial-software.mspx. It has full set of features for you to comlete any tutorial.

As for the steps described in the book, or how to work around them. You should point your questions to the authors of the book.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Thanks Edward. I'll try with the trial edition.

I was also trying to post the question to the authors, but I could not find the link to it.

|||

Hi mate

I have the same problem. Could you tell me how to fix this issue please. I'm using SQL 2005 standand version. Does it cause the problem? Please tell me as soon as possible.

thank you in adv

Wen Ou

|||I have the same problem. I am also interested in a fix, not the trial version. Could someone please let me know how to change the configuration of the cube.sql

Analysis Services - Step by Step: Errors related to feature availability and configuration

On page 56 of SQL Server 2005 Analysis Services Step by Step, I tried to DEPLOY the project, and it failed with this msg:

Errors related to feature availability and configuration: The 'Measure expressions' feature is not included in the 'Standard Edition' SKU.

Is it because of my Standard Edition? If it is, could I change the 'Measure expressions' some how to get by this msg and go on with the book?

Yes, you are running into this situation because you working against Standard edition of SQL Server Analysis Services.

You can install free trial edition from http://www.microsoft.com/sql/downloads/trial-software.mspx. It has full set of features for you to comlete any tutorial.

As for the steps described in the book, or how to work around them. You should point your questions to the authors of the book.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Thanks Edward. I'll try with the trial edition.

I was also trying to post the question to the authors, but I could not find the link to it.

|||

Hi mate

I have the same problem. Could you tell me how to fix this issue please. I'm using SQL 2005 standand version. Does it cause the problem? Please tell me as soon as possible.

thank you in adv

Wen Ou

|||I have the same problem. I am also interested in a fix, not the trial version. Could someone please let me know how to change the configuration of the cube.

Analysis Service Deployment Error

Hi,

I created a SQL Server 2005 Analysis Service project. When I tried to deploy a standard Decision Tree model, it gave me errors (see below). Clearly, I can't use ntext data type with DISTINCT, but how can I change the SQL command since it was automatically created? What was the final impact of removing the DISTINCT word from the SQL command?

SQL queries 1
SELECT DISTINCT [dbo_Training_x0020_Data].[Hellos] AS [dbo_Training_x0020_DataHellos0_0]

FROM [dbo].[Training Data] AS [dbo_Training_x0020_Data]

Error Messages 1
OLE DB error: OLE DB or ODBC error: The ntext data type cannot be selected as DISTINCT because it is not comparable.; 42000.

Please assist!

MaryYou can change the data type in the DSV, or add a calculated DSV column that casts the ntext to text

analysis server

I am getting following deployment fail error when I try to deploy the
cube on the server:
"Error 1 The project could not be deployed to the
'myserver_2005'
server because of the following connectivity problems : A connection
cannot be made to redirector. Ensure that 'SQL Browser' service is
running. To verify or update the name of the target server, right-
click on the project in Solution Explorer, select Project Properties,
click on the Deployment tab, and then enter the name of the
server. 0
0 "
How do I start the analysis server so that I can deploy the cube? I
have already manually started the analysis server and browser is
running. How do I connect to the analysis server using SSMS? I am
getting an error when I use SSMS to connect to analysis server 'a
connection can not be made to the redirector. Make sure that 'sql
browser service' is running'. I made sure. Any ideas?On Sep 18, 10:54 am, SB <othell...@.yahoo.com> wrote:
> I am getting following deployment fail error when I try to deploy the
> cube on the server:
> "Error 1 The project could not be deployed to the
> 'myserver_2005'
> server because of the following connectivity problems : A connection
> cannot be made to redirector. Ensure that 'SQL Browser' service is
> running. To verify or update the name of the target server, right-
> click on the project in Solution Explorer, select Project Properties,
> click on the Deployment tab, and then enter the name of the
> server. 0
> 0 "
> How do I start the analysis server so that I can deploy the cube? I
> have already manually started the analysis server and browser is
> running. How do I connect to the analysis server using SSMS? I am
> getting an error when I use SSMS to connect to analysis server 'a
> connection can not be made to the redirector. Make sure that 'sql
> browser service' is running'. I made sure. Any ideas?
Okay this may be a bug. Can anyone please point me to a link how do I
fix this? I have already installed sp2.|||Why are you starting a new thread with a question you've already asked?
Look at my response to your original post.
ML
--
Matija Lah, SQL Server MVP
http://milambda.blogspot.com/

Always fails on Login

I don't get it. I'm trying to use Reporting Services to deploy my reports.
They always "forget" the datasource. I can run it on my local machine but
when I move it up to the co-lo it will work for a while and then it will just
fart.
and forget the datasource I try to set it through the admin and it dies
EVERY time.
I
BryanYou could try the following :
Go to the Report project properties by right clicking on
your Report Project in the IDE and selecting properties.
Out here set OverRideDataSource property to true. Then try
to deploy the reports.
>--Original Message--
>I don't get it. I'm trying to use Reporting Services to
deploy my reports.
>They always "forget" the datasource. I can run it on my
local machine but
>when I move it up to the co-lo it will work for a while
and then it will just
>fart.
>and forget the datasource I try to set it through the
admin and it dies
>EVERY time.
>I
>Bryan
>.
>