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(.[Orderdetails], INCLUDE_STATISTICS, EXCLUSIVE), $ADJUSTEDPROBABILITY, 3)
FROM

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
.[Cusid] = [T1].[Cusid] AND
.[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?
>