Have Suggestions for a Front End Tool?

I am currently using Microsoft Excel pivot tables to access data cubes from SQL Server 2002 as a front end tool for users to access sales data. I have run into issues when I am asking the pivot to filter too much. Does anyone have any suggestions on another frontend tool for cubes that does not run into limitations like Excel does? A 3rd party tool? I know Access could be used but I would like to purchase something not write a program?

Thank you,

Carla C. HertelCheck out the following link:

link (http://www.hungrydogsoftware.com/)|||Here is a bigger list:

list (http://www.dwinfocenter.org/olap.html)

But the hungry dog intellibrowser is pretty good.|||Have you checked out Microsoft's pivot table Office Web Component? If you haven't it might be worth a look.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odeopg/html/deovrworkingwithofficewebcomponents.asp

Good luck|||Panorama Novaview http://www.pansw.com/ OLAP front-end is made by the same company that licensed Microsoft the OLAP server technology for Analysis Services. It has write-back capabilities unlike Bus Obj, Cognos, Crystal et al and some nice features like bubble-up exceptions, wizards for query creation and good thin-client support.

SQLmag published a review of the leading OLAP front-ends for Microsoft Analysis Services:

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=26486

There are many tools on the market, but this is the short list.|||i can recommend BusinessObjects - although some dum people (like our MIS dept) use universes only, BusinessObjects can work with MS Analytical Servicers just fine. Business Objects is more reporting tool. They have also special add-in into Excel called BusinessQuery.

microsoft has data analyzer (it's 100% analytical tool) http://www.microsoft.com/office/dataanalyzer/default.asp

jiri|||Hi,

as a client tool we use Q4bisAnalysis.
A quit nice little tool which could be learned within minutes.

More infos:
www.q4bis.com

regards

Michael

Hardcode subtotal

Hello,

Can I hardcode matrix subtotal?

For instance, I want to hardcode "100%" in the following Sales report:

2007 Year

Quantity

Phones 21%

Notebooks 30%

Total 100%

Please don't ask me why I need to do that, it's a complex MDX query and the report is much more complex than I depicted.

I just need to statically write 100% in subtotal.

Write the following expression

Code Snippet

=100 & "%"

in the text box where u want to display 100%.

Best Regards,

Rajiv

|||

RajivDotNet wrote:

Write the following expression

Code Snippet

=100 & "%"

in the text box where u want to display 100%.

Best Regards,

Rajiv

I would just like to mention the InScope function. If you have a calculation in that column to determine the percentage, you can just add an IIf and InScope function to the expression to determine whether you are within the bounds of your row group, if you are within bounds then do your normal percentage calculation, if you are out of bounds then just return "100" (and use the code p0 in the Format property so that things are formatted correctly when exported to Excel).

|||

Dear Rajiv and Sluggy,

Thank you very much for your quick response.

Your approach worked!