Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Analysis Services Newbie

  
   Database Forums (Home) -> OLAP RSS
Next:  Copy logins from sql database to a role in Analys..  
Author Message
A.B.

External


Since: Aug 08, 2005
Posts: 7



(Msg. 1) Posted: Thu Sep 01, 2005 11:33 am
Post subject: Analysis Services Newbie
Archived from groups: microsoft>public>sqlserver>olap (more info?)
I have just installed analysis services and I am going thourgh the tutorial,
Quick Start. I followed the dirctions but after I make the first dimension it
will not let me preview the dimension it says "Unable to browse the Dimension
"New Dimension" Unspecified error" in the preview window. I went ahead and
made the rest but they all said the same thing. Also it would not let me
browse the cube data after I made the dimensions. I thought it might be the
connection but it is showing me the tables and columns from the database
though.

Adam

 >> Stay informed about: Analysis Services Newbie 
Back to top
Login to vote
A.B.

External


Since: Aug 08, 2005
Posts: 7



(Msg. 2) Posted: Thu Sep 01, 2005 2:13 pm
Post subject: RE: Analysis Services Newbie [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
I started over and now the error message in the preview window says there is
a error with the provider and the provider may not be installed properly.
Should I unistall Analysis Services and reinstall or is there something else
check first.

Adam

"A.B." wrote:

> I have just installed analysis services and I am going thourgh the tutorial,
> Quick Start. I followed the dirctions but after I make the first dimension it
> will not let me preview the dimension it says "Unable to browse the Dimension
> "New Dimension" Unspecified error" in the preview window. I went ahead and
> made the rest but they all said the same thing. Also it would not let me
> browse the cube data after I made the dimensions. I thought it might be the
> connection but it is showing me the tables and columns from the database
> though.
>
> Adam

 >> Stay informed about: Analysis Services Newbie 
Back to top
Login to vote
uros

External


Since: Jun 21, 2005
Posts: 4



(Msg. 3) Posted: Thu Sep 01, 2005 11:46 pm
Post subject: RE: Analysis Services Newbie [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Have your processed the cube?
If not,try processing the entire database and on Browser click Reconnect.



"A.B." wrote:

> I started over and now the error message in the preview window says there is
> a error with the provider and the provider may not be installed properly.
> Should I unistall Analysis Services and reinstall or is there something else
> check first.
>
> Adam
>
> "A.B." wrote:
>
> > I have just installed analysis services and I am going thourgh the tutorial,
> > Quick Start. I followed the dirctions but after I make the first dimension it
> > will not let me preview the dimension it says "Unable to browse the Dimension
> > "New Dimension" Unspecified error" in the preview window. I went ahead and
> > made the rest but they all said the same thing. Also it would not let me
> > browse the cube data after I made the dimensions. I thought it might be the
> > connection but it is showing me the tables and columns from the database
> > though.
> >
> > Adam
 >> Stay informed about: Analysis Services Newbie 
Back to top
Login to vote
A.B.

External


Since: Aug 08, 2005
Posts: 7



(Msg. 4) Posted: Fri Sep 02, 2005 6:30 am
Post subject: RE: Analysis Services Newbie [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
I tried but it keeps giving me the same error message. That the provider may
not be installed right. How would I go about cheking that or reinstalling
that?

Adam

"uros" wrote:

> Have your processed the cube?
> If not,try processing the entire database and on Browser click Reconnect.
>
>
>
> "A.B." wrote:
>
> > I started over and now the error message in the preview window says there is
> > a error with the provider and the provider may not be installed properly.
> > Should I unistall Analysis Services and reinstall or is there something else
> > check first.
> >
> > Adam
> >
> > "A.B." wrote:
> >
> > > I have just installed analysis services and I am going thourgh the tutorial,
> > > Quick Start. I followed the dirctions but after I make the first dimension it
> > > will not let me preview the dimension it says "Unable to browse the Dimension
> > > "New Dimension" Unspecified error" in the preview window. I went ahead and
> > > made the rest but they all said the same thing. Also it would not let me
> > > browse the cube data after I made the dimensions. I thought it might be the
> > > connection but it is showing me the tables and columns from the database
> > > though.
> > >
> > > Adam
 >> Stay informed about: Analysis Services Newbie 
Back to top
Login to vote
Thadeus Anand

External


Since: Jun 23, 2005
Posts: 1



(Msg. 5) Posted: Sat Sep 03, 2005 10:58 am
Post subject: Re: Analysis Services Newbie [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
I suspect that you might have installed Analysis Services on a server
set up as a Win 2000 Domain Controller. To my little knowledge, you are
not supposed to run analysis services on a domain controller.

I have faced similar problems long ago, and then I reinstalled Win 2K
Server & just skipped the server configuration and then proceeded to
install SQL 2K and AS. Then I was able to browse my cube and dimension
data without any problems.

Hope this helps.
 >> Stay informed about: Analysis Services Newbie 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
sql 2005 analysis services - Does anyone know where I can get SQL 2005 analysis services tutorial? Thanks.

Analysis Newbie Q about Client - I've been reading through BOL about Analysis Servies on Sql Server 2000 because we just installed it on one of our dev servers and want to play around with it. But one thing I don't understand: what do I install on my laptop to access Analysis..

DSO Application with Analysis Services 2005 - I have an application that uses DSO to define and populate cubes which works on the AS2000 platform. I am trying to evaluate how easily this can be ported to SQL 2005 platform. I have installed SQL 2005 on a server and running a test app to connect ....

PERL for Analysis services - I want to use Perl which as rich charting and dashboarding facility against Analysis Services. Appreciate if you could share what Perl to analysis services access over OLEDB/ADO is available and experiences. Also please provide who provides PERL..

Clustering Analysis Services - We are in the process of deploying AS on a Active-Passive SQL Server 2000 MSCS cluster. I understand there is a MS white paper on how to cluster it which requires lots of manual changes. If we were to follow this paper, would it be possible to have th...
   Database Forums (Home) -> OLAP All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]