The tag has no wiki summary.

learn more… | top users | synonyms

2
votes
2answers
110 views

Distributed MS SSAS database?

Is it possible to distribute a single SSAS database over multiple physical servers in order to improve performance? I've been looking at the Microsoft PDW architecture and am not clear if this is ...
0
votes
2answers
536 views

Is it possible to determine the top users of SqlServer analysis services?

We're trying to figure out how many licenses we need of a desktop data analysis package which connects directly to our SSAS instance. I'd like know if it's possible to query the history of connection ...
2
votes
1answer
3k views

The OLE DB provider “SQLNCLI10.1” has not been registered.; 42000

I have a SQL Server 2008 Analysis Services Project. In the Data Source View I have a Named Query which references a single Data Source containing three tables. The Project processes successfully and ...
0
votes
1answer
138 views

Expose SQL Server Analysis Services to users

is there a convenient way to expose SSAS to users in following scenario? User's are located in Local Area Network, thru it users can access in frontend part of separated network and thru it they can ...
0
votes
1answer
251 views

Is it possible to hide a Perspective with XMLA in Analysis Services 2008?

I have a SSAS cube that has 2 perspectives. The second perspective is only used in a secured environment. I would like this perspective to be hidden when new users connect to the general populations ...
0
votes
1answer
389 views

Connection error when trying to browse SSAS cube in BIDS

SQL Server 2008 db instance is installed on a win 2003 server, networked (but no domain) VM. I can browse a cube from BIDS on the same VM, but when I try to browse the same cube on a windows 7 (home ...
1
vote
0answers
474 views

What side effects are there of uninstalling SQL Server Analysis Services with TFS?

I have a TFS install which I think was never really successfully installed. I'm using it just for single-developer source control so I don't care about any analysis type functionality. When trying to ...
0
votes
0answers
14 views

Is it possible to store a credential for Windows Authentication to an Analysis Services server?

SQL Server Analysis Services uses Windows authentication for server connections. Typically, you assign your domain account to a role (or the server administrator list), and then connect to the server ...