I have another question…As Ive told you I am new to BO…I am creating a report which displays plant metrics. It has columns Plant Name, Shipments -in this year, Shipments-in last year, etc… I have measure objects for shipments this year and shipments last year and we are using Msaccess database…
when I try to get both of them on to the report it doesnt fetch any records and the SQL statement reads like year=2003 AND year=2004…If anybody did encounter such problem and know the solution please help me…I want the solution to be at the designer level.
Might need a little more back ground but from what you’ve said…
“SQL statement reads like year=2003 AND year=2004” you’ll always get no data to fetch. Year can not in one SQL statement be set to 2003 and 2004 with an AND statement. Use “OR” instead.
If your objects are setup with criteria that declare the year number = to 2003 and 2004 you cannot use these object in the same query. Try creating a union query.
and 
(BOB member since 2002-08-15)
(BOB member since 2002-06-20)