Hello,

I'd like to develop an application with the following functionality:
- allow users to connect to OLAP cube and run custom MDX queries
against it
- allow drilling on front-end

For example:
original query returns results of annual sales figures for
some products. Data is represented in the table on web page.

1997 1998
--------------------
Milk 700 750
Bread 690 680
Rice 900 950

The column headers are hyperlinks. Clicking on particular year
will return data for each quarter of that year.

Q1 Q2 Q3 Q4
----------------------------------
Milk 150 150 200 200
Bread 150 150 200 190
Rice 200 200 200 300


Can this be archived? How?
Especially how to construct drilling MDX queries on the fly?

Any suggestions and/or references to resources are welcomed.

Thanks for your help!

Dmitri

Hi Dimitri,

You may also want to look at an application called ProClarity. It is a
very nifty GUI that writes MDX on the fly and delivers intuitive
'reporting' based on cubes. www.proclarity.com

CIAO ;-D


"Joerg Narr" <n_o_spa_mjoerg_narr (AT) hotmail (DOT) com> wrote