SQL Server Analysis Services, an OLAP server bundled with SQL Server by Microsoft since version 7.0
3
votes
1answer
74 views
Should I snowflake or duplicate it across my facts?
I'm building up a data warehouse to be used by SSAS to create cubes on, and I'm debating between two possible schemas.
In my warehouse, I've got two different fact tables that tracking daily changes ...
7
votes
0answers
98 views
SQL Server Analysis Studio naive Bayes attribute has too many states
I'm using SQL Server Analysis Studio and I'm trying to train a naive Bayes classifier. I've got an attribute called "item description" that basically represents products you can buy at a store. I've ...
2
votes
0answers
30 views
How to remove leaf member values?
I have a dimension hierarchy that is related to multiple fact tables with different granularities. In the case of one fact table, it relates to the middle level of a three level hierarchy.
When you ...
2
votes
0answers
51 views
Date dimension changes between Test and Production Server
I have a cube deployed into a Test environment and Production environment. I've noticed something strange happen with the date dimension.
When deployed into our test environment, the Date Key comes ...
2
votes
0answers
86 views
Semi-additive measures for other dimensions
I am looking for a way to do semi-additive aggregations on a non-time dimension. The model I am working with is similar to a snapshot inventory warehouse. Specifically I am analyzing processes ...
2
votes
0answers
233 views
Finding Microsoft.AnalysisServices.Xmla dll in SQL Server 2008 R2
I'm not able to find Microsoft.AnalysisServices.XMLA.dll that I need to import
using Microsoft.AnalysisServices.Xmla;
I have found some articles and answered questions for SQL Server 2005 and 2012. ...
2
votes
0answers
105 views
MDX Block Calculation Optimisation
I have a query I'm trying to optimise. I have read an article here http://web.archive.org/web/20100823233821/http://www.biblogs.com/2008/03/30/optimizing-countfilter-expressions-in-mdx/ about ...
1
vote
0answers
102 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
44 views
Records are discarded if parent dimension refers to a child record that doesn't exist.
I stumbled upon the following issue in SQL Server Analysis Services (SSAS) When processing a Cube database.
I have a dimension that has sub dimensions, however if the parent record refers to a child ...
1
vote
0answers
123 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 ...
0
votes
0answers
37 views
When to use MOLAP or Tabular
What choice and factor do I need to consider if I gonna have my data mart database to use SSAS MOLAP or tabular?
Is there a guideline in what context to use MOLAP or tabular?
0
votes
0answers
25 views
The 'Data-based filtering for mining models' feature is not included
The 'Data-based filtering for mining models' feature is not included in SKU Standard 64 bit edition.
I have upgraded to Enteprise Edition but I still get the error.
Why is that ? Is there ...
0
votes
0answers
62 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 ...
0
votes
0answers
103 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
169 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 ...
