We have built a MOSS2007 extranet for one of our customers. We would like to allow our customer to browse SSAS2005 data to do real adhoc analysis. I was hoping that we could use the local excel 2007 installation to connect to the cube by using a data connection published on the data connection library. Unfortunately this does not work.
Simply publishing excel workbooks is not sufficient, because you cannot drag and drop dimensions and measures.
If anybody has a solution for this or tips for a workaround, please let me know...
Thanks in advance
Joos
adhoc cube browsing
Laurence Hunter
Stefan Gabriel Georgescu
ChrisVienna
I agree putting the cube in a dmz is not a good option. But I also believe that report builder misses functionality. Why is there no functionality in excel like in report builder. Report builder is a click once application, meaning that there is a client being installed. The data connection is established through reporting services, right. Why is it according to this logic not possible to use excel as a client and force it to establish a data connection through excel services
Joos
BigOldSofty
Report builder is an option, but it misses some functionality and flexibility. ProClarity certainly is an option, but how can I get this working on an extranet
I still prefer Excel as a front-end. Does anybody know what I have to do get this working outside our network
Thanks
Joos
bob yoplait
Might I suggest using reportbuilder It has drag and drop out of the box, and is "free".
Empowering End Users
SQL Server 2005 Reporting Services includes Report Builder, a new ad hoc reporting tool that enables business users to create their own reports and explore corporate data. Report Builder incorporates a user-friendly business query model that enables users to build reports even if users do not possess deep technical understanding of the underlying data sources.
Report Builder supports building reports on both SQL Server relational databases and SQL Server Analysis Services multidimensional databases. It is not designed to be a full-featured data analysis tool; rather it is a way for Information Technology staff members to enable self-service query and reporting scenarios.
http://www.microsoft.com/technet/prodtechnol/sql/2005/2005ssrs.mspx
Chibi-Acer
Just remove the firewall and place it all on the outside ;-) LOL
No, Really, would Reporting Services not give you the ablilty to expose it outside... Granted it would not be an excel interface but once they sliced and diced the data, they could use the Export Functionality in Reporting Services to export it to excel... or am I missing something fundamental
Ayman Osman