ps. However, I am able to connect to SSMS databases from Excel (using From Other Sources->From SQL Server).

I solved one problem. I can now see the cube in SSMS under Analysis Server. You know what the problem was? I was not running SSMS...

Koen Verbeeck (3/23/2012)

---

Regarding the cube:

did you deploy the cube? If you right-click on the SSAS database, select properties and go to the Deployment tab, what's listed for database in the...

Koen, yes, exactly.

I decided to install a second instance of SSMS.....and now SQL Server Browser is running.....YET

the problem with Excel not connecting to Analysis Services is same. Also, SSMS's...

One additional observation is that the Date dimension table is found by the cube wizard in the list of available measures.

Since I designed Date as a dimension and...

Could the problems of (1) SQL Server Browser not being startable and (2) not being able to connect to analysis services from Excel, be related to the logon types I...

Koen Verbeeck (3/16/2012)

---

That's odd. If you installed everything local, Excel should find SSAS just fine.

Can you log into SSAS using Management Studio?

ps: to use TCP to connect to SSAS, you...

Thanks for taking my question Koen. I also read about this during initial research of problem, but ....

(1) I installed sql server on this machine myself (I am learning)...

What does it depend on? Is it just so many things that it is impossible to categorize and generalize at all? When are you satisfied with Excel and...

you are not able to tell me in general terms at which volume of data you would advise a client to use Excel PowerPivot to analyze data versus an Analysis...

my apologies, I realize now that my question as first posed, could easily have been interpreted as asking if Excel can be used as a relational database. I whole heartedly...

:alien:

Excel is used all the time to aggregate data that's been retrieved from a relational database with a query. Now with PowerPivot you don't even need to know how...

well, exactly, I googled to get the answer. Can you give a little more lead? For example, I didn't know to ask 'by rows'. So a little more...

is that 65K rows?

Quote from book Pro SQL Server 2008 Analysis Services

by Phili Janus and Guy Fouché

"What do we do when we have 500 products (or more—consider Amazon.com!) and tens...