SQL Server Analysis Services, an OLAP server bundled with SQL Server by Microsoft since version 7.0

learn more… | top users | synonyms

0
votes
0answers
21 views

Setup for Availability Group with Analysis Services

We currently have one server with the Database Engine, SSAS, SSRS and SSIS all running on it. We are moving to a two server Availability Group setup. Currently I am not too worried about resources ...
0
votes
2answers
132 views

SSAS tabular browse excel relationships not working

I'm currently building an education data warehouse. I have three factless fact tables for distinct set of grades due to the fact i have no measures (i'm not aggregating anything), the grades are ...
0
votes
0answers
45 views

SQL Server Reporting Service dynamically change connection string

We have set up our Microsoft 2012 Analysis Server as per Microsoft's best practice guide found here: http://technet.microsoft.com/library/Cc966449 In particular, we're looking at how to swap from AS2 ...
0
votes
0answers
18 views

Code review for SSAS changes

We are developing cube using SSAS. However, in a distributed development team, we are facing it hard in communicating the changes done in the Cube or in sharing the development tasks for the cube. It ...
0
votes
0answers
79 views

Sorting a SSAS Parent Child Hierarchy

I have a dimension with a Parent Child hierarchy. This hierarchy is ordered according to an attribute of the dimension. Is there some way to create a calculated member that uses the Sort Order ...
0
votes
0answers
94 views

How do I relate two measure groups that share some dimensions?

I have one measure group uniquely keyed to an invoice line that indicates a part number and a quantity. SOLine Part SoldQty 123 abc 1 456 xyx 3 I have ...
0
votes
0answers
176 views

Error 7373 connecting to SSAS 2008 only from one machine

Within the last week, I've gotten the following error when trying to use a linked server in SSMS (tried 2008 and 2012) to connect to a SSAS 2008 R2 instance on our cluster: Cannot set ...
0
votes
0answers
136 views

How to design the table and its relationship?

I am having a problem designing a Dim and Fact Table for the following problem. I want to display my data in PivotGrid as below : First table shows that if i search a person, anyone related to ...
0
votes
0answers
227 views

Cube dimension relationships confusion

I'm trying to get my cube working without getting "attribute key not found" errors, but the only way I've found to make it work, is to set up a referenced dimension from Dim_PropertyInfo to ...