To login to the SSAS your user account needs to be known to AS Server. Create user account with your credentials in the server to login to the server from...

It was really helpful post, thanks actually we have decided to go with having additional columns that would have values on time taken for each step. By having time taken...

You are rite...Need to flatten the input... Otherwise also, If we get XML some tedious parsing needs to be done to extract the data and map it to the columns

We had found a way to deal with it. we found a product called ActivePDF that would convert PDF in to XML, thot would load the data from XML as...

Yes. Actually I wanted that additional column is SSRS.. but couldn't do it there.. so thot of doing it in the query itself

Thanks for your help Gurus.

Am looking for output like

Month Country Tran ...

Yeah. Need to have multiple tabs in one report. I read a round about solution in another forum. Have text boxes on the top with Tab like back ground image...