The tag has no wiki summary.

learn more… | top users | synonyms

6
votes
2answers
421 views

Windows File Cache drops suddently

I have a 64-bit Windows 2003 server with 48 CPU cores and 128GB of RAM running a single application (SQL 2008 Analysis Services). SSAS is currently using about 50GB of memory. SSAS relies to a ...
4
votes
1answer
447 views

Distributed and/or Parallel SSIS processing

Background: Our company hosts SaaS DSS applications, where clients provide us data Daily and/or Weekly, which we process & merge into their existing database. During business hours, load in the ...
1
vote
0answers
85 views

SSAS Cube load job get stuck, 32 GB RAM is fully used

System: Microsoft BI System with MSSql Server 2008 10.50.1600.1 with SSAS, SSIS and SSRS on virtual VM Server Windows Server 2008 Standard x64 with 32 GB RAM Hello, our BI System gets sometimes ...
1
vote
0answers
312 views

Refreshing Excel Web Part connected to SSAS, and requirements?

Scenario: Excel file, with a SSAS data source connection Pivot Table/Charts with filters and slicers Published to Sharepoint 2010, such that users can access the report as a Excel Web Access Web ...
0
votes
0answers
27 views

getting connectivity error while deploying SSAS solution

Getting the error while deploying the solutions: The project could not be deployed to the 'localhost' server because of the following connectivity problems : A connection cannot be made. Ensure that ...
0
votes
1answer
154 views

Create Report in Microsoft Excel - Permissions Issue in Team Foundation Server 2010

I am trying to use the feature "Create a Report in Microsoft Excel" for Visual Studio TFS 2010. I am being prompted for a username and password in Excel for any given Team Project when right clicking ...
0
votes
1answer
98 views

All users can read SSAS all Cubes

I found that all my domainusers can read the cubes in my Microsoft Analasys Services. I have no roles specifying that. Neither the domain admins nor the local admins contain any group that would ...
0
votes
1answer
252 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
997 views

SSAS Roles - Creating a Role to restrict access to the cube, by country

I'm trying to create a role, to restrict access to a cube on Analysis services, so that a member of this role can only see records related to a specific country (from a dim_country dimension). So, for ...