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 |