Re: Can't connect to / see cube

From: Dave Wickert [MSFT] (dwickert_at_online.microsoft.com)
Date: 10/25/04


Date: Mon, 25 Oct 2004 11:14:43 -0700

Two possibilities typically occur:
1) either you have an old version of PTS on your client machine (run
ptslite.exe from the SP3 Analysis Services distribution), or
2) you don't have security rights to the cube, i.e. if you've not included
the everyone role. Foodmart has such a role, and thus you can see it.

-- 
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.
"Kaisa" <kaisaremoveml@hotmail.com> wrote in message
news:%23QRcNQpuEHA.2804@TK2MSFTNGP14.phx.gbl...
> Need some input please.
> I have a development domain, with one server running SQL Server 2000 sp
> 3 Enterprise edition, Analysis Services Sp 3 Enterprise Edition and
> REporting Services.
>
> I used to be able to connect to my databases in Analysis Services, but
> today I updated one of them, and now I can't connect to it. I can log
> into the server, and see my Foodmart demo base. But I can't see my new
> database.
>
> I restored the database from a cab-file, and it restored OK. I can
> prosess 2 out of 4 individual cubes. If I right-click the database and
> choose "Process the Database", it fails to process. There seems to be a
> problem with the database.
>
> Is this why I can't connect to the database / cubes from other
> computers? I can log on using http and the right username and password,
> and I get to see Foodmart, but not the database / cubes I want to work
> with.
>
> Please advise, or at least give a hint on where I can find more info.
>
> Kaisa
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!


Relevant Pages

  • Re: Manually forcing an OLAP database to refresh its data
    ... SQL BI Product Unit ... Will choosing "Process Database" ... >> Don't forget you can use a job (in server A) to schedule processing. ... >>> tried choosing the database in Analysis Services manager on Server B ...
    (microsoft.public.sqlserver.olap)
  • Tell Me About Your DW Development Life Cycle
    ... What are some good ways to get development cubes into ... I currently use a developer's edition of SQL Server 2000 ... Connect to the production server via VPN and run the ... Analysis Services Server and rebuild cubes. ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: Cube Processing Failure - no error message
    ... See the Analysis Services Operations Guide in the "Processing log file" ... some of the cubes in a cube database ...
    (microsoft.public.sqlserver.olap)
  • Re: Crear estructura base de datos
    ... OLAP database without the cube data. ... This TechNet paper: "Microsoft SQL ... To move an Analysis Services database from the development environment ... server using this method for release management, ...
    (microsoft.public.sqlserver.olap)
  • DSO and Analysis Services 2005
    ... DSO>' in der Datei 'msmdsrv.ini' in Analysis Services 9.0). ... "Microsoft OLE DB Provider for Analysis Services 9.0", set as Server ... "localhost" and could choose one of the active database. ... The part of mein Script: ...
    (microsoft.public.sqlserver.olap)