These are loose comparisons of terms between AS 2000 and AS 2005 - I
don't think that, for example, a cube in AS 2005 behaves exactly as a
virtual cube would in AS 2000.
So, Process Structure doesn't look like it will achieve what you want,
based on this MSDN paper covering AS 2005 processing. Not sure what the
solution, but this paper may help; or if someone else on the NG knows
about it ...
http://msdn.microsoft.com/library/de.../en-us/dnsql90
/html/sql2k5_asprocarch.asp
Quote:
|
Analysis Services 2005 Processing Architecture
|
T. K. Anand
Microsoft Corporation
June 2005
Applies to:
SQL Server 2005 Analysis Services
Summary: Processing is the operation in which the Analysis server reads
data from the relational data source and populates the cubes,
dimensions, mining models, etc. This whitepaper describes the Analysis
Services 2005 processing architecture in detail and provides guidance on
how and when to use the various processing controls.
...
ProcessStructure for cubes is the equivalent of the Analysis Services
2000 processing option, processBuildStructure, in DSO. It discards the
storage contents of the cube and its partitions. It implicitly does a
ProcessDefault on all dimensions of the cube and marks the cube as
processed. At this point, the cube is available to queries but it will
not return any fact data. This is supported mostly for
backward-compatibility reasons.
...
- Deepak
Deepak Puri
Microsoft MVP - SQL Server
*** Sent via Developersdex http://www.developersdex.com ***