Hello-
We are using MDX queries to create offline cubes. After installing SP2 for SQL 2005 the cube files generate but through an error when opened. The error I receive is :
'Unable to obtain list of tables from the data source'
Has anyone else run into this issue?
Thanks-
Tristan
Just some additional information :
Here is an example of the MDX we are using to generate the offline cubes
CREATE GLOBAL CUBE [EE EVENTS CUBE]
STORAGE 'c:\Event.cub' FROM [EE EVENTS CUBE]
(
MEASURE [EE EVENTS CUBE].[Event Count],
DIMENSION [EE EVENTS CUBE].[EE Event Template Type Dim].[Event Type]
(
LEVEL [(All)],
LEVEL [Event Category Text],
LEVEL [Event Template Type Text]
),
DIMENSION [EE EVENTS CUBE].[EE Location Dim].[Location]
(
Level [(All)],
Level [Corporate Abbrev] AS Coporation,
Level [Region Abbrev] AS Region,
Level [District Abbrev] AS District,
Level [Facility Abbrev] AS Facility,
Level [Unit Name] AS Unit,
Member [EE Location Dim].[Location].[Corporate Abbrev].&[Corp1]
) ,
DIMENSION [EE EVENTS CUBE].[EE DATE DIM TWO YEAR VIEW].[Dates]
(
LEVEL [(All)],
LEVEL [Year_number] AS Year,
LEVEL [Month Of Year Display] AS Month,
LEVEL [Day Of Month Number Padded] AS Day
)
)
Any help would be appreciated.
No comments:
Post a Comment