Monday, February 20, 2012

MDX Offline Cube creation after SP2

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