The ssas tag has no wiki summary.
0
votes
0answers
39 views
SQL Server 2008 R2 Analysis services not starting
Folks,
I installed SQL server 2008 R2 on windows server 2008. During installation there was an error "MSSQLSERVEROLAPService could not start" but the installation continued and I was able to complete ...
0
votes
0answers
42 views
ssas mdx and t-sql gives different values
My situation:
There is a work database. Every day it is copied to another database named RetailDB. Fact and dimension tables of SSAS are based on VIEW-objects of tables in RetailDB.
So, I have this ...
0
votes
0answers
33 views
remote connection to SSAS server issue
I have a computer with newly installed SQL Server 2008 (default instance).Let's say the machine name is ABC.I can connect to it's SSAS from the computer itself.But I cannot connect to ABC's SSAS from ...
0
votes
1answer
89 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
79 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 ...
3
votes
1answer
237 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
326 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
235 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
161 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
782 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 ...
