dbTalk Databases Forums  

Excel Add-in for Analysis Service - What-if Analysis Problem

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


Discuss Excel Add-in for Analysis Service - What-if Analysis Problem in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jay Nathan
 
Posts: n/a

Default Excel Add-in for Analysis Service - What-if Analysis Problem - 07-01-2004 , 10:40 AM






Okay, here's another one... In addition to Actions, I also cannot get
What-if analysis to work. Whenever I choose the What-if Analysis --> Begin
menu option, I get the following error:

Unable to begin What-if Analysis. Check connections and try refreshing your
report before trying again.

Okay... did exactly what it told me to. I also made sure the cube I'm
working with was Write-enabled.

Any suggestions from anyone?



Reply With Quote
  #2  
Old   
Nigel Pendse
 
Posts: n/a

Default Re: Excel Add-in for Analysis Service - What-if Analysis Problem - 07-01-2004 , 11:39 AM






This seems to be the all-purpose error message generated by the add-in,
which hardly ever indicates the real problem. But my guess is that you
weren't at leaf level in *every* dimension.

"Jay Nathan" <jay (AT) jaynathan (DOT) com> wrote

Quote:
Okay, here's another one... In addition to Actions, I also cannot get
What-if analysis to work. Whenever I choose the What-if Analysis --
Begin menu option, I get the following error:

Unable to begin What-if Analysis. Check connections and try
refreshing your report before trying again.

Okay... did exactly what it told me to. I also made sure the cube I'm
working with was Write-enabled.

Any suggestions from anyone?



Reply With Quote
  #3  
Old   
Jay Nathan
 
Posts: n/a

Default Re: Excel Add-in for Analysis Service - What-if Analysis Problem - 07-01-2004 , 01:53 PM



Just tried again to make sure and got the same error message. I expanded to
the leaf level of every diminsion.

~Jay

"Nigel Pendse" <nigelp.nospam (AT) olapreport (DOT) com> wrote

Quote:
This seems to be the all-purpose error message generated by the add-in,
which hardly ever indicates the real problem. But my guess is that you
weren't at leaf level in *every* dimension.

"Jay Nathan" <jay (AT) jaynathan (DOT) com> wrote in message
news:uqiKPJ4XEHA.996 (AT) TK2MSFTNGP12 (DOT) phx.gbl
Okay, here's another one... In addition to Actions, I also cannot get
What-if analysis to work. Whenever I choose the What-if Analysis --
Begin menu option, I get the following error:

Unable to begin What-if Analysis. Check connections and try
refreshing your report before trying again.

Okay... did exactly what it told me to. I also made sure the cube I'm
working with was Write-enabled.

Any suggestions from anyone?





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.