Tagged Questions

0
votes
0answers
33 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?
3
votes
1answer
68 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 ...
3
votes
1answer
183 views

How do I display subtotals in cube browser in SSAS 2012 (Sql Server Data Tools)?

Apparently this feature was available in previous versions but has now been removed. What are some alternatives?
2
votes
0answers
84 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 ...
1
vote
1answer
313 views

SSAS Modelling - many to many with one dimension

I'm having bit of a hard time modelling an OLAP cube. My analogy is this: I have a list of students. Each one has one Major subject of study, and zero or more minors, up to five in total. The raw ...
3
votes
1answer
160 views

Connect tables in a cube based on historical data

So this may be the wrong place, and may seem pretty basic, but I'm new to building up cubes, so please forgive me. Imagine a setup described by the following: CREATE TABLE [dbo].[Orders] ( ...
6
votes
1answer
693 views

Medians, Modes, Percentiles and OLAP

I'm newbie trying to wrap my head around OLAP, and I have a few questions. Question 1: Can an OLAP cube store medians, modes, percentiles? Question 2: Can an user-written MDX query return a summary ...
3
votes
2answers
385 views

Combining retail sales and payment OLAP cubes

I'm using SQL Server 2005 Standard Edition Analysis Services (SSAS). I'm trying to build cubes from a retail OLTP database that can answer these kinds of questions: List down all products that were ...