Viewing 15 posts - 46 through 60 (of 105 total)
ps. However, I am able to connect to SSMS databases from Excel (using From Other Sources->From SQL Server).
March 23, 2012 at 2:28 am
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...
March 23, 2012 at 2:17 am
Koen Verbeeck (3/23/2012)
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...
March 23, 2012 at 1:36 am
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...
March 22, 2012 at 11:15 pm
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...
March 21, 2012 at 11:45 am
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...
March 16, 2012 at 2:57 pm
Koen Verbeeck (3/16/2012)
Can you log into SSAS using Management Studio?
ps: to use TCP to connect to SSAS, you...
March 16, 2012 at 8:22 am
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)...
March 16, 2012 at 7:50 am
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...
March 11, 2012 at 1:13 pm
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...
March 11, 2012 at 12:32 pm
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...
March 11, 2012 at 11:52 am
: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...
March 11, 2012 at 11:39 am
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...
March 11, 2012 at 3:31 am
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...
March 11, 2012 at 1:58 am
Viewing 15 posts - 46 through 60 (of 105 total)