Re: LIMIT OF FACT TABLE DATA
From: Dave Wickert [MSFT] (dwickert_at_online.microsoft.com)
Date: 07/22/04
- Next message: Ian Boyd: "Re: Time for my yearly question:"
- Previous message: Dave Wickert [MSFT]: "Re: real DTS/ETLM book?"
- In reply to: Akber: "RE: LIMIT OF FACT TABLE DATA"
- Next in thread: Fernando Ponte: "Re: LIMIT OF FACT TABLE DATA"
- Reply: Fernando Ponte: "Re: LIMIT OF FACT TABLE DATA"
- Reply: Dave Wickert [MSFT]: "Re: LIMIT OF FACT TABLE DATA"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 22 Jul 2004 09:28:30 -0700
There is no limit on the size of the fact table in Analysis Services. To use
a coined by Carl Sagan, I've seen partitions with BILLIONS and BILLIONS of
fact rows in them.
I would suggest that you look at some of the suggestions raised in the
Analysis Services Operations Guide
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx
One of its recommendations (in the section titled "Processing Log File") is
to enable the system-wide processing log file option and retain long term
history of the processing done on your system. In the log file are all of
the processing requests, the SQL statement used and the final row counts
resulting from processing.
-- Dave Wickert [MSFT] dwickert@online.microsoft.com Program Manager BI SystemsTeam SQL BI Product Unit (Analysis Services) -- This posting is provided "AS IS" with no warranties, and confers no rights. "Akber" <Akber@discussions.microsoft.com> wrote in message news:0BC3A29C-C530-45CF-98CA-B4899C12CF5F@microsoft.com... > My Warehouse Data is basically in Oracle and I am using SQL Server DTS for ETL and SQL Server Analysis Services for viewing the cube. > > I dont think so that the cube joins are the problem because the same cube was working fine previously. I think that there is some MOLAP memory issue in the Analysis Server. > Well I can try ur steps but how I can grab the T-SQL that Analysis Server sends to SQL Server while processing the cube > -- > Thanks > Akber. > > > "Akber" wrote: > > > I am using MOLAP storage for my cube. > > The problem which I am getting is that the cube stops showing the data for the month which it was showing correctly previously. I have populated my fact table with the data from the previous year i.e: from JUN 2003 till todate and is being updated every year. Last week the cube was displaying the data correctly for all the months but now it is not displaying any figures for the 2003 although my fact table in the database has data corresponding to that period. I am using full process method to process the cube. > > Whats the solution ? > > Is there any size limit on the MOLAP type cude data storage ? Might be that is the main problem but not sure. You gurus must be knowing best. > > > > -- > > Thanks > > Akber.
- Next message: Ian Boyd: "Re: Time for my yearly question:"
- Previous message: Dave Wickert [MSFT]: "Re: real DTS/ETLM book?"
- In reply to: Akber: "RE: LIMIT OF FACT TABLE DATA"
- Next in thread: Fernando Ponte: "Re: LIMIT OF FACT TABLE DATA"
- Reply: Fernando Ponte: "Re: LIMIT OF FACT TABLE DATA"
- Reply: Dave Wickert [MSFT]: "Re: LIMIT OF FACT TABLE DATA"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
