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!

Merging two tables

SQL 7
How do I merge two table's records? In other words, merge
T1 into T2. There are records in both tables that are the
same, but where T1 has a record that T2 doesn't have,
T1's record needs to be inserted into T2.
I've been reading Join syntax til my head is spinning.
Thanks,
DonInsert into T2
select * from T1 where T1.PrimaryKey
where T1.PrimaryKey NOT IN (Select PrimaryKey from T2)
Replace PrimaryKey with the unique priamry key from each table.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Don" <anonymous@.discussions.microsoft.com> wrote in message
news:7ff101c402df$8f68d030$a101280a@.phx.gbl...
> SQL 7
> How do I merge two table's records? In other words, merge
> T1 into T2. There are records in both tables that are the
> same, but where T1 has a record that T2 doesn't have,
> T1's record needs to be inserted into T2.
> I've been reading Join syntax til my head is spinning.
> Thanks,
> Don
>|||Don,

> How do I merge two table's records? In other words, merge
> T1 into T2. There are records in both tables that are the
> same, but where T1 has a record that T2 doesn't have,
> T1's record needs to be inserted into T2.
insert T2
select * from T1
where not exists (select * from T2 where T1.keycol = T2.keycol)
Linda