More Info Please (was Re: Microsoft Analysis Server

gary kuipers, I recommend that you provide more information, specifically info about OLAP and its relation to MS Analysis Server. I know that I can't give you an answer, but I might be able to help you refine your question.

I googled for OLAP and found a definition, an OLAP Council (which has an informative white paper), a news/product site, and an information site. Is any of this information relevant? Can you point us to sources you are using?

Are you allowed to purchase additional software to make this happen? What kind of database are you using, or is MS Analysis Server the DB? Is this MSDN article about optimizing cube performance related to what you're doing? Is it MS Analysis Server or MS Analysis Services? MS has Analysis Services on their website, but I haven't been able to find Analysis Server.

From what I've seen with a few minutes of searching, the subject you are asking about is quite deep, and some clarifying information would help those answering you to know what you really want to do.

Comment on More Info Please (was Re: Microsoft Analysis Server - Data Cubes)

Replies are listed 'Best First'.
Re: More Info Please (was Re: Microsoft Analysis Server - Data Cubes) by gary kuipers (Beadle) on Nov 30, 2002 at 23:33 UTC
The data cubes are being created with Analysis Manager (MS Analysis Server). The service associated with the Analysis server is MSSQLServerOLAPService.	[reply]
Re: Re: More Info Please (was Re: Microsoft Analysis Server - Data Cubes) by Solo (Deacon) on Dec 01, 2002 at 07:10 UTC
You could try this using Excel to chart a pivot table as an inline image (in "real time"). Three bits to assemble: get the pivot table set up in Excel, chart it, then put the chart on the web. Here's a MS KB article that demonstrates returning a chart image. (Apologies for the link to MS... google on "google://excel chart asp vbscript web" if stale.) Similar searches should find the necessary info. This is quite a bit of overhead and probably not a practical solution for a high-traffic page, but OLAP is low-traffic by definition, right? Using the pivot table and chart in Excel should greatly simplify slicing up the cube and graphing code (show me sales >$1000 from regions 1 & 2 in Q2 for the last 3 years by week as a percentage of total sales for the week.) -- May the Source be with you. You said you wanted to be around when I made a mistake; well, this could be it, sweetheart.	[reply]