The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
7 views

Connect to Cube without using Windows account

Is it possible to connect to OLAP Cube (SQL Server) without using Windows account. Currently, I need to be on the same domain in order to connect to a cube. Are there any other solutions?
1
vote
0answers
107 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 ...
0
votes
1answer
200 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
112 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 ...
4
votes
1answer
517 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 ...
6
votes
2answers
470 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 ...
1
vote
0answers
345 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
1answer
311 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
1k 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 ...