Processing Quirks between SSAS 2005 and AS 2000 -
11-24-2006
, 04:46 AM
Migrating a cube from AS 2000 to SSAS 2005
Couple of issues noticed that causes inconsistencies in AS 200 and SSAS 2005.
1. Dimension processing
If there are multiple records for a dimension member then the processing
behaviour for AS 2000 is not consistent with regards to SSAS 2005. SSAS 2005
will not necessarily pick up the same record that AS 2000 picks up from the
same source.
2. ProcessAdd behavior (in SSAS 2005) is not consistent with the
IncrementalUpdate behavior in AS 2000.
Scenario - DImension and cube have been processed. A new record is added
to the dimension table that matches an existing record in terms of member
keys.
Issue - When doing a processadd the new member replaces the existing
member as the member key values match. However when we do a full process for
the cube (without filtering data in the fact table that correspond to the old
dimension member) the aggregated value reflects both the new and the old fact
data. Incremental update of a Dimension and subsequent Full process of cube
does not work similarly in AS2000. |