SQL Alternative to cursor: 2012

Tuesday, March 27, 2012

Analysis Services 2000 Tutorial

Has anyone tried the Quick Start tutorial?
I went through each of the steps and when I went to browse the data in the
Sales cube, I got the following error message:
Unable to browse the cube 'Sales'.
Unspecified error.
Has anyone else had this problem?
TIA
Try to apply service pack for Analysis Services. That works for me.
"Nimi" wrote:

> Has anyone tried the Quick Start tutorial?
> I went through each of the steps and when I went to browse the data in the
> Sales cube, I got the following error message:
> Unable to browse the cube 'Sales'.
> Unspecified error.
> Has anyone else had this problem?
> TIA

Analysis Services 2000 Tutorial

Has anyone tried the Quick Start tutorial?
I went through each of the steps and when I went to browse the data in the
Sales cube, I got the following error message:
Unable to browse the cube 'Sales'.
Unspecified error.
Has anyone else had this problem?
TIATry to apply service pack for Analysis Services. That works for me.
"Nimi" wrote:
> Has anyone tried the Quick Start tutorial?
> I went through each of the steps and when I went to browse the data in the
> Sales cube, I got the following error message:
> Unable to browse the cube 'Sales'.
> Unspecified error.
> Has anyone else had this problem?
> TIA

Analysis Services 2000 Tutorial

Has anyone tried the Quick Start tutorial?
I went through each of the steps and when I went to browse the data in the
Sales cube, I got the following error message:
Unable to browse the cube 'Sales'.
Unspecified error.
Has anyone else had this problem?
TIATry to apply service pack for Analysis Services. That works for me.
"Nimi" wrote:

> Has anyone tried the Quick Start tutorial?
> I went through each of the steps and when I went to browse the data in the
> Sales cube, I got the following error message:
> Unable to browse the cube 'Sales'.
> Unspecified error.
> Has anyone else had this problem?
> TIAsql

Analysis Services 2000 SP3 or SP3A - how to identify ?

Hi,

Is there a way to identify whether I have Analysis Services 2000 SP3 or SP3A ?

Thank you very much.

You can go to Help/About and Google your version number. ?

Worked for me.

|||Code wise, you can read the registry on the server's LOCAL_MACHINE \ Software\Microsoft\OLAP Server\CurrentVersion and look at the VersionNum and CSDVersionNumber

analysis services 2000 error "cannot access registry on server(servername) or you are not a

I recently had to reinstall AS2000. Since then , if i dont run the service under the local account i get a "could not access registry on (localserver) or analysis you are not part of Olap administrators group on this server" error.

I am in the sql server admins group, and the olap admins group, as is the service account I want to run AS2000 under. I have granted admin access explicitly to the Hikey_local_machine\ software\microsoft\olap server registry entries, to the service account and my account.

I have installed AS2000 SP3a and rebooted the machine. I am still stuck with the error. When i check the "actual permissions" of my account, and the service account to run the AS service under, they have full admin permission to the machine.

If i run it under "local System Account" it works, but i need to run it under the service account.

All google tells me is to install sp 3a, which i have done twice, to no avail.

Has anyone solved this bug, or do they know the reason for it?

Hello! If you have AS2000 on a separate server and the administration console on another workstation you can check that they have the same service pack installed.

I also know, from experience, that this problem problem can appear if the pasword for the service account have extended its time limit.

Any firewalls between workstations and the server?

HTH

Thomas Ivarsson

|||hi. thanks for replying. Im working exclusively off the server, not connecting from another pc. no firewalls in use in the domain either.

Analysis Services 2000 Error - OlapObjects

Good day

I'm having trouble registering an AS 2000 server. The following is the error I receive:

"The cube 'OlapObjects' does not exist, or it is not processed"

Both servers have Service Pack 4 installed.

What does this mean? Google is not much help either.

You might need to post the exact step you are performing. Registering a server in Analysis Manager does not try to access any cubes so this error does not make sense. And OlapObjects is the name of the table in the OLAP repository for AS2000, but you should NEVER access that directly.

Analysis Services 2000 + Reporting Services 2005 + Parameters

Hi All,

I'm trying to create reports in RS2005 using AS2000 as my data source. I understand that if I use RS2005 on AS2000, I wont be able to enjoy the OLAP based parameters as in using AS2005. Does anyone know an easy way to easily use Parameters in RS2005 while still using AS2000?

Regards,

Joseph

I don't think I've tried RS 2005 against AS 2000, but my best bet is that you create an OLE DB connection against your cube, and then learn how to write MDX.

You need to create MDX queries for the parameters that you want to get from your OLAP cube as well as the main query.

All parameterized queries need to be prefixed with =" and ended with ", and to be on one line. (Copy into notepad, turn off word wrap and make it stay on one single line.)

I suggest you read through some articles by Bill Pearson over at Databasejournal.com

Mastering OLAP Reports: Parameters for Analysis Services Reporting ...

http://www.databasejournal.com/features/mssql/article.php/3644661

Mastering OLAP Reporting: Cascading Prompts

http://www.databasejournal.com/features/mssql/article.php/3386441

At least one of them should get you started.

Kaisa

analysis services 2000 (data mining)

i create a model mining

