Analysis Service --> user Interaction

#1

User are connecting to the analysis service through excel.

Now user want to input parameter so that the analysis service should
calculate the value by using the user input values

For eg, there is a demand and supply column. User want to have the
result like
Supply
--------- X user enter value.
Demand

Whether the user can interact with the analysis service ?

if yes then how ?
by MDx query or ???

Please help

Regards
Suraj

#2

If you have not used Pivot Table in Excel, you may want to check it out.

"surajbirla (AT) gmail (DOT) com" wrote:

Quote:

User are connecting to the analysis service through excel.

Now user want to input parameter so that the analysis service should
calculate the value by using the user input values

For eg, there is a demand and supply column. User want to have the
result like
Supply
--------- X user enter value.
Demand

Whether the user can interact with the analysis service ?

if yes then how ?
by MDx query or ???

Please help

Regards
Suraj

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Analysis Service --> user Interaction

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Analysis Service --> user Interaction - 10-19-2006 , 04:14 PM

RE: Analysis Service --> user Interaction - 10-22-2006 , 11:30 PM