Groups | Blog | Home
all groups > sql server data warehouse > march 2004 >

sql server data warehouse : microsoft reporting services


btbajirao NO[at]SPAM yahoo.com
3/18/2004 7:30:14 AM
Hi,
In Microsoft Abalysis Manager one can browse the cube data by right
clicking the cube and drag and drop columns to view data. Can the
same be achieved with reporting services.

Thanks in advance
Sean Boon [MS]
3/18/2004 11:01:28 AM
I'm not sure if I understand your question perfectly. There is a preview
function that you can use in the Report Designer that allows you to see what
a report would look like, plus you can preview the data set. If you're
asking whether or not you can query OLAP cubes from Reporting Services, the
answer is that you can, but you need to know MDX in order to do so.

We are working on a whitepaper that addresses this topic. It assumes you
already have good knowledge of MDX. Given the number
of inquiries, I've gone ahead and posted it over on the OLAP MSN group. You
can find it in the general discussion are of.

http://groups.msn.com/OLAPServicesDevelopersForum/

Sean


--
Sean

--
Sean Boon
SQL Server BI Product Unit

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

[quoted text, click to view]

baji rao
3/19/2004 4:19:09 AM


Thanks for the reply. I my be not clear in expressing what I want.

In microsoft analysis manager on right click, browse cube data > one
form pops up. There we can drag and drop dimensions from the top to work
area. So that the cube takes different shapes.

The same functionality I want to achieve in the web browser useng
Reporting services is that possible or not is my question.

Regards,
Bajirao

*** Sent via Developersdex http://www.developersdex.com ***
AddThis Social Bookmark Button