dbTalk Databases Forums  

SSAS2005 processing cube with multiple measure groups

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss SSAS2005 processing cube with multiple measure groups in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jesse O.
 
Posts: n/a

Default SSAS2005 processing cube with multiple measure groups - 10-05-2006 , 01:39 PM






From my understanding, these are how the terms have changed from AS2000 to
SSA22005.

A Virtual Cube is now a Cube.
A Cube is now a Measure Group.

Am I correct in making this assumption?

I have a cube with nine measure groups. One ouf of those nine measure groups
has been processed. I'd now like to see it in the cube.

I don't need to process the data since it's already been processed by the
AMO code I've executed.

So I used Process Structure to process the cube (thinking this was the same
as processing a Virtual Cube in AS2000). The cube now shows up in UI,
however the data for the measure group isn't showing up. Tried Process
Index, nothing either.

Any idea what's going on?




Reply With Quote
  #2  
Old   
Deepak Puri
 
Posts: n/a

Default Re: SSAS2005 processing cube with multiple measure groups - 10-06-2006 , 12:55 PM






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.
...
Quote:

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.