Tagged Questions
2
votes
1answer
410 views
Difference between SSAS 2005 and SSAS 2008
I'm asking this question since i'm planning to book a seminar, but the provider told me that they only offer trainings for SSAS 2008 or as individual training which are expensive.
So my question: ...
2
votes
1answer
267 views
Displaying parent attributes alongside child attributes
SSAS - Parent Child hierarchy - displaying other Parent attributes alongside Child Attributes
For example:
Employee Table
+-----+-------+------+---------------+
| KEY | NAME | ROLE | MANAGERKEY ...
1
vote
2answers
147 views
SQL Server 2005 datacube processing in high transaction system
We currently have a highly transactional SQL 2005 database which is growning by around 1.2 million rows weekly. On top of this we have a SSAS datacube which is set to process every two hours for ...
1
vote
1answer
97 views
Migrating or Synchronizing SSAS Changes
Assume you have 2 SSAS databases, DB1 and DB2, that are identical.
Now they branch off. Changes A and B are made to DB1 and changes C and D are made to DB2.
Is there an easy method to migrate ...
3
votes
2answers
384 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 ...
