Sourse table filter

#1

I've tried to get the source table filter to work in the cube but so far
I've been unsuccessful.
This is what I'm using ("env"."table"."date field" < '2004.05.01') is there
something I'm missing as far as syntax goes?

#2

Prefix your filter with the owner such as:
(("dbo"."env"."table"."date field" < '2004.05.01')

This should work.

Abhinav Kumar
akumar (AT) itmag (DOT) com.au

Quote:

-----Original Message-----
I've tried to get the source table filter to work in the
cube but so far
I've been unsuccessful.
This is what I'm using ("env"."table"."date field"
'2004.05.01') is there
something I'm missing as far as syntax goes?

.

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

Sourse table filter

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

Sourse table filter - 05-25-2004 , 02:00 AM

Sourse table filter - 05-25-2004 , 07:54 PM