against our OLTP database (SQL Server).
Instead of reports running against OLTP database I would like to create
Cubes and create production reports against them.
Is it possible to do that? Are there any client applications which allows to
create these types of reports? We don't need real time information.
Any help is greatly appreciated.Is it possible to do that?
--Yes
Are there any client applications which allows to create these types of
reports?
--Yes, you create the cubes in Analysis Services and you can use Excel Pivot
tables to connect, then if you are looking for more functionality and better
graphing capability you have a whole host of options. Search on google for
OLAP viewers, there's a bunch. I use ProClarity (www.proclarity.com )
You will want to look into using DTS to copy your data to a store where you
can build your cubes off.
HTH
Ray Higdon MCSE, MCDBA, CCNA
--
"Atul Mehta" <amehta@.oaktreecap.com> wrote in message
news:u%23ov$HCvDHA.1744@.TK2MSFTNGP12.phx.gbl...
quote:
> We have a large number of (Crystal) Reports ( based on Stor Proc ) running
> against our OLTP database (SQL Server).
> Instead of reports running against OLTP database I would like to create
> Cubes and create production reports against them.
> Is it possible to do that? Are there any client applications which allows
to
quote:
> create these types of reports? We don't need real time information.
> Any help is greatly appreciated.
>
No comments:
Post a Comment