Client tools to view cubes

Hello!
I'm a new in DW world and I'm searching for tools to my clients view the
cubes generated using SQL 2005.
I already found some good products like "Business Objects" toolset but
the price is inacessible... :-(
The problem to use Excel to visualize the data, for example, is because
We host all the data of our clients using a ASP model (so the Excel can't
access the SQL Server directly).
Any idea?
Thanks!
RMeloWe use BIDS (Business Intelligece Studio) Basically Visual Studios. Create
a new Analysis Project, create Data Source to your Cube, then Add Report -
using Query Builder you can navigate your cubes and dimensions and create
reports to save and re-use.
Using SSMS (new Enterprise Manager) - you can do same but you lose all your
research when you exit. Creating it as a report you can save your work.
All above is FREE! M$ just bought out Proclarity - which is a proper full
blown Cube tool - but it will be a bit more than free.
"RMelo" <rmelo@.community.nospam> wrote in message
news:%23J1uZVjsGHA.3368@.TK2MSFTNGP02.phx.gbl...
> Hello!
> I'm a new in DW world and I'm searching for tools to my clients view
> the cubes generated using SQL 2005.
> I already found some good products like "Business Objects" toolset but
> the price is inacessible... :-(
> The problem to use Excel to visualize the data, for example, is because
> We host all the data of our clients using a ASP model (so the Excel can't
> access the SQL Server directly).
> Any idea?
> Thanks!
> RMelo
>|||Joe,
Good! But I think that BIDS is not a tool to a end user... Does
Microsoft have any web based app to manipulate the cubes?
Remember that to mey end users I don't have a direct connect to SQL
Server (I'm running my app on a datacenter, using the internet).
Thanks!
RMelo
Joe escreveu:
> We use BIDS (Business Intelligece Studio) Basically Visual Studios. Creat
e
> a new Analysis Project, create Data Source to your Cube, then Add Report -
> using Query Builder you can navigate your cubes and dimensions and create
> reports to save and re-use.
> Using SSMS (new Enterprise Manager) - you can do same but you lose all you
r
> research when you exit. Creating it as a report you can save your work.
> All above is FREE! M$ just bought out Proclarity - which is a proper full
> blown Cube tool - but it will be a bit more than free.
> "RMelo" <rmelo@.community.nospam> wrote in message
> news:%23J1uZVjsGHA.3368@.TK2MSFTNGP02.phx.gbl...
>|||Joe,
Good! But I think that BIDS is not a tool to a end user... Does
Microsoft have any web based app to manipulate the cubes?
Remember that to mey end users I don't have a direct connect to SQL
Server (I'm running my app on a datacenter, using the internet).
Thanks!
RMelo
Joe escreveu:
> We use BIDS (Business Intelligece Studio) Basically Visual Studios. Creat
e
> a new Analysis Project, create Data Source to your Cube, then Add Report -
> using Query Builder you can navigate your cubes and dimensions and create
> reports to save and re-use.
> Using SSMS (new Enterprise Manager) - you can do same but you lose all you
r
> research when you exit. Creating it as a report you can save your work.
> All above is FREE! M$ just bought out Proclarity - which is a proper full
> blown Cube tool - but it will be a bit more than free.
> "RMelo" <rmelo@.community.nospam> wrote in message
> news:%23J1uZVjsGHA.3368@.TK2MSFTNGP02.phx.gbl...
>|||Joe,
Good! But I think that BIDS is not a tool to a end user... Does Microsoft
have any web based app to manipulate the cubes?
Remember that to mey end users I don't have a direct connect to SQL
Server (I'm running my app on a datacenter, using the internet).
Thanks!
RMelo
"Joe" <hortoristic@.gmail dot com> wrote in message
news:%231bjcNmsGHA.3684@.TK2MSFTNGP05.phx.gbl...
> We use BIDS (Business Intelligece Studio) Basically Visual Studios.
> Create a new Analysis Project, create Data Source to your Cube, then Add
> Report - using Query Builder you can navigate your cubes and dimensions
> and create reports to save and re-use.
> Using SSMS (new Enterprise Manager) - you can do same but you lose all
> your research when you exit. Creating it as a report you can save your
> work.
> All above is FREE! M$ just bought out Proclarity - which is a proper full
> blown Cube tool - but it will be a bit more than free.
> "RMelo" <rmelo@.community.nospam> wrote in message
> news:%23J1uZVjsGHA.3368@.TK2MSFTNGP02.phx.gbl...
>|||Hello RMelo,
I understand that you'd like to use some Web based application to connct
and manipulate the cubes, and you does not have direct access to AS 2005.
If I'm off-base, please let me know.
You'd like to consider Pivottable in Office Web Component (OWC). You may
want to refer to following article for more details about OWC and pivottable
Using Web Technologies with Office XP
http://msdn.microsoft.com/library/d...-us/modcore/htm
l/deovrusingwebtechnologies.asp
Office Web Components section from the article,
http://msdn.microsoft.com/library/d...-us/dnoxpta/htm
l/vsofficedev.asp
Also, you may consider using HTTP Access to Analysis Services 2005 so that
clients does not need to access server directly from clients:
Configuring HTTP Access to SQL Server 2005 Analysis Services on Microsoft
Windows Server 2003
http://www.microsoft.com/technet/pr...5/httpasws.mspx
If you want to manage AS 2005, you may want to consider using AMO and
develop your own Web application.
Analysis Management Objects (AMO)
http://msdn2.microsoft.com/en-us/library/ms124924.aspx
If you have any further questions on this, please feel free to let's know.
Thanks.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
========================================
==========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications
<http://msdn.microsoft.com/subscript...ps/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscript...rt/default.aspx>.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.|||I know it's not as easy as it could be - but we have been training ppl who
have never even seen SQL 2005 on BIDS and within 4 to 6 hours they are able
to work on their own using BIDS.
As mentioned, the ProClarity product from M$ is what you want - but you have
to pay extra for that - BIDS is free.
"msnews.microsoft.com" <rmelo@.community.nospam> wrote in message
news:uLdIFtmsGHA.5044@.TK2MSFTNGP05.phx.gbl...[vbcol=seagreen]
> Joe,
> Good! But I think that BIDS is not a tool to a end user... Does
> Microsoft have any web based app to manipulate the cubes?
> Remember that to mey end users I don't have a direct connect to SQL
> Server (I'm running my app on a datacenter, using the internet).
> Thanks!
> RMelo
> Joe escreveu: