The tag has no wiki summary.

learn more… | top users | synonyms

14
votes
3answers
954 views

Dynamically Define a Range in a Dimension

I have an issue that i face every time i decide to build a cube, and i haven't found a way to over come it yet. the issue is how to allow the user to define Range of things automatically without ...
3
votes
1answer
181 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
70 views

What does a multidimensional cube's internal structure look like?

We all know what a relational data model looks like, and most know what a star schema looks like, but what about the structure of a multidimensional database (OLAP cube)? I am assuming it is some sort ...
2
votes
0answers
14 views

Real-Time SSAS cube status notification [duplicate]

Possible Duplicate: Real Time SQL Server Analysis Services Cube Processing Report I would like to know if there is a way to generate a report to determine which SQL Server Analysis Services ...
1
vote
0answers
39 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 ...
0
votes
2answers
756 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 ...