olap_user


Hello everyone,


I have a problem in creating the local cube in MSAS2005. This is what I have done please guide me to solve the issue.

Steps:

  1. We have installed MSAS2005 with SP1 on Dev box
  2. I created cubes on BI Studio (linked to dev box from my local pc)
  3. I can see the cubes from MSMS (linked to dev box from my local pc)
  4. Then I tried to CREATE GLOBAL CUBE myCube

Storage ¡®c:mylocalcube.cub¡¯

From myCube

(MEASURE [myCube].[ORDERS],

DIMENSION [myCube].[Time].[Year - Quarter - Month],

DIMENSION [myCube].[All Invoices].[Inv Number])

  1. I got error message ¡¯ A connection cannot be made. Ensure that the server is running.¡¯
  2. MSAS2005 server is running. I can view the cubes from MSMS

Please tell me if I am missing something and also help me to resolve the issue.

Thanks



Re: create local cube issue

Irina Gorbach


You are missing a backslash:

c:mylocalcube.cub

should be

c:\mylocalcube.cub







Re: create local cube issue

olap_user

Thanks. I forgot type in.

I tried that directly run this MDX query on the server, it works. Somehow can not run cross network, but I can run select MDX query in my box.

Someone have any idea

Thanks.





Re: create local cube issue

Irina Gorbach

Sorry, I don't understand what exactly doesn't work. Let's clarify:

1. Create Global Cube from your machine to the server on your machine : Works

2. Create Global Cube from you machine to the server on another machine: Doesn't






Re: create local cube issue

olap_user

Sorry, I didn't say clear.
1. Create Global Cube from the server on server machine: Works
2.
Create Global Cube from my machine to the server on my machine: Doesn't
3. I tried : 'SELECT
{[Measures].[Orders]} ON COLUMNS,
[Time].[Year].Members ON ROWS
FROM myCube'
from my machine to the server on my machine: Works.
means Analysis Service is running and connecting, but just not work for '
Create Global Cube'. I really do not understand why.

Any suggestions

Thanks.





Re: create local cube issue

Irina Gorbach

Could you make sure that cube file is not opened from any other application and that it's not write protected or something like this May be just delete this file and try to create it again. The other thing that comes to mind are permissions for directory, but you are obviosly an administrator on your machine and should have permissions to your own c:\ drive. Is it Vista by any chance




Re: create local cube issue

olap_user

This file not exists on the server, I want to create it, but no succeed.
I will double check permissions for the directory when server person come.

Thanks a lot Irina. I will post the result later.

By the way, Is there a way can schedule MDX query as a job

Thanks.




Re: create local cube issue

olap_user

I checked permissions for the directory, everyone has read and write permissions at this moment, but I still got same error 'A connection cannot be made. Ensure that the server is running.'

What else I should check any suggestions

Thanks.