How to get the MDX query through Cube browser in BIDS?

Is there any means to get the MDX query generated internally when we browser the cube in Business Intilligence Development Studio (BIDS)?

Please let me know.

Thanks,

Austin.

SQL Server Profiler will let you capture query generated by BIDS.

Vidas Matelis

How to get scrollbar for a subreport

Hi,

Can anyone tell me how to get a scrollbar inside a subreport.I'm using SQL Server 2005 Business Int. Solution.I'm having more than 1000 rows for a subreport.I want to fix the width and hieght of the subreport so that i can get a scrollbar in the subreport.Please, help me regarding this.

Thanks,

Saradhi

This is easy to do with a report viewer using Visual Studio 2005. I'm not sure how to do this using SQL Server 2005 BIS.

|||

Hi,

Yes.It can be done in Visual Studio 2005 using reportviewer control.But i don't know with SQL Server 2005 BIS. Anyway, thanks for the reply.

Thanks,

Saradhi