microsoft reporting services

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
BajiraoI'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.
"Bajirao.B.T" <btbajirao@.yahoo.com> wrote in message
news:736f0ba3.0403180730.4e63cfd5@.posting.google.com...
> 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
> Bajirao|||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.examnotes.net ***
Don't just participate in USENET...get rewarded for it!

Microsoft Data Analyzer

I have downloaded Microsoft Data Analyzer and it is
asking for a CUBE on online OLAP server. Is there anyway
to connect it to Data in a plain 2000 SQL server.
if I do need OLAP what do I need to install on my SQL
server
Thanks
Steven Hill wrote:
> I have downloaded Microsoft Data Analyzer and it is
> asking for a CUBE on online OLAP server. Is there anyway
> to connect it to Data in a plain 2000 SQL server.
> if I do need OLAP what do I need to install on my SQL
> server
You need to have OLAP services installed on your SQL Server. From MDA FAQ -
OLAP refers to an online analytical processing database capable of handling
queries more complex than those handled by standard relational databases. It
does this through multidimensional access to data, intensive calculation
capability, and specialized indexing techniques. To learn more about this
technology, visit the OLAP and Data Mining page
(http://msdn.microsoft.com/library/de...-us/createdw/c
reatedw_1vqf.asp) on the MSDN site.
sincerely,
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.
sql

metadata services for analysis services

Hi,

I was wondering if anyone can tell me what options do I have to browse metadata for a cube built on Analysis services 2005. We would not like to buy a new thrid aprty tool for this. Does sql server 2005/ analysis services 2005 have a inbuilt option to view the metadata?

Thanks in advance.

Try running an AMOBrowser sample applicaiton. You should be able to see all Analysis Services metadata.

Another point here is: In version 2005 Analysis Services metadata is in XML format and it is easily obtainable. Go to the SQL Management studio, right click on any object and you can create a script containing metadata definition of the object. You can parce the XML yourself and manipulate it the way you want.

Hope that helps.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

thank you so much for the information. But i dont see any place at microsoft where I download the amoBrowser. Can you point me where I can find the amoBrowser and its installation files?

thanks again.

|||

AMOBrowser is part of the Samples you install with the product. You dont need to download it separately.

After installing the Samples you should be able to find it on your machine in C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\Programmability\AMO\AmoBrowser.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||i just saw that in one of the postings. Unfortulately i dont have those files. I installed the samples but I have the developer edition, maybe I shold have the enterprise edition for this? Do you think its right?|||

nevermind, i found it here,

http://msdn2.microsoft.com/en-us/library/ms160930.aspx

thanks again.