dbTalk Databases Forums  

Create local cub with parent-child dimension

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Create local cub with parent-child dimension in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Xie Zheng
 
Posts: n/a

Default Create local cub with parent-child dimension - 08-28-2006 , 05:02 PM






A cube of AS 2005 runs well, but when I use the below mdx to create a local
file of this cube with parent-child dimension, it always reports "Internal
error: An unexpected exception occured."

CREATE GLOBAL CUBE [GLDemo] STORAGE 'c:\abc.cub' from [GLDemo]
(measure [GLDemo].[Amount],dimension [GLDemo].[Account])// Account is
parent-child

Anybody can help me?

For testing, I tried to use the Adventure WorksDW to create local cube, the
below mdx is sucesssful which can be directly run in Management Studio MDX
Query.

CREATE GLOBAL CUBE [Adventure Works] STORAGE
'c:\f.cub' from [Adventure Works]
(measure [Adventure Works].[Amount],dimension [Adventure Works].[account])
// acccout is parent-child

but the Amount of outputing f.cub is "#Err",it seems not still to get the
real right value.

Thanks for any guide.

Regards,

Xie Zheng

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.