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

learn more… | top users | synonyms

1
vote
0answers
409 views

How to aggregate calculated measures involving dimension attributes?

The business case is as follows - I have a cube of sales transactions and a dimension of parts. One of the attributes of a part is the current cost, which is non-aggregatable. A user needs to model ...
1
vote
0answers
232 views

How to model Week Commencing / Week Ending scenario

I’m reasonably new to data warehousing and I’m struggling to get a feature of my time dimension working. I’d like to model a Week Commencing and Week Ending type of scenario. I’ve created a DimTime ...
1
vote
0answers
187 views

Configuring SQL Server 2008 R2 Change Data Capture with SSAS

I'm completely new to SQL Server Analysis Servers (SSAS) so you'll have to excuse my ignorance. I've been running through the MSDN SSAS tutorial get a handle on how to use SSAS. We have SQL Server ...
1
vote
0answers
349 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 ...
0
votes
1answer
178 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
959 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
182 views

Helpme undestand MDX exists function

After spend almost decade in OLTP world I got the courage to try to build my first CUBE. I installed VS2012 and created Business Intelligence -> Analysis Services. I did build Data Source Views, Cube ...
0
votes
1answer
50 views

Filtering by many-to-many table

I'm having a hard time to understand how to filter out result of multidimensional expression. This is my database schema. And this is my data. Manufacturer ╔════╦═══════════════════╗ ║ Id ║ ...
0
votes
1answer
595 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
258 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
56 views

SSAS Calculated Field - rolling sum, for a year of days

I have a fact table storing employee occurrences incurred day over day. I need to have a running sum over the past year of an employee's life. I had, on first pass, done this on ETL, making this ...
0
votes
1answer
27 views

Tools to visualize adhoc multi dimentional data

With SSMS I cannot run a MDX query such as Select [Measures].[Internet Average Sales Amount] on 0, [Product].[Category].children on 1, Product.[Model Name].children on 2 From [Adventure Works]; ...
0
votes
1answer
71 views

SSAS (Analysis Services) 2014 - Cumulative Update 1 for SP1

