The Year Parameter is thru the query while the State parameter e.g. California, is Non-queried

here's a template if this might help...

SELECT [ALL | DISTINCT] columnname1 [,columnname2]FROM tablename1 [,tablename2][WHERE condition] [ and|or condition...][GROUP BY column-list][HAVING "conditions][ORDER BY "column-list" [ASC | DESC] ]

i havent been in touch with SQL a lot lately but i do know that there are keywords UNIQUE and DISTINCT which do precisely this thing...i dont have a reference...

ooops...i didnt know that there was a keyword by the name of Avg

=Avg(Fields!Measures_Un_Employment_Rate.Value)

did it for me..  just...

havent u faced any issues in actually viewing the report after its been deployed? i mean, i am facing the problem that it works fine when i clik preview but...

Thanx guyz!the problem has been solved...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=199194&post=true

take care...thanx once again...

Thank you SOOOO much....u are the man!!! saved me hours of useless work...now,i DO believe that such forums offer help! thanx once again!

yea,i did consider it but the problem is that the update would only replace the IDs for the original data while i need to copy it,changing only the TimeID and...

i have a fact table(basically,a sorta relationship table if u havent worked in multi dimensions yet) which tries to link the time dimension(table) having "Time ID" Key and a State...

thnax

yea,i am trying to do that thru the enterprise manager...any way around it? i dont want to waste ages entering sample data... there wud...

i guess,u'll simply have to change the query and interchange the ON COLUMN and ON ROWS clause... and design the matrix accordinglyi THINK it wud work!!do tell if it does...

ok guyz...the problem has been solved!! forgot to update the data in the fact table... it...

ok guyz...the problem has been solved!! forgot to update the data in the fact table... it was...