creating a cube of a SLQ view

#1

I have created an AM cube to work on a SQL 2000 view of two joined tables
with one test record and one simple time dimension. The field types of the
dimension join are both datetime.

When I process the cube I receive the following error, although I seem able
to create other test cubes of views which process ok.

Data source provider error: The column prefix 'dbo.DateTable' does not match
with a table name or alias name used in the query.;42000; Time:15/12/2004
16:39:21

Cheers

Brett.

#2

Found it, oddly enough naming the view as 'armstr and shipped' caused AM the
problem. Renaming to armstr shipped has solved it!

"Brett Martin" wrote:

Quote:

I have created an AM cube to work on a SQL 2000 view of two joined tables
with one test record and one simple time dimension. The field types of the
dimension join are both datetime.

When I process the cube I receive the following error, although I seem able
to create other test cubes of views which process ok.

Data source provider error: The column prefix 'dbo.DateTable' does not match
with a table name or alias name used in the query.;42000; Time:15/12/2004
16:39:21

Cheers

Brett.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

creating a cube of a SLQ view

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

creating a cube of a SLQ view - 12-15-2004 , 10:49 AM

RE: creating a cube of a SLQ view - 12-15-2004 , 11:11 AM