CREATE MINING MODEL [a'S]
( [Cusid] LONG KEY ,
[Orderdetails] TABLE PREDICT ([Productid] LONG KEY )
) USING Microsoft_Decision_Trees

i can show for customer some products other when he choise a product.

ect: he choise A, i show he B, C, D ....

but for that, i must know his cusid.

now i want show B,C,D when one man choise A ( i don't know his cusid). how i do that.

( i'm using sql server and analysis service 2000)

You don't need to supply the customer id for prediction. The customer ID is only ysed to identify records and has no impact on the patterns in the model.|||

i can't do.

i use select query:

SELECT FLATTENED
[t1].[cusid],TopCount( Predict( Angel .[Orderdetails], INCLUDE_STATISTICS, EXCLUSIVE), $ADJUSTEDPROBABILITY, 3)
FROM
Angel
PREDICTION JOIN
SHAPE
{
OPENROWSET
(
'SQLOLEDB.1',
'Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=SIT;Data Source=(local)',
'SELECT "cusid" AS "Cusid" FROM "customers" ORDER BY "cusid"'
)

}
APPEND
(
{
OPENROWSET
(
'SQLOLEDB.1',
'Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=SIT;Data Source=(local)',
'SELECT "cusid" AS "Cusid_1", "productid" AS "Productid" FROM "vwAllAgeSex" ORDER BY "cusid"'
)
}
RELATE [Cusid] TO [Cusid_1]
)
AS [Orderdetails]
AS [T1]
ON
Angel .[Cusid] = [T1].[Cusid] AND
Angel .[Orderdetails].[Productid] = [T1].[Orderdetails].[Productid]

the result:

cusid productid $support $adjustedprobability

1 12 119 0.92

1 320 40 0.34

1 300 23 0.31

3 12 54 0.76

3 19 54 0.76

.......

so when i select product with productid = 12. how i show other relation products

( examples: when i choose a t-shirt product, i want show relation products: shoes, jeans trousers.... )

sql

Analysis Services + MDX Book recommendations

Can anyone recommend any books on analysis services and/or MDX.
We're a pretty tech savvy bunch of developers who need some kick start
books on using 2005 analysis services, warehousing principles, writing
MDX queries, designing cubes etc
Any ideas welcomed
db
http://www.osix.net
the Open Source institute
home of the geek programming challengesI recommand you the Wrox: Professional SQL Server Analysis Service 2005 with
MDX
enjoy.
Patrick
<barnseenio@.gmail.com> wrote in message
news:1149776441.711318.175980@.g10g2000cwb.googlegroups.com...
> Can anyone recommend any books on analysis services and/or MDX.
> We're a pretty tech savvy bunch of developers who need some kick start
> books on using 2005 analysis services, warehousing principles, writing
> MDX queries, designing cubes etc
> Any ideas welcomed
>
> db
>
> --
> http://www.osix.net
> the Open Source institute
> home of the geek programming challenges
>

Analysis Services & Default Value

Is it possible to define a default value for each a parameter also in a dataset?

I have a dataset with a parameter from the dimension Time. I would like to change the default value from the parameter. I tried to create a dataset to get the current year unique name, but if I set it in the parameter dialog it does not recognize the value.

I have a dataset in a report with the parameter Year from the dimension Time.

In the dataset I have to select a default value for the parameter. There is no other option.

In the reports parameters list I can specify a default value. This is not recognized, if it does not mach previous one.

Is it possible to set the default value of such a parameter to the current year value?

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 Services - Provider cannot be found

I've got a big problem with the Analysis Services.
I have a SQL Server 2000 SP3 and the Analysis Services SP3 running. The SQL Server has no problems.
When I try to browse the Data of any cube, the following error message occurs:
"Provider cannot be found. It may not be properly installed." When I try to browse other cubes after this, the error message "unknown error" occurs.
The databases, on which the cubes are based are both Access2k and SQL Server 2k. The error even appears at the test cubes from Microsoft, so it cannot be simply a problem of the database.

Much thx for your answers.Try to restart the services on the machine.|||That would be an easy solution. I tried it at first. :-)
It didn't change anything.|||Are you trying to browse from WINXP? If so, you'll need to install sp3 for analysis services on the client.|||I could solve the problem. I had an error when installing sp3 for analysis services on the server. I didn't take notice of it. Later I checked the Version number and recognized, that sp3 was not installed. I installed sp3 again and then it works.

greets,
Stefan

analysis services

Hello.....

Anyone could help me? I found a difficulties to view the mining result(tree) from analysis services 2000 in my vb 6 application form. I've tried to view the tree by using DMbrowser in vb6 so please help me with some code lines.

Thanx a lot

Take a look at the included source code in this download for the DMSample app (it's written in VB and it launches the viewers from the app): http://www.sqlserverdatamining.com/DMCommunity/Downloads/Links_LinkRedirector.aspx?id=85

Note that the AS2000 license does not give you the ability to redistributable the viewers as part of your application.

Analysis services

I am doing a data mining project using the census bureau data set. The data set is a pdf, so I saved it as a text file, I imported as a flat source file and am trying to create my data source? But am having trouble with this? Please help?

Can you post details of the errors you're seeing? This might be a question for the Integration Services forum.|||i fixed the error. but thanks. Perhaps, you could help me with Analysis services, Data source views. Under the Data source views tab select tables and views, if I only have one file of data with columns and rows, is it possible to data mine this one file. or should i be incorporating more files?|||

There are no specific restrictions on the number of tables you need to use to perform data mining. You can certainly mine data in a single file/table if that contains the attributes you're interesting in mining.

For example, you could have a single customer table with demographic information like age, income and so forth and you could apply several of the available algorithms to it to derive interesting patterns - clustering to group together similar customers, decision trees to classify them based on how they behave with respect to a predictable attribute or naive-bayes to explore dependencies and differences between attributes for customers.

|||

How would you implement the MS Time series algorithm to predict population patterns? or would you suggest I use MS decision trees?

Thanks

|||Create a table with date and columns for each series you want to analyze

Analysis Services

How do you grant just read access to the cube data to an end user?

Thanks, Edwina Derrick

Are you talking about a writeback cube? In that case just disable it in the role the user belongs to.

|||Nope - just read for any dimension. I have tried all combinations and end up giving all access to the cube for them to be able to read the data.

Thanks, Edwina Derrick|||

You are aware of the security features with roles and such in AS?

|||I am not sure I understand what you mean by security features with roles and such in AS.
I set up a role and gave them read access to the dimensions. This was not enough. I gave them read access to everything and they still couldn't view the data. Once I granted full administrator rights to the cube they could read the data.

Thanks, Edwina Derricksql

Analysis Services

We have not used Analysis Services anywhere in our shop and want to get
started. (All our machines are 2000.) I'd like to start by putting it on a
dev/qa box but if I do, Analysis Services will be the only thing that is
significantly different between out dev/qa environment and our prod servers.
Is this an issue? Does Analysis Services mess with MDAC or any of the core
Sql Server dll's? Or did MS keep it completely separate kind of like the CLR
is completely separate?
HI CLM,
Analysis services did not mess with sql services but it depend upon the
sqls services.
Analsis services uses OBDC to connect the database.
It creates its own database and only pull data from the server from sql
server
for more information
Read BOL Analsysis services
hope this help u.
from
killer

Analysis Services

I have a MS SQL Server 2000 SP3 running under MS Server 2000 Standard Edit
SP4 (MDAC 2.8).
I just installed Analysis Services. How do I apply SP3 to this system?
Each time I try to reinstall SP3, I get the message:
"Setup was unable to validate the logged user. Press Retry to enter another
option, or Cancel to exit setup."
After I exit SP3, the SQLSERVER AGENT is stopped even though it was running
when I start the SP3.
Thank you...Ed
> I have a MS SQL Server 2000 SP3 running under MS Server 2000 Standard Edit
> SP4 (MDAC 2.8).
What? Can you explain this again?

> I just installed Analysis Services. How do I apply SP3 to this system?
If you review http://www.microsoft.com/sql/downloads/2000/sp3.asp, you'll
see that you need to download sql2kasp3.exe.
http://www.aspfaq.com/
(Reverse address to reply.)

Analysis Services

Hi All,
I have an issue registering a server using Analysis Manager, whenever I try
I get a fairly generic error saying:
'the server is either not started or too busy'.
I am running SQL 2000 Server/Analysis Services both with SP4 on a Windows
2003 Server Enterprise box. This server is running IIS 6.0, Project Server
2003, Sharepoint Services 2.0 in addition to SQL 2000. I am trying to
register this server to allow me to migrate the Analysis Services Repository
to a SQL database but so far to no avail.
Any advice or assistance anyone can offer would be most appreciated.
Regards,
Darren King
Hellow Darren. I too was trying to get Analysis Services up and running for
the purpose of using the portfolio modeling etc. on Project Server. It is a
funny coincidence that we ran into similar problems. I've finally gotten this
stuff working after much bumbling around. I uninstalled and re-installed
Analysis Services 4 -5 times, with each install presenting its own strange
results. The reason I am sending you this reply is assuming this last
installation holds up, I could review with you my install and the settings
that I am using and perhaps that will get you past your present hurdles. It
is often difficult to diagnose using these forums. If you care to send me an
email at
johnca@.asg.com and we can set up a time to converse about your situation.
If you have already resolved your problems, then no need to reply.
"Darren King" wrote:

> Hi All,
> I have an issue registering a server using Analysis Manager, whenever I try
> I get a fairly generic error saying:
> 'the server is either not started or too busy'.
> I am running SQL 2000 Server/Analysis Services both with SP4 on a Windows
> 2003 Server Enterprise box. This server is running IIS 6.0, Project Server
> 2003, Sharepoint Services 2.0 in addition to SQL 2000. I am trying to
> register this server to allow me to migrate the Analysis Services Repository
> to a SQL database but so far to no avail.
> Any advice or assistance anyone can offer would be most appreciated.
> Regards,
> Darren King
>
>

Analysis Services

This may seem like a silly question but can Analysis Services work with
MSDE?
It's okay I have answered my own question. the answer is NO
"Sarah Kingswell" <skingswell@.xonitek.co.uk> wrote in message
news:OSRyF%23sYFHA.3164@.TK2MSFTNGP09.phx.gbl...
> This may seem like a silly question but can Analysis Services work with
> MSDE?
>

Analysis Services

Question. I installed SQL Analysis services, applied the service pack 3 for analysis services, re-applied service pack 3a for SQL. I'm getting an error stating: 'Unable to connect to the registry on the server, or you are not a member of OLAP Admininstrat
ors group on this server'. I verified that the username I'm using does have permissions to the registry and is a member of the OLAP Admin Group. Help!!
Can someone please help me with this question. I have a Win 2003 server with SQL 2000 Enterprise edition. I installed analysis services, applied the sp3 for analysis services and I got the message listed below. I tried re-applying both the SQL sp3a and th
e analysis services sp3 and I still get the error. When I take the same steps on my local machine with Win xp and SQL 2000 client it works fine. What am I doing wrong?
"nupee" wrote:

> Question. I installed SQL Analysis services, applied the service pack 3 for analysis services, re-applied service pack 3a for SQL. I'm getting an error stating: 'Unable to connect to the registry on the server, or you are not a member of OLAP Admininstr
ators group on this server'. I verified that the username I'm using does have permissions to the registry and is a member of the OLAP Admin Group. Help!!
>
sql

Analysis Services

Hi All,
I have an issue registering a server using Analysis Manager, whenever I try
I get a fairly generic error saying:
'the server is either not started or too busy'.
I am running SQL 2000 Server/Analysis Services both with SP4 on a Windows
2003 Server Enterprise box. This server is running IIS 6.0, Project Server
2003, Sharepoint Services 2.0 in addition to SQL 2000. I am trying to
register this server to allow me to migrate the Analysis Services Repository
to a SQL database but so far to no avail.
Any advice or assistance anyone can offer would be most appreciated.
Regards,
Darren KingHellow Darren. I too was trying to get Analysis Services up and running for
the purpose of using the portfolio modeling etc. on Project Server. It is a
funny coincidence that we ran into similar problems. I've finally gotten this
stuff working after much bumbling around. I uninstalled and re-installed
Analysis Services 4 -5 times, with each install presenting its own strange
results. The reason I am sending you this reply is assuming this last
installation holds up, I could review with you my install and the settings
that I am using and perhaps that will get you past your present hurdles. It
is often difficult to diagnose using these forums. If you care to send me an
email at
johnca@.asg.com and we can set up a time to converse about your situation.
If you have already resolved your problems, then no need to reply.
"Darren King" wrote:
> Hi All,
> I have an issue registering a server using Analysis Manager, whenever I try
> I get a fairly generic error saying:
> 'the server is either not started or too busy'.
> I am running SQL 2000 Server/Analysis Services both with SP4 on a Windows
> 2003 Server Enterprise box. This server is running IIS 6.0, Project Server
> 2003, Sharepoint Services 2.0 in addition to SQL 2000. I am trying to
> register this server to allow me to migrate the Analysis Services Repository
> to a SQL database but so far to no avail.
> Any advice or assistance anyone can offer would be most appreciated.
> Regards,
> Darren King
>
>

Analysis Services

This may seem like a silly question but can Analysis Services work with
MSDE?It's okay I have answered my own question. the answer is NO
"Sarah Kingswell" <skingswell@.xonitek.co.uk> wrote in message
news:OSRyF%23sYFHA.3164@.TK2MSFTNGP09.phx.gbl...
> This may seem like a silly question but can Analysis Services work with
> MSDE?
>

Analysis Services

I have a MS SQL Server 2000 SP3 running under MS Server 2000 Standard Edit
SP4 (MDAC 2.8).
I just installed Analysis Services. How do I apply SP3 to this system?
Each time I try to reinstall SP3, I get the message:
"Setup was unable to validate the logged user. Press Retry to enter another
option, or Cancel to exit setup."
After I exit SP3, the SQLSERVER AGENT is stopped even though it was running
when I start the SP3.
Thank you...Ed> I have a MS SQL Server 2000 SP3 running under MS Server 2000 Standard Edit
> SP4 (MDAC 2.8).
What? Can you explain this again?
> I just installed Analysis Services. How do I apply SP3 to this system?
If you review http://www.microsoft.com/sql/downloads/2000/sp3.asp, you'll
see that you need to download sql2kasp3.exe.
--
http://www.aspfaq.com/
(Reverse address to reply.)

Analysis Services

We have not used Analysis Services anywhere in our shop and want to get
started. (All our machines are 2000.) I'd like to start by putting it on a
dev/qa box but if I do, Analysis Services will be the only thing that is
significantly different between out dev/qa environment and our prod servers.
Is this an issue? Does Analysis Services mess with MDAC or any of the core
Sql Server dll's? Or did MS keep it completely separate kind of like the CLR
is completely separate?HI CLM,
Analysis services did not mess with sql services but it depend upon the
sqls services.
Analsis services uses OBDC to connect the database.
It creates its own database and only pull data from the server from sql
server
for more information
Read BOL Analsysis services
hope this help u.
from
killer

analysis services

Which version of the sqlserver comes with analysis server? how do we setupAnalysis services comes with SQL 7 and SQL 2k..
Simply load the CD ( with autorun set) and you will get an option to setup
SQL Server or Analysis services...
"jbomma" <jbomma@.clayton.com> wrote in message
news:uWAQFXz6DHA.1556@.tk2msftngp13.phx.gbl...
> Which version of the sqlserver comes with analysis server? how do we setup
>sql

Analysis Services

Hi,
why AS isn't able to browse the data of a cube?
-->Error Messages:
"Unable to browse the cube Sales"
"Unable to locate the cube 'sales'"
Although the cube Sales is manually included in the programm!
A have already installes the SP3a. What is wrong here?
Will be greateful for any help and many thanks in advance!Saw this error before, remove AS and reinstall it, see if it fixes the
problem.
Also, try to rebuild the cube
Eric
Stefan wrote:

> Hi,
> why AS isn't able to browse the data of a cube?
> -->Error Messages:
> "Unable to browse the cube Sales"
> "Unable to locate the cube 'sales'"
> Although the cube Sales is manually included in the programm!
> A have already installes the SP3a. What is wrong here?
> Will be greateful for any help and many thanks in advance!
>
Eric Li
SQL DBA
MCDBA|||I am having the same problem as Stefan. I reinstalled AS and SP3a and contin
ue to have this problem. Any ideas?
--
Thanks, Ken
"Eric.Li" wrote:

> Saw this error before, remove AS and reinstall it, see if it fixes the
> problem.
> Also, try to rebuild the cube
> Eric
> Stefan wrote:
>
>
> --
> Eric Li
> SQL DBA
> MCDBA
>

Analysis Services

I am trying to work through the tutorial when you load SQL 2005. I am running the 64 bit version. I have deployed my cube and am trying to display data in the browser. I move over the sales amount into the data area I get the below message. What should I do to fix this issue?

The query could not be processed:

Memory error: While attempting to store a string, a string was found that was larger than the page size selected. The operation cannot be completed.

Sounds similar to the problem discussed in this thread:

http://groups.google.com/group/microsoft.public.sqlserver.olap/msg/d2ca4c8981db915a
>>

" noWrap width="1%" bgColor=#b71c0c>Mosha Pasumansky [MS] Oct 17, 2:24 pm show options

Newsgroups: microsoft.public.sqlserver.olap From: "Mosha Pasumansky [MS]" <mos...@.online.microsoft.com> - Find messages by this author Date: Mon, 17 Oct 2005 11:24:25 -0700 Local: Mon, Oct 17 2005 2:24 pm Subject: Re: AS 2005: ....a string was found that was larger than the page size Reply | Reply to Author | Forward | Print | View Thread | Show original | Report Abuse

Please read this thread - there is plenty of feedback from the product team.
It is a bug in CTP16 that is fixed in RTM. If you are TAP customer - you can
get CTP16 hotfix for it.

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebLog/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================
>>

Analysis Services

How can you process multiple Analysis Services databases against the same SQL Server database without receiving table locks and the processing fails.How about one by one database using some program? There is a command line tool available to execute XML/A requests.|||

Dear,

We can create a DTS Package that will process all the Analysis Databases one by one.

HTH

from

sufian

Analysis Services

Hi,
why AS isn't able to browse the data of a cube?
-->Error Messages:
"Unable to browse the cube Sales"
"Unable to locate the cube 'sales'"
Although the cube Sales is manually included in the programm!
A have already installes the SP3a. What is wrong here?
Will be greateful for any help and many thanks in advance!
Saw this error before, remove AS and reinstall it, see if it fixes the
problem.
Also, try to rebuild the cube
Eric
Stefan wrote:

> Hi,
> why AS isn't able to browse the data of a cube?
> -->Error Messages:
> "Unable to browse the cube Sales"
> "Unable to locate the cube 'sales'"
> Although the cube Sales is manually included in the programm!
> A have already installes the SP3a. What is wrong here?
> Will be greateful for any help and many thanks in advance!
>
Eric Li
SQL DBA
MCDBA
|||I am having the same problem as Stefan. I reinstalled AS and SP3a and continue to have this problem. Any ideas?
Thanks, Ken
"Eric.Li" wrote:

> Saw this error before, remove AS and reinstall it, see if it fixes the
> problem.
> Also, try to rebuild the cube
> Eric
> Stefan wrote:
>
> --
> Eric Li
> SQL DBA
> MCDBA
>

Analysis Services

I was at a Microsoft sales presentation last week for the new version
of SQL Server, Yukon. They had an extensive presentation on SQL
Server and Reporting Services but didn't mention Analysis Services.
When I asked about the future of the product the MS Sales rep couldn't
give me any info. When I looked at the big product chart I got at the
presntation, Analysis Services wasn't on it. There was just box
refering to Reporting Services and XML. Does anyone know what or if
there is a future for Analysis Services?BruceGilpin (brucegilpin@.ameritech.net) writes:
> I was at a Microsoft sales presentation last week for the new version
> of SQL Server, Yukon. They had an extensive presentation on SQL
> Server and Reporting Services but didn't mention Analysis Services.
> When I asked about the future of the product the MS Sales rep couldn't
> give me any info. When I looked at the big product chart I got at the
> presntation, Analysis Services wasn't on it. There was just box
> refering to Reporting Services and XML. Does anyone know what or if
> there is a future for Analysis Services?

I'm not into Analysis Services myself, but on the Yukon events I have
been, there have been plenty of sessions about Analysis Services, so
I'm confident to say that it has a bright and lively future.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.aspsql

Analysis Services

Hi All,
I have an issue registering a server using Analysis Manager, whenever I try
I get a fairly generic error saying:
'the server is either not started or too busy'.
I am running SQL 2000 Server/Analysis Services both with SP4 on a Windows
2003 Server Enterprise box. This server is running IIS 6.0, Project Server
2003, Sharepoint Services 2.0 in addition to SQL 2000. I am trying to
register this server to allow me to migrate the Analysis Services Repository
to a SQL database but so far to no avail.
Any advice or assistance anyone can offer would be most appreciated.
Regards,
Darren KingHellow Darren. I too was trying to get Analysis Services up and running for
the purpose of using the portfolio modeling etc. on Project Server. It is a
funny coincidence that we ran into similar problems. I've finally gotten thi
s
stuff working after much bumbling around. I uninstalled and re-installed
Analysis Services 4 -5 times, with each install presenting its own strange
results. The reason I am sending you this reply is assuming this last
installation holds up, I could review with you my install and the settings
that I am using and perhaps that will get you past your present hurdles. It
is often difficult to diagnose using these forums. If you care to send me an
email at
johnca@.asg.com and we can set up a time to converse about your situation.
If you have already resolved your problems, then no need to reply.
"Darren King" wrote:

> Hi All,
> I have an issue registering a server using Analysis Manager, whenever I tr
y
> I get a fairly generic error saying:
> 'the server is either not started or too busy'.
> I am running SQL 2000 Server/Analysis Services both with SP4 on a Windows
> 2003 Server Enterprise box. This server is running IIS 6.0, Project Serve
r
> 2003, Sharepoint Services 2.0 in addition to SQL 2000. I am trying to
> register this server to allow me to migrate the Analysis Services Reposito
ry
> to a SQL database but so far to no avail.
> Any advice or assistance anyone can offer would be most appreciated.
> Regards,
> Darren King
>
>

Analysis Services

We have not used Analysis Services anywhere in our shop and want to get
started. (All our machines are 2000.) I'd like to start by putting it on a
dev/qa box but if I do, Analysis Services will be the only thing that is
significantly different between out dev/qa environment and our prod servers.
Is this an issue? Does Analysis Services mess with MDAC or any of the core
Sql Server dll's? Or did MS keep it completely separate kind of like the CL
R
is completely separate?HI CLM,
Analysis services did not mess with sql services but it depend upon the
sqls services.
Analsis services uses OBDC to connect the database.
It creates its own database and only pull data from the server from sql
server
for more information
Read BOL Analsysis services
hope this help u.
from
killer

Sunday, March 25, 2012

Analysis Services

Question. I installed SQL Analysis services, applied the service pack 3 for
analysis services, re-applied service pack 3a for SQL. I'm getting an error
stating: 'Unable to connect to the registry on the server, or you are not a
member of OLAP Admininstrat
ors group on this server'. I verified that the username I'm using does have
permissions to the registry and is a member of the OLAP Admin Group. Help!!Can someone please help me with this question. I have a Win 2003 server with
SQL 2000 Enterprise edition. I installed analysis services, applied the sp3
for analysis services and I got the message listed below. I tried re-applyi
ng both the SQL sp3a and th
e analysis services sp3 and I still get the error. When I take the same step
s on my local machine with Win xp and SQL 2000 client it works fine. What am
I doing wrong'
"nupee" wrote:

> Question. I installed SQL Analysis services, applied the service pack 3 for analys
is services, re-applied service pack 3a for SQL. I'm getting an error stating: 'Unab
le to connect to the registry on the server, or you are not a member of OLAP Adminin
str
ators group on this server'. I verified that the username I'm using does have permissions to
the registry and is a member of the OLAP Admin Group. Help!!
>

Analysis Services

This may seem like a silly question but can Analysis Services work with
MSDE?It's okay I have answered my own question. the answer is NO
"Sarah Kingswell" <skingswell@.xonitek.co.uk> wrote in message
news:OSRyF%23sYFHA.3164@.TK2MSFTNGP09.phx.gbl...
> This may seem like a silly question but can Analysis Services work with
> MSDE?
>

analysis services

quote:

> Which version of the sqlserver comes with analysis server? how do we setup
>

sql

Analysis Servicees 2000 Limits

I have a (respected) collegue that seems to be certain that a limitation of
a diminsion is 65,000
rows. I have not been able to confirm this anywhere. Only that the number of
Dimensions per cube
is limited to 65,535.
Can anyone confirm if there is any limit to the number of dimension rows for
any of the storage models (MOLAP, ROLAP, HOLAP)?
Thanks,
-Troy
Troy, its true what youre collegue says, but the number of dimension is
wrong. You can have 128 dimensions per cube.
HTH
Pablo Mugica
"Troy Jerkins" <tjerkins@.alltel.net> wrote in message
news:%23Jk8Rak3FHA.2676@.TK2MSFTNGP15.phx.gbl...
>I have a (respected) collegue that seems to be certain that a limitation of
>a diminsion is 65,000
> rows. I have not been able to confirm this anywhere. Only that the number
> of Dimensions per cube
> is limited to 65,535.
> Can anyone confirm if there is any limit to the number of dimension rows
> for any of the storage models (MOLAP, ROLAP, HOLAP)?
> Thanks,
> -Troy
>
|||Thanks for the confirmation. Has this limitation been lifted in AS 2005? I
can't find ANYTHING spec-wise on capacity other than the the 2GB backup
limit has been lifted.
-Troy
"Pablo Mugica" <PSM@.x.com> wrote in message
news:OLog0rk3FHA.2552@.TK2MSFTNGP10.phx.gbl...
> Troy, its true what youre collegue says, but the number of dimension is
> wrong. You can have 128 dimensions per cube.
> HTH
> Pablo Mugica
>
> "Troy Jerkins" <tjerkins@.alltel.net> wrote in message
> news:%23Jk8Rak3FHA.2676@.TK2MSFTNGP15.phx.gbl...
>
|||Totally in-correct. You can have dimensions with millions and millions of
members.
The limitation (lifted in AS2K5) is that a parent is limited to only 64000
children.
If your dimension has multiple levels that it is only unusual cases where
this comes into play. Where it does, you can use automatic grouping to add
an intermediate level kind of like a phone book (A thru J, K thru S, T thru
Z) -- AS automatically detects and generates the thresholds for the
intermediate members.
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Troy Jerkins" <tjerkins@.alltel.net> wrote in message
news:%23Jk8Rak3FHA.2676@.TK2MSFTNGP15.phx.gbl...
>I have a (respected) collegue that seems to be certain that a limitation of
>a diminsion is 65,000
> rows. I have not been able to confirm this anywhere. Only that the number
> of Dimensions per cube
> is limited to 65,535.
> Can anyone confirm if there is any limit to the number of dimension rows
> for any of the storage models (MOLAP, ROLAP, HOLAP)?
> Thanks,
> -Troy
>
|||Troy, as Dave says, the limitation is that you can have 64k member per
parent in AS2K and its not a limit anymore in SSAS 2005.
About the limit please refer to "Specifications and Limits" in the AS2K
Books On Line and to http://blogs.msdn.com/bi_systems/articles/187740.aspx
about SSAS 2005.
Regards,
Pablo Mugica
"Troy Jerkins" <tjerkins@.alltel.net> wrote in message
news:OdnfLxk3FHA.2676@.TK2MSFTNGP15.phx.gbl...
> Thanks for the confirmation. Has this limitation been lifted in AS 2005? I
> can't find ANYTHING spec-wise on capacity other than the the 2GB backup
> limit has been lifted.
> -Troy
> "Pablo Mugica" <PSM@.x.com> wrote in message
> news:OLog0rk3FHA.2552@.TK2MSFTNGP10.phx.gbl...
>

Analysis Servicees 2000 Limits

I have a (respected) collegue that seems to be certain that a limitation of
a diminsion is 65,000
rows. I have not been able to confirm this anywhere. Only that the number of
Dimensions per cube
is limited to 65,535.
Can anyone confirm if there is any limit to the number of dimension rows for
any of the storage models (MOLAP, ROLAP, HOLAP)?
Thanks,
-TroyTroy, its true what youre collegue says, but the number of dimension is
wrong. You can have 128 dimensions per cube.
HTH
Pablo Mugica
"Troy Jerkins" <tjerkins@.alltel.net> wrote in message
news:%23Jk8Rak3FHA.2676@.TK2MSFTNGP15.phx.gbl...
>I have a (respected) collegue that seems to be certain that a limitation of
>a diminsion is 65,000
> rows. I have not been able to confirm this anywhere. Only that the number
> of Dimensions per cube
> is limited to 65,535.
> Can anyone confirm if there is any limit to the number of dimension rows
> for any of the storage models (MOLAP, ROLAP, HOLAP)?
> Thanks,
> -Troy
>|||Thanks for the confirmation. Has this limitation been lifted in AS 2005? I
can't find ANYTHING spec-wise on capacity other than the the 2GB backup
limit has been lifted.
-Troy
"Pablo Mugica" <PSM@.x.com> wrote in message
news:OLog0rk3FHA.2552@.TK2MSFTNGP10.phx.gbl...
> Troy, its true what youre collegue says, but the number of dimension is
> wrong. You can have 128 dimensions per cube.
> HTH
> Pablo Mugica
>
> "Troy Jerkins" <tjerkins@.alltel.net> wrote in message
> news:%23Jk8Rak3FHA.2676@.TK2MSFTNGP15.phx.gbl...
>|||Totally in-correct. You can have dimensions with millions and millions of
members.
The limitation (lifted in AS2K5) is that a parent is limited to only 64000
children.
If your dimension has multiple levels that it is only unusual cases where
this comes into play. Where it does, you can use automatic grouping to add
an intermediate level kind of like a phone book (A thru J, K thru S, T thru
Z) -- AS automatically detects and generates the thresholds for the
intermediate members.
--
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Troy Jerkins" <tjerkins@.alltel.net> wrote in message
news:%23Jk8Rak3FHA.2676@.TK2MSFTNGP15.phx.gbl...
>I have a (respected) collegue that seems to be certain that a limitation of
>a diminsion is 65,000
> rows. I have not been able to confirm this anywhere. Only that the number
> of Dimensions per cube
> is limited to 65,535.
> Can anyone confirm if there is any limit to the number of dimension rows
> for any of the storage models (MOLAP, ROLAP, HOLAP)?
> Thanks,
> -Troy
>|||Troy, as Dave says, the limitation is that you can have 64k member per
parent in AS2K and its not a limit anymore in SSAS 2005.
About the limit please refer to "Specifications and Limits" in the AS2K
Books On Line and to http://blogs.msdn.com/bi_systems/articles/187740.aspx
about SSAS 2005.
Regards,
Pablo Mugica
"Troy Jerkins" <tjerkins@.alltel.net> wrote in message
news:OdnfLxk3FHA.2676@.TK2MSFTNGP15.phx.gbl...
> Thanks for the confirmation. Has this limitation been lifted in AS 2005? I
> can't find ANYTHING spec-wise on capacity other than the the 2GB backup
> limit has been lifted.
> -Troy
> "Pablo Mugica" <PSM@.x.com> wrote in message
> news:OLog0rk3FHA.2552@.TK2MSFTNGP10.phx.gbl...
>

Analysis service: pb when archiving/restoring from 1 machine to another

I have to install cubes on another machine (not on the same site/NT domain).
I have archived the OLAP db and generated a .cab file.

I have retored on the destination server.
It works fine in Analysis Manager console (I can process and lokk at the data).
But when I want to access the cube from Excel using OLAP cube, I have an error msg.

Is there something I need to do on the distination server ?
Langage, SP, role, version of SQLServer/Analysis services ...

ThanksWhat is the error message that you get?|||In Excel: (translated from French)
"OLAP cube not found
OLAP database ha been modified or you do not have necessary authorisation to connect to the cube
Contact your database admin"

It has something to do wuth SSPI authentication ?|||It could have something to do with the access rights...
I once saw something similar to this, and then the problem was solved by adding the user account to the OLAP admin group.

Analysis Service: how can I process cubes?

how can I process and update cubes automaticly every night ?
ThanksThere is a task in DTS for processign cubes and other Analysis Services tasks. Create a package and just schedule it

Analysis service: how can I change the name of the data source ?

I want the change the name of the Data source (see attached gif picture)
ThanksThis is from Step By Step: Microsoft SQL Server 2000 Analysis Services.

When you copy an object - such as a data source, a database, a cube, or a dimension - and attempt to paste the object back into the same container, Analysis Manager prompts for a new name. This is the only way to "rename" an object. Once you've copied and pasted the object, you can delete the original. If you want to "rename" a data source, you must do so before using it as the source for a cube or dimension.sql

Analysis Service: filter fact table ?

I have a big table with several types of transsactions: PO (Puchase Orders, SO,( Sales orders), INV (Invoices) ...
I want to create cubes with only one type of transactions (1 cube for PO,...)
Where and how can I filter the rows I want to use in my cube ?
Thankscreate view, and for fact table in AS point at the view.|||create view, and for fact table in AS point at the view.

Analysis Service stops soon after starting

Hi all,

I'm quite new to MS SQL server. I downloaded the Evaluation version of 2005 recently. I tried installing it. Partially I succed. I'm able to get all other services running but for the "Analysis service" when I try to start it from control pannel, It starts and stops immedieatly with a message "It started and stopped immedieatly.....". I'm not able to figure it out why.

I've Vista Business edition and I've installed the SP2 for the SQL 2005 as well. Any directions would be helpful

Best regards,

Markish

Hello. When you start Management Studio or BI_Dev Studio you can right click on them and choose "Run as administrator", provided that you are an administrator on you machine.

Vista also requires SP1 for Visual Studio and an additional update. From my memory I also think that you will need SQL Server SP2. Have you installed these updates?

HTH

Thomas Ivarsson

|||

Hi,

Thanks for the reply. I've installed SQL SP2. I doubt If I have the SP1 for the Visual Studio. (I'll install it today anyhow... Smile ) I'm running as an administrator only. I'll update you on the status.

Best regards,

Markish

|||

Hi Markish, Were you able to solve this problem? If so, pls let know how it happenned. I face the same issue, posted here:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2113409&SiteID=1

regards

Analysis Service stops soon after starting

Hi all,

I've Vista Business edition and I've installed the SP2 for the SQL 2005 as well. Any directions would be helpful

Best regards,

Markish

Hello. When you start Management Studio or BI_Dev Studio you can right click on them and choose "Run as administrator", provided that you are an administrator on you machine.

Vista also requires SP1 for Visual Studio and an additional update. From my memory I also think that you will need SQL Server SP2. Have you installed these updates?

HTH

Thomas Ivarsson

|||

Hi,

Best regards,

Markish

|||

Hi Markish, Were you able to solve this problem? If so, pls let know how it happenned. I face the same issue, posted here:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2113409&SiteID=1

regards

Analysis Service SP3

Where to download SQL Server 2000 Analysis Service SP3?
Does it include inside SQL Server 2000 SP3?
Thanks.
-Where to download SQL Server 2000 Analysis Service SP3?
http://www.microsoft.com/sql/downloads/2000/sp3.asp
-Does it include inside SQL Server 2000 SP3?
No you have to install it seperately. Sql2kasp3.exe only contains analysis
issues.
a.. Sql2ksp3.exe. Updates for database components.
a.. Sql2kasp3.exe. Updates for Analysis Services components.
a.. Sql2kdesksp3.exe. Updates for Microsoft SQL Server 2000 Desktop Engine
(MSDE 2000).
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Joe" <Joe@.discussions.microsoft.com> schrieb im Newsbeitrag
news:49C8FD2F-CBC4-48B6-BDC2-F2BC9C49071D@.microsoft.com...
> Where to download SQL Server 2000 Analysis Service SP3?
> Does it include inside SQL Server 2000 SP3?
> Thanks.

Analysis Service SP3

Where to download SQL Server 2000 Analysis Service SP3?
Does it include inside SQL Server 2000 SP3?
Thanks.-Where to download SQL Server 2000 Analysis Service SP3?
http://www.microsoft.com/sql/downloads/2000/sp3.asp
-Does it include inside SQL Server 2000 SP3?
No you have to install it seperately. Sql2kasp3.exe only contains analysis
issues.
a.. Sql2ksp3.exe. Updates for database components.
a.. Sql2kasp3.exe. Updates for Analysis Services components.
a.. Sql2kdesksp3.exe. Updates for Microsoft SQL Server 2000 Desktop Engine
(MSDE 2000).
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Joe" <Joe@.discussions.microsoft.com> schrieb im Newsbeitrag
news:49C8FD2F-CBC4-48B6-BDC2-F2BC9C49071D@.microsoft.com...
> Where to download SQL Server 2000 Analysis Service SP3?
> Does it include inside SQL Server 2000 SP3?
> Thanks.sql

Analysis Service SP3

Where to download SQL Server 2000 Analysis Service SP3?
Does it include inside SQL Server 2000 SP3?
Thanks.-Where to download SQL Server 2000 Analysis Service SP3?
http://www.microsoft.com/sql/downloads/2000/sp3.asp
-Does it include inside SQL Server 2000 SP3?
No you have to install it seperately. Sql2kasp3.exe only contains analysis
issues.
a.. Sql2ksp3.exe. Updates for database components.
a.. Sql2kasp3.exe. Updates for Analysis Services components.
a.. Sql2kdesksp3.exe. Updates for Microsoft SQL Server 2000 Desktop Engine
(MSDE 2000).
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Joe" <Joe@.discussions.microsoft.com> schrieb im Newsbeitrag
news:49C8FD2F-CBC4-48B6-BDC2-F2BC9C49071D@.microsoft.com...
> Where to download SQL Server 2000 Analysis Service SP3?
> Does it include inside SQL Server 2000 SP3?
> Thanks.

Analysis Service Ports

SQL 2005 AS installed on a Cluster.
We are using a named instance and only one currently exists. MS White paper
reads: The default instance listens on port 2383, while named instances are
dynamically allocated. This behavior can be changed by explicitly assigning a
port to either the default or named instance of SSAS. If the value for Port
is 0, the default behavior described above is achieved. Otherwise, the value
is treated as an absolute (static) port number to use for the specified
instance.
I have modifed the Server PORT property, on the named instance (a default
instance does not exist) to listen on port 2382 and have added a rule to our
firewall to allow this traffic. However, AS continues to listen on port 2383.
Does anyone have any experience on this and how to change it.
Is there a range of ports I can tell our network team to open?
I am not sure on SQL 2005 but in SQL 2000 you need to start the service
again to take the effect of new port numbers...
Zaki.
"FredG" <FredG@.discussions.microsoft.com> wrote in message
news:6A9E45E1-E591-4086-B8A3-A5A1556BFFDC@.microsoft.com...
> SQL 2005 AS installed on a Cluster.
> We are using a named instance and only one currently exists. MS White
paper
> reads: The default instance listens on port 2383, while named instances
are
> dynamically allocated. This behavior can be changed by explicitly
assigning a
> port to either the default or named instance of SSAS. If the value for
Port
> is 0, the default behavior described above is achieved. Otherwise, the
value
> is treated as an absolute (static) port number to use for the specified
> instance.
> I have modifed the Server PORT property, on the named instance (a default
> instance does not exist) to listen on port 2382 and have added a rule to
our
> firewall to allow this traffic. However, AS continues to listen on port
2383.
> Does anyone have any experience on this and how to change it.
> Is there a range of ports I can tell our network team to open?
|||I have restarted the service multiple times and it continues to listen on
this port.
"Zakiuddin Mohammed" wrote:

> I am not sure on SQL 2005 but in SQL 2000 you need to start the service
> again to take the effect of new port numbers...
> Zaki.
> "FredG" <FredG@.discussions.microsoft.com> wrote in message
> news:6A9E45E1-E591-4086-B8A3-A5A1556BFFDC@.microsoft.com...
> paper
> are
> assigning a
> Port
> value
> our
> 2383.
>
>

analysis service package question

I'm working on a new analysis package using VS 2005, I am able to create the package and cube, etc, but when I go to the Calculation tab for the cube I'm getting the following error message "Unexpected Error occurred: 'Error in application' "

now I uninstalled and reinstalled VS .NET 05 twice, and even uninstalled and reinstalled SQL Server on my box and I'm still getting the error message.

What is causing this error and how can I fix it?

Have you got Office 2007 installed? See:

http://geekswithblogs.net/darrengosbell/archive/2006/11/17/97367.aspx

HTH,

Chris

|||No i don't, I have office 03 installed|||

Hmm, possibly something else has caused the same problem. I'd still go through the steps described to see if it stops the error if I were you...

Chris

|||

I'm getting ready to go through them now actually.

I'll post how it turns out.

Analysis Service on 2005

I'm trying to create a Cube on analysis services, but do not see any
realtions in the diagram between my selected tables. The tables use indexes
rather than primary keys. Do you have any suggestions about how I can specify
the relations from Analysis Services.
Thanksdo you talk about the DSV (data source view) schema?
the system can detect relationships based on column names, you have an
option which allow you to change the way visual studio will detect the
relationship between the tables.
but this works BEFORE you add tables in the DSV
after this you have to manually create the links in the DSV. (its a simple
drag&drop)
"dbach" <dbach@.discussions.microsoft.com> wrote in message
news:E0F20189-17FC-443D-8348-2CC63172F0FD@.microsoft.com...
> I'm trying to create a Cube on analysis services, but do not see any
> realtions in the diagram between my selected tables. The tables use
> indexes
> rather than primary keys. Do you have any suggestions about how I can
> specify
> the relations from Analysis Services.
> Thanks

Analysis Service Manager

I give up, how do you start the Analysis Manager? SSAS is installed and running, but I just can't seem to find the button/shortcut/whatever to start the manager.

If you are using SSAS 2005, you should use SQL Server Management Studio and connect to Analysis Services to view server objects

For development, you will have to use BIDS (BI development studio - Visual studio 2005)

|||Thanks, but how do I get to a 2K database?|||If u r using AS 2000, then I guess it would be better to use Analysis Manager. It should be under Programs ==> Microsoft SQL Server.|||I have to support both 2000 (legacy) and 2005 AS. However, I can't have both Services installed at the same time, which is why I'm trying to use SSAS 2005.|||

You can have both services installed at the same time.

You have to install AS2k as the default (unnamed instance) as it does not support named instances.

You then install AS2k5 as a named instance, on my machine I have it setup as localhost\SQL05. But you still need both sets of admin tools Analysis Manager for AS2k and Management Studio and BI Dev Studio for AS2k5. You cannot administer both versions from a single tool.

sql

Analysis Service is slowing down the server

Hi,

I am facing the following problem on SQL2K.

When I start the service the server slows down and users start complaining that generation of reports based on system (i.e. databases) that are hosted on the same server have REALLY slowed down... and thus I have to stop the service...

Can some please guide me regarding how to solve this problem and how I can be able to use the Analysis service.

Many thanks in advance for you kind help.Howdy

It would make sense to :

(1) Ensure the tables Analysis Services are querying have good indexes on them - use profiler & Index Tuner wizrd to check

(2) RUn the queries after hours to reduce competion on resources

(3) Check perfmon and see if the box is under powered for what you are trying to do

(4) Maybe find another server and copy the database to it & run analysis services on that - that way no-one will ever complain and it may be quicker for oyu.

Cheers,

SG.

Analysis Service in cluster

Hi
I have 2-node active/active cluster. I have installed 2 SQL instances (one
per node).
Now I want to install Analysis service in cluster for datawarehouse . I have
some questions regarding this.
1. Should I have seperate cluster group to be created for this? if so, how
many disk drives would be required for that group (recommendations).
2. Should I give different instance name for analysis serviceor I can be
same instance name as SQL instance.
Thanks and Regards,
Vijay
Vijay
1. Create a separate cluster groups and add Disk to it ... I would start
with one disk or more depending on how you have laid out the DW
2. For the instance - I would recommend a different name
Thanks
"Vijay" <Vijay@.discussions.microsoft.com> wrote in message
news:16D83565-9F15-4A5D-A745-B2C47EE0BF5F@.microsoft.com...
> Hi
> I have 2-node active/active cluster. I have installed 2 SQL instances (one
> per node).
> Now I want to install Analysis service in cluster for datawarehouse . I
> have
> some questions regarding this.
> 1. Should I have seperate cluster group to be created for this? if so,
> how
> many disk drives would be required for that group (recommendations).
> 2. Should I give different instance name for analysis serviceor I can be
> same instance name as SQL instance.
> Thanks and Regards,
> Vijay
>
|||Thanks for your help
"Seme Rollansa" wrote:

> Vijay
> 1. Create a separate cluster groups and add Disk to it ... I would start
> with one disk or more depending on how you have laid out the DW
> 2. For the instance - I would recommend a different name
> Thanks
>
> "Vijay" <Vijay@.discussions.microsoft.com> wrote in message
> news:16D83565-9F15-4A5D-A745-B2C47EE0BF5F@.microsoft.com...
>
>

analysis service DTS keeps failing . ERRORSOURCE = DSO

i have an analysis services dts job on an old sql server 2000 box. i have never used analysis services before, and am a bit stuck. the job used to run and succeed all the time, but now it fails most of the time. this is the error that goes with the failure. someone suggested that its because more than 1 cube processing jobs were running at the same time, but i dont know how i would sort that out as they have to be run at the times they are scheduled for.

ERROR:

Executed as user: REDMOND\osqlli01. ...
tart: DTSStep_DTSExecuteSQLTask_4
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_4
DTSRun OnStart: DTSStep_DTSDynamicPropertiesTask_1
DTSRun OnFinish: DTSStep_DTSDynamicPropertiesTask_1
DTSRun OnStart: DTSStep_DTSOlapProcess.Task_1
DTSRun OnError: DTSStep_DTSOlapProcess.Task_1, Error = -2146828197 (800A005B)
Error string: Object variable or With block variable not set
Error source: DSO Help file:
Help context: 1000091
Error Detail Records: Error: 0 (0);
Provider Error: 0 (0)
Error string: Object variable or With block variable not set
Error source: DSO Help file:
Help context: 1000091
DTSRun OnFinish: DTSStep_DTSOlapProcess.Task_1
DTSRun OnStart: DTSStep_DTSExecuteSQLTask_10
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_10
DTSRun OnStart: DTSStep_DTSExecuteSQLTask_7
DTSRun OnError: DTSStep_DTSExecuteSQLTask_7, Error = -2147220421 (8004043B... Process Exit Code 2. The step failed.

Maybe you have to turn on the 'execute on main thread' option !
You can find it on the workflow properties in your DTS-Package !

|||i just checked. it is set to run on the main process. that box is checked.|||

Winston,

Were you able to find a solution or the cause to this problem? This error has started to occur when I try to process a cube on Analysis Services 2000.

Thanks,

Jake

|||

In the past, I got the same kind of error !

My error occured because my 'Navision-odbc-driver' did NOT support multithreading ! In other words, executing tasks simultaneously caused my error !

To solve that error: On every workflow, I turned on the 'execute on main thread' option !

Kind regards,

Geert G.

analysis service DTS keeps failing . ERRORSOURCE = DSO

ERROR:

Maybe you have to turn on the 'execute on main thread' option !
You can find it on the workflow properties in your DTS-Package !

|||i just checked. it is set to run on the main process. that box is checked.|||

Winston,

Were you able to find a solution or the cause to this problem? This error has started to occur when I try to process a cube on Analysis Services 2000.

Thanks,

Jake

|||

In the past, I got the same kind of error !

My error occured because my 'Navision-odbc-driver' did NOT support multithreading ! In other words, executing tasks simultaneously caused my error !

To solve that error: On every workflow, I turned on the 'execute on main thread' option !

Kind regards,

Geert G.

Analysis service does not remain started

I have installed SQL Server 2005 Standard Edition for our Team Foundation Server install. I have verified the installation and all seems well, except that the Analysis Services service does not remain started. I get a message like "Some services stop if there is nothing to do." The Analysis service needs to be running in order for the TFS install to succeed. How can I get the Analysis Services service to remain started?

Thanks in Advance

Are you using the autostart parameters during install? The default is to not start these services. Here's the snippet from template.ini:

;--
; To use the *AUTOSTART features, specify 1 to start automatically or 0 to start manually.
; NOTE: If you decide to start SQL Agent automatically, then SQL is also started automatically.
; If *AUTOSTART is not specified on the command line, startup is set to manual.

SQLBROWSERAUTOSTART=0
SQLAUTOSTART=0
AGTAUTOSTART=0
ASAUTOSTART=0
RSAUTOSTART=0

Thanks,
Samuel Lester (MSFT)

|||I didn't use those parameters - I followed the "How To: Install SQL Server 2005 for Team Foundation Server" doc. I installed it all interactively.|||

Since the default is to not start these services, this should be the correct behavior then. Are you checking the box during install to autostart the services?

Thanks,
Sam Lester (MSFT)

|||Yes. The problem is that Team Foundation Server will not install if the Analysis Services service is not running, and it is not. When I start it, it stops immediately.|||

Ah, so after installing SQL, the AS service does not start? I thought you were looking to autostart during install. Can you send the exact error message that you get after starting it? Are there any messages in event viewer? And are you trying to connect with a domain account or with local system?

Thanks,
Sam

sql

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 Service Connection Pooling

In SQL Server documentation it is mentioned that the SP3 Code sample contains
the Analysis Service Connection Pooling sample. Please help me in locating
the code sample.
Thanks in advance.
Manoj
http://msdn.microsoft.com/library/de...onnpooling.asp
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Manoj" <Manoj@.discussions.microsoft.com> wrote in message
news:AF17E419-ED8D-4E97-AA3D-76A06BCFD465@.microsoft.com...
> In SQL Server documentation it is mentioned that the SP3 Code sample
contains
> the Analysis Service Connection Pooling sample. Please help me in locating
> the code sample.
> Thanks in advance.
> Manoj

analysis service 2005: microsoft association rules problem

Hi there,

i'm new to this forum .. Maybe my way of expression is not very good, but I hope to be understandable.

I've a sql server 2005 database with 90 columns and more or less 185 thousands records. I've to run microsoft associations rules on my laptop (sony vaio sz3, core 2 duo, 2gb ram).

The problems is that the amount of ram seems not to be enough [it starts to swap when it's reading 240th case)

Because of this, i decided to sample my data by extracting 10thousands records randomnly ... it lasts 25minutes (more or less) now, but it's still to much...

Does a better way exists? What's the problem: column or row numbers?

hope you guys can help me.

There is a known issue with certain association rules models running out of memory but it's not very common (A fix is available through Microsoft Support).

The pointers in this thread might also be useful: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1613732&SiteID=1

Can you post your mining structure/model definition?

|||

The problem with association rules is usually the parameters you set on the algorithm.

Try this - first create the structure/model and deploy without processing. Then to a process Structure Only to verify that there isn't a problem is just accessing the data.

If that works fine, then set the model parameter MINIMUM_SUPPORT very high - say 0.80. This means that only items that occur in 80% of the cases will be counted. Since you have dense data this could be an issue. Then you can gradually lower your minimum support to see how it impacts performance and your results. Additionally, since you do have dense data (e.g. all attributes on a single row) it is possible that you have some data that simply isn't interesting because it is true for everyone or almost everyone. You can set MAXIMUM_SUPPORT to a number lower than 1, for example setting it to 0.9 will eliminate all items and itemsets that occur in 90% or more of cases.

HTH

-Jamie

analysis service

How to update a cube using SSIS?Use the Analysis Services Processing Task (see http://www.databasejournal.com/features/mssql/article.php/10894_3584306_2) for more details.sql

analysis service

How to update a cube using SSIS?Use the Analysis Services Processing Task (see http://www.databasejournal.com/features/mssql/article.php/10894_3584306_2) for more details.

analysis service

Hi

I was doing steps on page 15 / 16 of attached sheet

I was doing the microsoft example about cube to setup DSN SOURCE CONNECTION to ACCESS database (food mart) when i do a test it works

but after i do design storage and go to Process the cube
it gives me error

'test connection failed because of an error in initializing provide
(microsoft) ODBC DRIVER manager data source name not found and no default driver specified

one more error found
Microsoft ODBC DRIVER MANAGER driver sql connect attr failed: IMOO6

ThanksOriginally posted by sjumma
Hi

I was doing steps on page 15 / 16 of attached sheet

I was doing the microsoft example about cube to setup DSN SOURCE CONNECTION to ACCESS database (food mart) when i do a test it works

but after i do design storage and go to Process the cube
it gives me error

'test connection failed because of an error in initializing provide
(microsoft) ODBC DRIVER manager data source name not found and no default driver specified

one more error found
Microsoft ODBC DRIVER MANAGER driver sql connect attr failed: IMOO6

Thanks

Ensure you have applied SP3. I'm pretty sure there is an MDAC upgrade.|||Hi

I have already upgraded with the patch but still does not work

Analysis Server Service Pack

How can I check to see if Service Pack 3a is loaded on my Analysis Server? I thought that the Analysis Server used the same service pack because it is all SQL Server?
Rich,
[vbcol=seagreen]
Server?
Refer the below snippet from sp3a readme.txt
(http://support.microsoft.com/support.../SP3ReadMe.asp)
<begin quote>
Analysis Services
To identify which version of Analysis Services you have installed, follow
these steps:
1.. From the Start menu, point to Program Files, point to SQL Server 2000,
point to Analysis Services, and then click Analysis Manager.
2.. In the Analysis Manager tree, right-click the Analysis Servers node,
and then click About Analysis Services.
3.. Use the following table to determine which version of Analysis
Services you have.
Analysis Services version Build Number in Help About
SQL Server 2000 Analysis Services Original Release 8.0.194
Analysis Services SP1 8.0.382
Analysis Services SP2 8.0.534
Analysis Services SP3 or SP3a 8.0.760
<end quote>
[vbcol=seagreen]
is all SQL Server?
No.You will find more info in the above url.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"rich" <anonymous@.discussions.microsoft.com> wrote in message
news:B2D5E832-2263-42A1-A6F4-92E81284D255@.microsoft.com...
> How can I check to see if Service Pack 3a is loaded on my Analysis Server?
I thought that the Analysis Server used the same service pack because it is
all SQL Server?
|||To get the actual build number (including any hotfixes, and information on
where they came from), scroll down http://www.aspfaq.com/2160
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"rich" <anonymous@.discussions.microsoft.com> wrote in message
news:B2D5E832-2263-42A1-A6F4-92E81284D255@.microsoft.com...
> How can I check to see if Service Pack 3a is loaded on my Analysis Server?
I thought that the Analysis Server used the same service pack because it is
all SQL Server?

Analysis Server Service Pack

How can I check to see if Service Pack 3a is loaded on my Analysis Server? I thought that the Analysis Server used the same service pack because it is all SQL Server?Rich,
>> How can I check to see if Service Pack 3a is loaded on my Analysis
Server?
Refer the below snippet from sp3a readme.txt
(http://support.microsoft.com/support/servicepacks/SQL/2000/SP3ReadMe.asp)
<begin quote>
Analysis Services
To identify which version of Analysis Services you have installed, follow
these steps:
1.. From the Start menu, point to Program Files, point to SQL Server 2000,
point to Analysis Services, and then click Analysis Manager.
2.. In the Analysis Manager tree, right-click the Analysis Servers node,
and then click About Analysis Services.
3.. Use the following table to determine which version of Analysis
Services you have.
Analysis Services version Build Number in Help About
SQL Server 2000 Analysis Services Original Release 8.0.194
Analysis Services SP1 8.0.382
Analysis Services SP2 8.0.534
Analysis Services SP3 or SP3a 8.0.760
<end quote>
>>I thought that the Analysis Server used the same service pack because it
is all SQL Server?
No.You will find more info in the above url.
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"rich" <anonymous@.discussions.microsoft.com> wrote in message
news:B2D5E832-2263-42A1-A6F4-92E81284D255@.microsoft.com...
> How can I check to see if Service Pack 3a is loaded on my Analysis Server?
I thought that the Analysis Server used the same service pack because it is
all SQL Server?|||To get the actual build number (including any hotfixes, and information on
where they came from), scroll down http://www.aspfaq.com/2160
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"rich" <anonymous@.discussions.microsoft.com> wrote in message
news:B2D5E832-2263-42A1-A6F4-92E81284D255@.microsoft.com...
> How can I check to see if Service Pack 3a is loaded on my Analysis Server?
I thought that the Analysis Server used the same service pack because it is
all SQL Server?

Analysis Server Service Pack

How can I check to see if Service Pack 3a is loaded on my Analysis Server?
I thought that the Analysis Server used the same service pack because it is
all SQL Server?Rich,

Server?
Refer the below snippet from sp3a readme.txt
(http://support.microsoft.com/suppor...0/SP3ReadMe.asp)
<begin quote>
Analysis Services
To identify which version of Analysis Services you have installed, follow
these steps:
1.. From the Start menu, point to Program Files, point to SQL Server 2000,
point to Analysis Services, and then click Analysis Manager.
2.. In the Analysis Manager tree, right-click the Analysis Servers node,
and then click About Analysis Services.
3.. Use the following table to determine which version of Analysis
Services you have.
Analysis Services version Build Number in Help About
SQL Server 2000 Analysis Services Original Release 8.0.194
Analysis Services SP1 8.0.382
Analysis Services SP2 8.0.534
Analysis Services SP3 or SP3a 8.0.760
<end quote>
[vbcol=seagreen]
is all SQL Server?
No.You will find more info in the above url.
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"rich" <anonymous@.discussions.microsoft.com> wrote in message
news:B2D5E832-2263-42A1-A6F4-92E81284D255@.microsoft.com...[vbcol=seagreen]
> How can I check to see if Service Pack 3a is loaded on my Analysis Server?
I thought that the Analysis Server used the same service pack because it is
all SQL Server?|||To get the actual build number (including any hotfixes, and information on
where they came from), scroll down http://www.aspfaq.com/2160
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"rich" <anonymous@.discussions.microsoft.com> wrote in message
news:B2D5E832-2263-42A1-A6F4-92E81284D255@.microsoft.com...
> How can I check to see if Service Pack 3a is loaded on my Analysis Server?
I thought that the Analysis Server used the same service pack because it is
all SQL Server?sql

Analysis Server Repository

Ok .. I know it is my mistake ...
I deleted the Analysis Server Repository database from my development server ...
Is there a way to rebuild it from the files ...
Help Me !!!!!!!!!!!!!Do you have a backup?|||Hmm ... you must be wondering what kind of DBA I am ..

Well ... it was the development server i was asked to clean up ...

And along with the database I deleted the backups too ...|||Originally posted by Enigma
Hmm ... you must be wondering what kind of DBA I am ..

Well ... it was the development server i was asked to clean up ...

And along with the database I deleted the backups too ...

Enigma

Can you clarify that the Analysis Repository was running as a SQL database? I under the impression that the repository is normally an access database which you can upgrade to SQL and if upgraded is then stored in MSDB.|||Yup .. you are right ...

However the repository can be configured to run from a SQL DB also|||Originally posted by Enigma
Yup .. you are right ...

However the repository can be configured to run from a SQL DB also

Mmm sorry Engima but I think that without backups you might be in trouble. I take it there was no tape/file backup of the backup files.|||the repository should be configured to run from a SQL DB

After installing AS you should Migrate Repository

Analysis Server on Windows 2003

Hi all,
I am having trouble getting Analysis server to run on my Windows 2003, are
there any KNOWN compatibility issues?
Thanks...MWhat kind of problems are you running into?
--
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michelle" <smiley2211@.yahoo.com> wrote in message
news:eq8VC22SFHA.2916@.TK2MSFTNGP15.phx.gbl...
> Hi all,
> I am having trouble getting Analysis server to run on my Windows 2003, are
> there any KNOWN compatibility issues?
> Thanks...M
>|||Hi,
Check the article below
http://support.microsoft.com/defaul...kb;en-us;815486
HTH
Andreas
"Dave Wickert [MSFT]" wrote:

> What kind of problems are you running into?
> --
> Dave Wickert [MSFT]
> dwickert@.online.microsoft.com
> Program Manager
> BI SystemsTeam
> SQL BI Product Unit (Analysis Services)
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> "Michelle" <smiley2211@.yahoo.com> wrote in message
> news:eq8VC22SFHA.2916@.TK2MSFTNGP15.phx.gbl...
>
>|||Morning Dave,
We get the following error when trying to register AS...
"errors connecting to MYSERVER - incompatible repository"
Thanks...M
"Andreas Mavrogenis" <AndreasMavrogenis@.discussions.microsoft.com> wrote in
message news:E52B35EA-89EF-4FBF-AC5F-10E72A515300@.microsoft.com...[vbcol=seagreen]
> Hi,
> Check the article below
> http://support.microsoft.com/defaul...kb;en-us;815486
> HTH
> Andreas
> "Dave Wickert [MSFT]" wrote:
>|||Sorry. I've never heard of that one.
I'd post it on microsoft.public.sqlserver.olap and possible one of the PSS
engineers will pick it up.
The only other posting that I've seen is the kb article:
http://support.microsoft.com/defaul...kb;en-us;288890
--
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michelle" <smiley2211@.yahoo.com> wrote in message
news:%23UHMPB$SFHA.3392@.TK2MSFTNGP12.phx.gbl...
> Morning Dave,
> We get the following error when trying to register AS...
> "errors connecting to MYSERVER - incompatible repository"
> Thanks...M
> "Andreas Mavrogenis" <AndreasMavrogenis@.discussions.microsoft.com> wrote
in
> message news:E52B35EA-89EF-4FBF-AC5F-10E72A515300@.microsoft.com...
2003,[vbcol=seagreen]
>|||Hi All,
Thanks for your help...it was Andreas recommendation that solved my
problem...I needed SP3 for Analysis server installed.
---
Check the article below
---
Thanks...M
"Dave Wickert [MSFT]" <dwickert@.online.microsoft.com> wrote in message
news:%23MTJd$ETFHA.3212@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> Sorry. I've never heard of that one.
> I'd post it on microsoft.public.sqlserver.olap and possible one of the PSS
> engineers will pick it up.
> The only other posting that I've seen is the kb article:
> http://support.microsoft.com/defaul...kb;en-us;288890
> --
> Dave Wickert [MSFT]
> dwickert@.online.microsoft.com
> Program Manager
> BI SystemsTeam
> SQL BI Product Unit (Analysis Services)
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Michelle" <smiley2211@.yahoo.com> wrote in message
> news:%23UHMPB$SFHA.3392@.TK2MSFTNGP12.phx.gbl...
> in
> 2003,
>

Analysis Server on Windows 2003

Hi all,
I am having trouble getting Analysis server to run on my Windows 2003, are
there any KNOWN compatibility issues?
Thanks...M
What kind of problems are you running into?
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michelle" <smiley2211@.yahoo.com> wrote in message
news:eq8VC22SFHA.2916@.TK2MSFTNGP15.phx.gbl...
> Hi all,
> I am having trouble getting Analysis server to run on my Windows 2003, are
> there any KNOWN compatibility issues?
> Thanks...M
>
|||Hi,
Check the article below
http://support.microsoft.com/default...b;en-us;815486
HTH
Andreas
"Dave Wickert [MSFT]" wrote:

> What kind of problems are you running into?
> --
> Dave Wickert [MSFT]
> dwickert@.online.microsoft.com
> Program Manager
> BI SystemsTeam
> SQL BI Product Unit (Analysis Services)
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Michelle" <smiley2211@.yahoo.com> wrote in message
> news:eq8VC22SFHA.2916@.TK2MSFTNGP15.phx.gbl...
>
>
|||Morning Dave,
We get the following error when trying to register AS...
"errors connecting to MYSERVER - incompatible repository"
Thanks...M
"Andreas Mavrogenis" <AndreasMavrogenis@.discussions.microsoft.com> wrote in
message news:E52B35EA-89EF-4FBF-AC5F-10E72A515300@.microsoft.com...[vbcol=seagreen]
> Hi,
> Check the article below
> http://support.microsoft.com/default...b;en-us;815486
> HTH
> Andreas
> "Dave Wickert [MSFT]" wrote:
|||Sorry. I've never heard of that one.
I'd post it on microsoft.public.sqlserver.olap and possible one of the PSS
engineers will pick it up.
The only other posting that I've seen is the kb article:
http://support.microsoft.com/default...b;en-us;288890
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michelle" <smiley2211@.yahoo.com> wrote in message
news:%23UHMPB$SFHA.3392@.TK2MSFTNGP12.phx.gbl...
> Morning Dave,
> We get the following error when trying to register AS...
> "errors connecting to MYSERVER - incompatible repository"
> Thanks...M
> "Andreas Mavrogenis" <AndreasMavrogenis@.discussions.microsoft.com> wrote
in[vbcol=seagreen]
> message news:E52B35EA-89EF-4FBF-AC5F-10E72A515300@.microsoft.com...
2003,
>
|||Hi All,
Thanks for your help...it was Andreas recommendation that solved my
problem...I needed SP3 for Analysis server installed.
Check the article below[vbcol=seagreen]
Thanks...M
"Dave Wickert [MSFT]" <dwickert@.online.microsoft.com> wrote in message
news:%23MTJd$ETFHA.3212@.TK2MSFTNGP10.phx.gbl...
> Sorry. I've never heard of that one.
> I'd post it on microsoft.public.sqlserver.olap and possible one of the PSS
> engineers will pick it up.
> The only other posting that I've seen is the kb article:
> http://support.microsoft.com/default...b;en-us;288890
> --
> Dave Wickert [MSFT]
> dwickert@.online.microsoft.com
> Program Manager
> BI SystemsTeam
> SQL BI Product Unit (Analysis Services)
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Michelle" <smiley2211@.yahoo.com> wrote in message
> news:%23UHMPB$SFHA.3392@.TK2MSFTNGP12.phx.gbl...
> in
> 2003,
>

Analysis Server not working with MSDE SQL Server

I installed Visual Studio .NET v.1.0 and the included MSDE version of
SQL Server. I have an additional copy of MS SQL Server 2000 Enterprise
Ed. on CD. I installed Microsoft Analysis Services from this CD on my
machine with MSDE SQL Server; it appeared to install cleanly.
I ran Analysis Manager from the Start menu under Windows XP Pro. The
local SQL Server showed red block indicating the server was not
running. I tried to connect, and got the following error message:
Unable to connect to the registry on the server (myserver_name), or you
are not a member of the OLAP Administrators group on this server.
Does anyone know the problem here? I was wondering whether I had to
install MS SQL Server enterprise ed. to use Analysis Server with it,
rather than more limited MSDE version of SQL Server ?!
Thanks all.
Fred Z.
hi Fred,
silversw2000@.yahoo.com wrote:
> I installed Visual Studio .NET v.1.0 and the included MSDE version of
> SQL Server. I have an additional copy of MS SQL Server 2000 Enterprise
> Ed. on CD. I installed Microsoft Analysis Services from this CD on my
> machine with MSDE SQL Server; it appeared to install cleanly.
> I ran Analysis Manager from the Start menu under Windows XP Pro. The
> local SQL Server showed red block indicating the server was not
> running. I tried to connect, and got the following error message:
> Unable to connect to the registry on the server (myserver_name), or
> you are not a member of the OLAP Administrators group on this server.
> Does anyone know the problem here? I was wondering whether I had to
> install MS SQL Server enterprise ed. to use Analysis Server with it,
> rather than more limited MSDE version of SQL Server ?!
> Thanks all.
> Fred Z.
I do not think Analysis Service is supported on MSDE..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Analysis Server Memory Upgrade

Dear Anyone,

We recently upgraded our analysis server from a 4GB to 8GB. For a couple of weeks, we noticed that the server memory isnt going up to close to 8GB and only goes to around 4. We use the /3Gb and /PAE on our server.

Can anyone recommend some memory tweaks that we can use on the Analysis Services?

Thanks,

Joseph

Unfortunately in this case having more memory is not going to help.

32 bit version of Analysis Server will not use more than 3Gb of memory.

You should move to 64 bit hardware to be able to take advantage of more memory of your system.
In AS 2005 you should be able to install multiple instances and distribute your databases across instances.

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

|||

Just want to clarify that this 3GB limitation is on Analysis Services 2005? I thought the memory limitation was for Analysis Services 2005 got a lot bigger from that of the 2000 version. I'm I wrong in thinking this?

Furthermore, can anyone please share the maximum memory configuration we can give Analysis Services 2005 to maximize the available memory? I.e. Analysis 2005 is on a box with 8GB of memory.

|||

Memory limitations for AS2K5 are the same as AS2K -- they are based on the OS (see earlier post).

Therefore to use 8GB of memory you must be running on a 64-bit platform, as a native 64-bit application.

That being said however, what might be confusing you, is that memory usage in AS2K5 has gotten a while lot more efficient. We now have a dimension memory cache, replicas used for dimension security are smaller and more efficient, etc. Thus you can do more with what you have.

But our general advise is still the same -- running on 32-bit hardware, there is no reason to have more than 4GB on your server. See the AS Operations Guide for more guidelines like this:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx

Hope that helps.

_-_-_ Dave

sql

Analysis Server Hangs

Guys,

I have been getting a very peculiar problem while i am processing a dimention with about approx 7 million (68 lakh) rows. The processing wizard shows the rows being read and once the rows are read from SQL server , the Analysis Manager Hangs. Can anyone help me out ? Is this a limitation of Analysis manager not being able to process such huge amount of data or are there some settings that i can tweak.Hi enigma,
Do you meant to say by seeing in'Task Manager/ Application'. showing 'Not Responding' ? You try watch using performance counter/AS:Proc:,AS:Agg.Proc objects, after some time, you will get some values related to that. In my case also, I was getting 'this hanging sort of things' but actually it is not.
HTH
====

Originally posted by Enigma
Guys,

I have been getting a very peculiar problem while i am processing a dimention with about approx 7 million (68 lakh) rows. The processing wizard shows the rows being read and once the rows are read from SQL server , the Analysis Manager Hangs. Can anyone help me out ? Is this a limitation of Analysis manager not being able to process such huge amount of data or are there some settings that i can tweak.|||Thanks Man,

I was doing exactly the thing you said ... well .. i processed the cube using a DTS yesterday and that worked perfectly fine .

Thanks for all your help

Analysis server for Business people

How can we impliment the sqlserver analysis to the customer site for analysing the transaction. Please provide me the solution for this. Is it possible for the business people use this analysis server for their transaction. What we have to do to impliment this in customer site .

Please kindly advice

Try to talk to microsoft consulting serivces in your area for help with implementing solution to analyze your transactional data. I am sure they would help you to come up with some ideas and will help you implementing them.

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

Tuesday, March 27, 2012

Mastering OLAP Reports: Parameters for Analysis Services Reporting ...

Sunday, March 25, 2012

Blog Archive

About Me