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
31 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
17 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
68 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
83 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
156 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
134 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
224 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 ...