Hi,
I am getting this following error while trying to create a local cube using CREATE GLOBAL CUBE stmt:
[ 1] Microsoft? OLE DB Provider for Analysis : Data source provider error.
[ 2] Microsoft? OLE DB Provider for Analysis : One or more errors occurred during processing of command.
[ 3] Microsoft? OLE DB Provider for Analysis : Column expression associated with level '_TemplateLevel' is not found
The MDX stmt used is:
CREATE GLOBAL CUBE
STORAGE 'D:\Codes\PPlay1.cub'
FROM
(
MEASURE
.[Org Salary],
MEASURE
.[Count],
DIMENSION
.[Store]
(
LEVEL [Store Country],
LEVEL [Store State],
LEVEL [Store City],
LEVEL [Store Name],
MEMBER [Store].[Store Country].&[USA]
),
DIMENSION
.[Time]
(
LEVEL [Year],
LEVEL [Quarter],
LEVEL [Month]
),
DIMENSION
.[Employees]
(
LEVEL [CEO],
LEVEL [Senior Management],
LEVEL [Level],
LEVEL [Level 01],
LEVEL [Level 02],
LEVEL [Level 03],
LEVEL [Level 04]
),
DIMENSION
.[Department]
(
LEVEL [Department Description]
),
DIMENSION
.[Position]
(
LEVEL [Management Role],
LEVEL [Position Title]
),
DIMENSION
.[Store Type]
(
LEVEL [Store Type]
),
DIMENSION
.[Pay Type]
(
LEVEL [Pay Type]
)
)
While trying to run this MDX stmt directly in MDX Query appln, i can see an error message saying "Unable to open cellset"
Any pointers to this would be highly appreciated.
Thanks in advance.
Santosh.
On further debugging found following error being thrown:
Errors in the metadata manager. The 'Level 4' source attribute ID of the 'Level 4' level does not correspond to an existing attribute in the dimension.
And when i remove all levels from the Employee dimension, it works:
CREATE GLOBAL CUBE
STORAGE 'D:\Codes\PPlay1.cub'
FROM
(
MEASURE
.[Org Salary],
MEASURE
.[Count],
DIMENSION
.[Store]
(
LEVEL [Store Country],
LEVEL [Store State],
LEVEL [Store City],
LEVEL [Store Name],
MEMBER [Store].[Store Country].&[USA]
),
DIMENSION
.[Time]
(
LEVEL [Year],
LEVEL [Quarter],
LEVEL [Month]
),
DIMENSION
.[Employees],
DIMENSION
.[Department]
(
LEVEL [Department Description]
),
DIMENSION
.[Position]
(
LEVEL [Management Role],
LEVEL [Position Title]
),
DIMENSION
.[Store Type]
(
LEVEL [Store Type]
),
DIMENSION
.[Pay Type]
(
LEVEL [Pay Type]
)
)
But not sure, why is this happening...Any known issues?
Thanks,
Santosh
No comments:
Post a Comment