dbTalk Databases Forums  

Analysis Services Processing Task Not Doing a Full Process

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Analysis Services Processing Task Not Doing a Full Process in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Sara
 
Posts: n/a

Default Analysis Services Processing Task Not Doing a Full Process - 02-13-2004 , 12:29 PM






I have a DTS package that is set up to process the dimensions
contained in my cubes. They are set to rebuild the dimension
structures (and process). I have another DTS package that is set to
process the cubes, and these are set to do a full process. However, I
recently changed some of the data in one of the dimension tables, ran
the packages that are supposed to rebuild the dimension structure and
do a full process of the cubes, but I did not see the changes
reflected within that dimension in the cube. I then re-ran the
packages: same thing. So I manually rebuilt and processed the
dimensions and did a full process of the cube. I then was able to see
the changes reflected in the cube. How is this possible? The DTS
Analysis Services Processing Task does not appear to be doing what it
says it is doing. By the way, I could not determine whether it was
the dimension that was not really being rebuilt or the cube that
wasn't really being fully re-processed, b/c I have too much data in
the dimension to see all of the data in the dimension when I choose
'browse data'...the data of concern was toward that bottom of the
list, and the end of the list said something like '(more members exist
than can be displayed)'. I do know, however that that relational
dimension table did show my changes. Can anyone tell me why the DTS
packages aren't doing what they should be doing? Thanks!

Reply With Quote
  #2  
Old   
Nick Schueler MSFT
 
Posts: n/a

Default RE: Analysis Services Processing Task Not Doing a Full Process - 02-29-2004 , 12:19 AM






Hi
You may be running into the problem described in the following article:

834777 FIX: Some cubes are not processed by the process database operation
http://support.microsoft.com/?id=834777

Nick Schueler
--------------------
Quote:
From: sara2thebradley (AT) yahoo (DOT) com (Sara)
Newsgroups: microsoft.public.sqlserver.dts
Subject: Analysis Services Processing Task Not Doing a Full Process
Date: 13 Feb 2004 10:29:23 -0800
Organization: http://groups.google.com
Lines: 21
Message-ID: <ce695524.0402131029.1f88302b (AT) posting (DOT) google.com
NNTP-Posting-Host: 198.26.122.12
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1076696963 24714 127.0.0.1 (13 Feb 2004
18:29:23 GMT)
X-Complaints-To: groups-abuse (AT) google (DOT) com
NNTP-Posting-Date: Fri, 13 Feb 2004 18:29:23 +0000 (UTC)
Path:
cpmsftngxa07.phx.gbl!cpmsftngxa06.phx.gbl!TK2MSFTN GP08.phx.gbl!newsfeed00.su
l.t-online.de!t-online.de!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!po
stnews1.google.com!not-for-mail
Quote:
Xref: cpmsftngxa07.phx.gbl microsoft.public.sqlserver.dts:44423
X-Tomcat-NG: microsoft.public.sqlserver.dts

I have a DTS package that is set up to process the dimensions
contained in my cubes. They are set to rebuild the dimension
structures (and process). I have another DTS package that is set to
process the cubes, and these are set to do a full process. However, I
recently changed some of the data in one of the dimension tables, ran
the packages that are supposed to rebuild the dimension structure and
do a full process of the cubes, but I did not see the changes
reflected within that dimension in the cube. I then re-ran the
packages: same thing. So I manually rebuilt and processed the
dimensions and did a full process of the cube. I then was able to see
the changes reflected in the cube. How is this possible? The DTS
Analysis Services Processing Task does not appear to be doing what it
says it is doing. By the way, I could not determine whether it was
the dimension that was not really being rebuilt or the cube that
wasn't really being fully re-processed, b/c I have too much data in
the dimension to see all of the data in the dimension when I choose
'browse data'...the data of concern was toward that bottom of the
list, and the end of the list said something like '(more members exist
than can be displayed)'. I do know, however that that relational
dimension table did show my changes. Can anyone tell me why the DTS
packages aren't doing what they should be doing? Thanks!



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.