Well good for you that you have access to both SSAS and Qlikview, Being a Data Warehouse Lead Developer i could great a great set of reporting and analytic applications...

Yes thanks for the help, I managed to resolve the matter, the error was with the connection string having to be properly setup in web.config.

Lynn and Jack,I deeply apologize if by any means i sounded rude, it was not my intention, i am very greatful for the replies and for the time you took...

Thanks a lot jack, for that invaluable post, i tweaked around a bit but that was exactly what i was trying to achieve.

Thank you for posting the idea without making...

HEY THANKS A LOT

I was helped out finally but i still have a potential problem of implementing it i am using cases but currently i am able to figure out...

Thank you bit bucket for that valuable post this is what i was thinking

Yes there is a table which takes in all the data like the table 1 in...

thank you for that but nowe i remember that the cursor is actually used to insert/update data in individual tables.

Like say as i was saying data is currently flagged 'N'...

I CANT THANK YOU enough for that valuable post,

BUT

kindly clear my doubt

i understand these parts

CREATE TABLE #Table1 --table into which data is first imported

(CUSTOMER_ID INT, ...