Cannot open offline cube

Hi,

I created an offline cube file (.cub) using SSAS 2005 sp1. I tried to open the cube file by following these steps:

1. Open excel 2003. On the toolbar, click on Data and select PivotTable and PivotChart report.

2. Select External data source as the data you want to analyze then click on next.

3. Click on the Get Data button on the next step.

4. Choose the OLAP Cubes tab on the pop-up window, select <New Data Source> and Click OK.

5. Type "Sales" as the name of the data source.

6.Choose Microsoft OLE DB Provider for Analysis Services 9.0 as the OLAP provider. Click on Connect button

7. Select the cube file option and browse for the location of the cube file. Click Finish.

8. On the fourth step (here comes the problem),on the Select the Cube that contains the data you want list, nothing is available in the dropdown list. And since I cannot finish this step, the OK button remains disabled and I was not able to open the cube file.

Can any one help me on this?

Thanks in advance,

Destry

I have exactly the same problem, as a matter of fact I was about to ask that question.

Should you find a workaround on your own, I would appreciate it if you could post it here as well too. Tia.

|||

There are several things can be going wrong. Here are several ideas for you to try.

1. Try and use Microsoft OLE DB Provider for Analysis Services 8.0 to connect to your local cube.

2. Try and use MDXSample application. In the connection dialog, as server name specify a path to your local cube file. Something like c:\my cubes\cube1.cub. If you can connect and but cant see cube name there, most likely something wrong with your local cube file.

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

Cannot make server as Target server or link from Master Server

Sql Server 7 Standard Edition
My Server was renamed and the normal steps of reinstalling
and running sp_dropserver and sp_addserver were followed.
Everything seems to work fine but jobs from the master server.
I did defect the server as a target server since it appeared as offline
anyway.

On trying to re establish the status of the server as a target server

Failed to make "serverName" a target server
Enlist into Master Server "MasterServerName" Failed(Error 14262)

Your insight is appreciated
Vincento"Vincento Harris" <wumutek@.yahoo.com> wrote in message
news:2fa13ee7.0405100422.632f4324@.posting.google.c om...
> Sql Server 7 Standard Edition
> My Server was renamed and the normal steps of reinstalling
> and running sp_dropserver and sp_addserver were followed.
> Everything seems to work fine but jobs from the master server.
> I did defect the server as a target server since it appeared as offline
> anyway.
>
> On trying to re establish the status of the server as a target server
> Failed to make "serverName" a target server
> Enlist into Master Server "MasterServerName" Failed(Error 14262)
> Your insight is appreciated
> Vincento

Is @.@.SERVERNAME returning the correct (new) name? Error 14262 should be "The
specified %s ('%s') does not exist" - what is the full error message you
see? Are there any name resolution issues, ie. can both servers see each
other (ping.exe or NET VIEW) on the network?

Simon|||"Simon Hayes" <sql@.hayes.ch> wrote in message news:<409fc26e$1_1@.news.bluewin.ch>...
> "Vincento Harris" <wumutek@.yahoo.com> wrote in message
> news:2fa13ee7.0405100422.632f4324@.posting.google.c om...
> > Sql Server 7 Standard Edition
> > My Server was renamed and the normal steps of reinstalling
> > and running sp_dropserver and sp_addserver were followed.
> > Everything seems to work fine but jobs from the master server.
> > I did defect the server as a target server since it appeared as offline
> > anyway.
> > On trying to re establish the status of the server as a target server
> > Failed to make "serverName" a target server
> > Enlist into Master Server "MasterServerName" Failed(Error 14262)
> > Your insight is appreciated
> > Vincento
> Is @.@.SERVERNAME returning the correct (new) name? Error 14262 should be "The
> specified %s ('%s') does not exist" - what is the full error message you
> see? Are there any name resolution issues, ie. can both servers see each
> other (ping.exe or NET VIEW) on the network?
> Simon

Thanks for your response.
@.@.servername returns the right value.
I did forget to mention that the master server is sql server 2000 and
target server, sql server 7.
When the master server is pinged from the client it returns packets
with no error.

When originating_server is selected from sysjobs it returns 'local'

I did notice that the target server name has been added as an alias
when you open
the client network utilities.Not sure if that will make any difference

This is the exact error message

Failed to make "serverName" a target server
Enlist into Master Server "MasterServerName" Failed(Error 14262)

Vincento|||"Vincento Harris" <wumutek@.yahoo.com> wrote in message
news:2fa13ee7.0405110339.23cb3558@.posting.google.c om...
> "Simon Hayes" <sql@.hayes.ch> wrote in message
news:<409fc26e$1_1@.news.bluewin.ch>...
> > "Vincento Harris" <wumutek@.yahoo.com> wrote in message
> > news:2fa13ee7.0405100422.632f4324@.posting.google.c om...
> > > Sql Server 7 Standard Edition
> > > My Server was renamed and the normal steps of reinstalling
> > > and running sp_dropserver and sp_addserver were followed.
> > > Everything seems to work fine but jobs from the master server.
> > > I did defect the server as a target server since it appeared as
offline
> > > anyway.
> > > > > > On trying to re establish the status of the server as a target server
> > > > Failed to make "serverName" a target server
> > > Enlist into Master Server "MasterServerName" Failed(Error 14262)
> > > > Your insight is appreciated
> > > Vincento
> > Is @.@.SERVERNAME returning the correct (new) name? Error 14262 should be
"The
> > specified %s ('%s') does not exist" - what is the full error message you
> > see? Are there any name resolution issues, ie. can both servers see each
> > other (ping.exe or NET VIEW) on the network?
> > Simon
>
> Thanks for your response.
> @.@.servername returns the right value.
> I did forget to mention that the master server is sql server 2000 and
> target server, sql server 7.
> When the master server is pinged from the client it returns packets
> with no error.
> When originating_server is selected from sysjobs it returns 'local'
> I did notice that the target server name has been added as an alias
> when you open
> the client network utilities.Not sure if that will make any difference
> This is the exact error message
> Failed to make "serverName" a target server
> Enlist into Master Server "MasterServerName" Failed(Error 14262)
> Vincento

It sounds as if everything is OK - the only thing I can think of is that the
alias in the client network utilities might still have the old server name?
Also, can you create a working linked server from the SQL2000 server to the
SQL7 one? If not, then there is probably sort of name resolution issue. But
if you can, then I have no idea what the issue is - probably time to call
Microsoft.

Simon