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

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

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 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.