Can anyone recommend a web based product/client that exposes AS cubes
(similar to OWC pivot table), but also allows for drill-through to the
detailed transactions that underly the cube?

Thanks in advance!

Hi,

There are a lot of SSAS products, but I would suggest to go for
ReportPortal.

ReportPortal supports by default drill-through and also SSAS2005 KPIs !

For free download of trial: www.gmsbv.nl / www.reportportal.com

Regards, Marco

Tyler Allbritton schreef:

Hello,

The PivotTable view in Excel Services in Office 2007 shall include this
feature. OWC is being discontinued because Microsoft needed a more flexible
technology to help customers address the following challenges they faced
with OWC:

• A server-side Excel calculation engine
• Help provide for greater parity with Excel when worksheets are delivered
over the Web
• The ability to enable spreadsheets to be more scalable and stable when
loaded onto a server
• Improved security
• The ability to perform more detailed analysis to improve overall business
intelligence

The Enterprise Client Access License (CAL) version of Microsoft Office
SharePoint Server 2007 will include a technology called Excel Services that
includes:

• A server-side Excel calculation engine.
• The ability to enable browser-based worksheet viewing and interactivity.
• Web service access to the spreadsheet calculation engine in Excel.*
*Note that this means that Excel Services has been designed to scale and
perform on a server and it is not merely an Excel spreadsheet stored on a
server


Excel 2007 is the premiere client for AS 2005. In Excel 2007, MS has done a
ton of work in PivotTables and OLAP formulas to make sure that we support
most of the AS functionality in a much more usable fashion than in previous
versions of Excel.

http://msevents.microsoft.com/CUI/We...ntID=103229907
7&EventCategory=5&culture=en-US&CountryCode=US
http://www.microsoft.com/office/prev.../overview.mspx

And, there is a lot of information in the Excel blog, which has sections
(scroll down on the right side of the page) for PivotTables, Analysis
Services, and Excel Services: http://blogs.msdn.com/excel

If you may want get more details about this, you may want to post Office
2007 Beta posts to the Public Community specifically setup for the Beta -
http://www.microsoft.com/office/prev...community.mspx

Also, ProClarity is available: http://www.proclarity.com/


Key Value Propositions:

Central repository for pervasive analytics
Manages analytic meta-data – users cannot make changes to underlying data
structures
Shared Business Logic – business users empowered to create, share, and
manage metrics and sets
Delivers analytics to virtually any container
Thin-client web (zero-footprint)
Rich analytic applications
Microsoft BI Integration
Business Scorecard Manager
Reporting Services
SharePoint
Office (Excel, PowerPoint)

Hyperion has web analytic support but I'm not sure it is has feature you
want.

http://dev.hyperion.com/products/s9_web_analysis/

Hope this information is helpful.

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/subscripti...ult.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/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/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Another solution work a look is IntraSight. It is AJAX-based and supports
right-click drillthrough actions on members and cells.

http://www.activeinterface.com/intrasight.html


"Tyler Allbritton" <tallbritton (AT) newsgroups (DOT) nospam> wrote

Tyler,

SPF have just released a fantastic front end for SSAS 2005 called
CALUMO. Via the web or excel, it allows you to browse cubes, save views
and subsets, drill through to transactions has *very* tight integration
with excel - CALUMO fomulas recalculate back to the SSAS server when
you recalc excel... CALUMO has great writeback capabilities and uses
excel as an authoring tool for web reports. It "surfaces" all the cool
stuff that comes with SQL 2005 - KPI's, business intelligence on
dimensions, etc. The product is all written in .NET2

the site is www.calumo.com


Cheers,

Chris


On Oct 13, 2:24 pm, Tyler Allbritton <tallbrit... (AT) newsgroups (DOT) nospam>
wrote:

Tyler,

SPF have recently released a product called CALUMO for SSAS 2005. Via
excel or the web, you can browse cubes, write back to cubes, save views
and subsets, create reports with CALUMO formulas that calculate back to
the SSAS engine. It also have native SSAS drill through to the
underlying transactions and supports 2005 KPIs, dimension business
intelligence and all the other great things in the SSAS 2005 release.
It is built entirely on .NET2 and also has *very* tight excel
integration.

the web site is www.calumo.com

Cheers

Chris


On Oct 13, 2:24 pm, Tyler Allbritton <tallbrit... (AT) newsgroups (DOT) nospam>
wrote: