I need to do Association Analysis on a company KPI to determine its key influencers - among other things.
This is my first attempt ever and I have installed the Microsoft SQL Server 2005 Add-Ins for Office 2007. I also have SQL Server 2005 installed on my laptop.
I chose the "Use an existing instance of Microsoft SQL Server 2005 Analysis Services that I administer" and launched the Server Configuration Utility. I am advised that I will need server administrator provileges on the Analysis Services instance that I
am about to configure.
The defaulted server name is localhost.
Indeed I get an error message when I try to advance: "Unable to discover metadata on the server 'localhost'. User 'Maigida-PC\Maigida' needs to be administrator of the server to run the configuration tool"
Help me please: How Do I Set Server Administration Privileges on Analysis Services Instance to myself on a local server on my laptop?
I need to master DM in Excel 2007.
View Complete Post