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

learn more… | top users | synonyms

3
votes
2answers
485 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 ...
1
vote
1answer
498 views

Boolean field in OLAP cube

What is the best practice for presenting boolean data in an OLAP cube? Should I create a boolean dimension containing two rows, true and false?
4
votes
3answers
1k views

Connecting to MySQL database from Analysis Services

I need to know whether it is possible or not to get data from a MySQL database and create a Cube in Analysis Services 2008. If so, tell me how to connect to MySQL Database from Analysis Services.
1
vote
1answer
507 views

SQL server 2008 Analysis Services DSO properties

We are planning to do Sharepoint and project server 2007 databases migration. The share point website also processes cubes. So we will be moving SSAS cubes from SQL 2005 to 2008 and then re-pointing ...
4
votes
3answers
7k views

SSAS Dimensions Hierarchy causes deployment errors

I've set up a Data Source Connection to the Adventure Works DW database using the services credentials. I'm creating a dimension using the DimDate table. To simplify things I'm using only the ...
4
votes
2answers
1k views

How do I stop refresh conflicts between Proactive Caching of facts and timed refresh of Dimensions in a SQL Server Analysis Service 2005 OLAP cube?

I have a SSAS 2005 OLAP cube which we've very nearly made into a ROLAP cube using a mixture of proactive caching for the fact partitions and timed refreshes for the dimension data. There are two fact ...
2
votes
1answer
335 views

SSAS - Inferred Dimension Attributes - are they necessary?

I have a cube with fact tables that have a parent-child relationship: Person - Case. Some dimensions are inferred from the parent, e.g. State in the example below. Person does not have a foreign key ...