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

learn more… | top users | synonyms

0
votes
1answer
174 views

BI development in Microsoft BI

I need to learn how to create a dimensional modelling for an organisation that do not has a BI tool and BI model. Where can I learn more about BI development that should be used in a company? IT's ...
0
votes
2answers
702 views

SSAS: Move tempdb database

For sQL server 2008 R2 Analysis services, how can I move tempdb database files from one drive to another. At the time of installation, I didnt the seperate drive for tempdb. Now that I do have one, I ...
0
votes
1answer
246 views

Using SSAS for retrieval data instead of using SSRS to make a report?

If you work with Reporting service in order to create a report and you need to retrieve data from the relational database. The datamodel of the relational database can be structured in a certain way ...
0
votes
1answer
81 views

Linked Server from SQL Server to SSAS not working - what is missing?

I have a SQL Server 2012 Standard edition sp1 that has ssas also installed. From this server I create a linked server to a ssas server called BIREPLON1, but when I try to access it, I get the error ...
0
votes
1answer
48 views

Cube Processing vs Database Processing

We have a SSAS database (SQL Server 2012 Enterprise) with 4 cubes in it. 1 of the cubes is significantly bigger than the other 3. We want to process the 3 smaller cubes at regular intervals during the ...
0
votes
1answer
319 views

Data Warehouse - Slowly Changing Dimensions with Many to Many Relationships

As an example, let's say I have a fact table with two dimensions and one measure FactMoney table ProjectKey int PersonKey int CashAmount money The two dimensions are defined like this: ...
0
votes
1answer
407 views

Kerberos Authentication Issue

I'm getting these errors when testing a linked server from SQL Server 2012 to SSAS 2012 (both servers are Windows 2012 and clustered) "An error was encountered in the transport layer" and "The peer ...
0
votes
2answers
3k views

How do I design a Dimension and Fact Table from a relational database?

I'm new to using SQL Server 2008 R2 SSAS. I have the following tables in my database, that I wish to model using SQL Server Analysis Services: Table1 ServiceTypeID | ServiceTypeName ...
0
votes
0answers
14 views

Efficient settings for linked server to SSAS database

We are using OPENQUERY scripts to run MDX from sql-server. We're experiencing efficiency issues when we first run these queries each morning. The linked server objects which link to our SSAS ...
0
votes
0answers
8 views

create siblings ssas

If you have a parent-child dimension how can the power users easily create new level in the hierarchy? In SSAS is the posiblity to enable WriteBack and easy create new child and new sibling. Can you ...
0
votes
0answers
9 views

Deployed packages getting into the wrong folder

Package in my SSIS when I deploy them are getting save in the File System folder rather than the MSDB folder. Why? How do I change the location of these packages to MSDB?
0
votes
1answer
41 views

How to verify a SSAS Backup and how to perform Integrity Checks in SSAS?

I have a procedure to backup SSAS Databases that is working successfully. I also delete the SSAS backup files that are older than 2 days. What I am looking forward to implement is: 1) How to verify ...
0
votes
0answers
41 views

Huge Analysis Services log file: msmdsrv.log

I've just discovered our prod analysis services is writing to a log that is 1.6 GB in size. I was able to get a copy of the log file saved off to an alternate location and open it in WordPad ...
0
votes
0answers
70 views

Problem in Incorporating filters into Data Warehouse design

While implementing a data warehouse (proof of concept) I have a requirement to incorporate a user level save-able filter on dimensions. The requirement is a proof of concept so I have the liberty to ...
0
votes
1answer
48 views

SSAS / MDX Query - Need row total

I would like to add an additional row that will display the Total order count for all the different Customers in the Customer Dimension. Below is the query that I have been trying to modify. SELECT ...
0
votes
0answers
26 views

KPI behavior (Calculate member)

I have create the following tendency (IIF([Measures].[Age]=TRUE,1,0)+ IIF([Measures].[Idle]=TRUE,1,0)+ IIF([Measures].[Labor]=TRUE,1,0))/3 My issue is that in excel if I use this (or the kpi) the ...
0
votes
0answers
42 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
300 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
76 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
26 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
140 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
2answers
527 views

How to build dimensions from SCD tables

Having the foresight to begin collecting data from our production environment several years ago, I have a table with a following structure- Part Status Startdate Enddate I can write a relational ...
0
votes
0answers
248 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 ...