Failed creating local Cube with openquery

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

Failed creating local Cube with openquery

Author

Topic

eXekutoR
Starting Member

1 Post

Posted - 2011-06-27 : 11:43:55

Hi,

i have problems building a local cube using a linked Server.
With openquery i can execute MDX-Statements but the create global cube statment failed with the following error.


OLE DB provider "MSOLAP" for linked server "TEST" returned message 
"File system error: An error occurred while opening the 'e:\test\test.cub' local cube file.".
Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing the query "
create global cube 
      [test]
storage 
      'e:\test\test.cub'
from
      [InvoiceClient]
(
      MEASURE [InvoiceClient].[Invoice Count],
      MEASURE [InvoiceClient].[Invoice Count - Product],

      DIMENSION [Date].[H Calendar],
      DIMENSION [Product].[HSupplierProduct],
      DIMENSION [Product].[H Commodities]
)
" for execution against OLE DB provider "MSOLAP" for linked server "TEST".

I executed this query with admin-users and the sa. In the folder "test" anyone may write. Also i don't think i configured the linked server wrong because i can execute the mdx statement.
The OPENQUERY is used to create the cube with SSIS and don't know an way to do this without openquery.

Do you have any idea to resolve this problem?

I'm new so ... Hello Everyone!

eXekutoR

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources