Time Dimension Error

[apcIT]

I am brand new to Analysis Server...

I have created a time dimension from a table in SQL 2000 but I can't get the dimension to be created when I use an Oracle table. Both tables have the same data and format. Any suggestions?

Here is the oracle ddl...

CREATE TABLE TIME_DIMENSION (
TIME_PK NUMBER NOT NULL,
THE_DATE DATE NOT NULL,
THE_YEAR VARCHAR2 (4),
THE_MONTH VARCHAR2 (3),
CONSTRAINT PK_TIME_DIMENSION
PRIMARY KEY ( TIME_PK ) ) ;

 

[johnherman]

I think this will work. The syntax is a little different.

CREATE TABLE TIME_DIMENSION (
TIME_PK NUMBER NOT NULL,
THE_DATE DATE NOT NULL,
THE_YEAR VARCHAR2 (4),
THE_MONTH VARCHAR2 (3))


CREATE UNIQUE INDEX PK_TIME_DIMENSION ON TIME_DIMENSION
(
TIME_PK ASC,
);


-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright

 

[apcIT]

I am not sure what that means. I already have the pk set up as an index.

Could there be an issue with the difference on how the date is stored between Oracle and SQL Server?

 

[MDXer]

What is the error msg you recieve?

Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[apcIT]

The error message reads as follows...

"Unable to browse the dimension 'New Dimension'. Error Processing the dimension 'Unspecified Error'.

 

[apcIT]

In the error log there is also an error that says...

"Data source provider error: Unspecified error; Time:7/27/2004 7:45:42 AM"

 

[johnherman]

Kind of obvious, but did you check the box which indicated that this was a time dimension?

-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright

 

[apcIT]

The Time dimension box is checked on the dimension type window...