I just recently applied CU1 for SQL Server 2014 SP1 (http://support.microsoft.com/en-us/kb/3067839) to my development workstation and one PROD server. Analysis Services continues to report itself as ...
0
votes
1answer
221 views

How to optimize performance for dimension attributes?

I'm looking to enhance the cube processing time and someone suggested me to set "AttributeHierarchyEnabled='False'" for attributes which were not used at user defined hierarchies but I'm not clear ...
0
votes
2answers
1k views

Get distinct count on calculated member?

I'm using SSAS and created a measure group that is linked to Fact_SalesMetrics on SQL Server. In that, I have seven measures. All measures have aggregation of Sum except Sales Invoice which has ...
0
votes
1answer
3k 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
386 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
1answer
679 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
0answers
41 views

SSAS MD dimension joins to same table twice (but processing fails as attribute has 2 names for same ID)

My cube has a product dimension, and each product has an "availability" status attribute. In the database, SellableItemAvailabilityId in DimSellableItemVersion (which contains products) joins to Id in ...
0
votes
0answers
78 views

Backup storage file corruption: file not found. Possible cause of this error is corruption of backup file

I backup my SSAS cubes called "BI LIVE" and restore it to a specific location on a different server. I am using sql server 2014. This is where you can see the routine I use to run the backups: How ...
0
votes
1answer
93 views

Problems attaching a SSAS database

I am attaching a SSAS database that I have just moved to a different drive following the below link: Attach and Detach Analysis Services Databases First I had to grant permissions on the new drive ...
0
votes
0answers
37 views

SSAS bridge table with Slowly changing dimensions

I am designing a datamart using the basic principles of Kimball for use in SSAS. I have a many many to many attribute relationships (multi-valued dimension objects), however I have a few questions: ...
0
votes
0answers
113 views

Handle Duplicate entries in Fact table in Data Cube

We have been constructing data cube for our project in which we are facing a problem like 1 to many relationship in the dimension tables and making entries in fact table (duplication). ...
0
votes
1answer
161 views

Analysis Services job step error: The specified file could not be decrypted

We have a daily SQL Server Agent Job that's failing intermittently. Between May 27th and Jun 16th, it has failed twice. The error message we receive (listed below) references "The file could not ...
0
votes
1answer
127 views

Is there a way to install both tabular and multidimensional modes?

I have started studying for the MCSE BI exam. I would like to have both the multidimensional and tabular modes available for studying/practice purposes. I have a SQL Server 2014 Developer Edition with ...
0
votes
0answers
31 views

How to avoid processing for a dimension when we process the cube?

I have a dimension and a measure group whose data is only historical data and will never get changed. So, as I process the cube everyday it's getting processed along with it and it may be degrade the ...
0
votes
0answers
144 views

Cannot Deploy SSAS Package into VM / TCPIP

I'm sure that this is just a simple settings problem but I just don't get my head around it. I installed SQL Server 2014 incl SSAS in a VM on Server 2012 (using HyperV in win 8.1) and have VS Data ...
0
votes
1answer
40 views

Dimension design and MDX query issue

I'm new to MDX and SSAS but trying to learn. I'm on SQL Server 2012. I have the following table setup. My dimension relationships look like this: ...
0
votes
0answers
153 views

Scale-Out Query Server: SQL Server 2012/2014 Enterprise vs BI Edition

Was reviewing the Features Supported by the Editions of SQL Server (2012, 2014) and noticed what appears to be a mistake, but I'm just not certain and looking for confirmation. For 2012/2014, there ...
0
votes
0answers
47 views

Problem running SQL Server 2014 SSAS in an SSIS package

I have a SQL Server 2014 AlwaysOn environment setup with 3 nodes. It is a QA environment. I have a user who is trying to run an SSIS package against an SSAS cube. He can manually run the process in ...
0
votes
0answers
94 views

Join two tables and count a column using mdx

I am trying to join the two tables as below Table1 --------------------------- Product| StoreType| Store --------------------------- 1 | 10 | X ...
0
votes
0answers
53 views

Disk space requirements for SSAS database backup

Can anyone advise how I can gauge the disk space required to backup a SSAS database? I have a database that is as per SSMS estimate 146GB in size. The contents of the data folder amount to 143GB and ...
0
votes
0answers
77 views

SSAS, Last Non empty broken

I have a straight-forward account fact table containing dimensions for Date, AccountOwner In SQL my fact table has column bookings (that can be negative for outgoing money and positive for incoming ...
0
votes
0answers
138 views

Why is MDX Moving Average Calculation Inconsistent in Excel?

This question hurts my brain to talk about. Hopefully I can explain it properly. I have the following calculation defined in my cube: CREATE MEMBER CURRENTCUBE.[Measures].[52 Week Comp Net Sales ...
0
votes
0answers
71 views

Does Position Of Cube Dimension Matter While Adding it as Measure

I've created a cube on the Adventure Works Database. And when tried to process the Cube i get error Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: ...
0
votes
0answers
132 views

Array of string in MDX

I have a dimension attribute that has composite key, such as CalendarQuarter in this post. This means my attribute members will have members that can be written as: ...
0
votes
1answer
109 views

Can we have OLAP cubes with same OBJECT NAME and ID at different database?

I have olap database for both production and test. Fortunately I noticed that cube under both production and test olap database has the same object name and Id. But DataSource for production and test ...
0
votes
0answers
119 views

SSAS - Many to many Relationship with Slowly Changing Dimension Type 2

I'm trying to solve the following scenario: I have a "Zone" dimension, a "Tile" dimension and a "Position" facttable. Within the facttable the duration of a hit on a tile is saved. The Many to Many ...
0
votes
1answer
35 views

Decision Tree English Rules and Dependency Network in MS SSAS

I created a Decision Tree model in Microsoft Analysis Services (SSAS, Visual Studio 2010). There are two tabs in the Mining Model Viewer tab: (1) Decision Tree that shows a tree itself, and (2) ...
0
votes
0answers
81 views

Which is the best way for selecting dimension attributes while creating a dimension?

I'm a newbie to SSAS OLAP so please apologize me if it was a silly question but surely I need suggestions. I would like to make clear some concepts which was confusing for me. Let us consider five ...
0
votes
0answers
32 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
2answers
742 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
150 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
656 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 ...
-2
votes
1answer
171 views

how to delete multiple ssas database using xmla script

how to delete multiple SSAS database using XMLA script if possible please post me with syntax
-4
votes
1answer
37 views

SQL Server and msbi relation and difference [closed]

With SQL Server 2008R2, we have analysis services, reporting services, and data moving and manipulation services with SQL Server Management Studio. So why do we need SSIS, SSRS, and SSAS?