Re: Cube Processing Problem...

#1

If you look at the Advanced button at the bottom of the processing page, you
will see that you can specify an output file which contains those fact table
records which have missing dimension members. I would try that and then look
at the records that where being recorded. You can either specify a limit,
like only allowing 100 error like this, or ignore output all error rows.

Hope that helps.

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"aarkay1" <member32218 (AT) dbforums (DOT) com> wrote

Quote:

I am having this unique problem while trying to process a cube. Every
time I try to process - Incremental or Full - it results in the
following error message:-

Analysis Server Error: Processing error [Object does not exist] 'All

01/01/2001

01/01/2001

01/02/2001' ;

We are using Sql Analysis Server 2000 with sp3 on a Pentium box having
Windows 2000 on it. I did some research and found an MS KB article #
234660 which said the same problem had existed with sql server 7, and
was later fixed in its sp2 release.

In my cube, I have more than 24 partitions, each with anywhere between
400K to 120K rows of data. The cube consists of 8 multi level dimensions
and has 4 measures in all.

I would appreciate any hint or help anyone can provide to resolve
my problem.

- Raj

--
Posted via http://dbforums.com

#2

I had the same error message once:

Reason was, that the dimension had properties and the queries retrieving the
property values didn't match the structure the first query returned. I found
that by copying the queries from the details of the processing dialogue to
the query analyser and checking the result sets.
Please check the number of rows returned by the statements: It should match
the number of elements on each level.

HTH
Stefan Rahlf [MIS]

"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> schrieb im Newsbeitrag
news:ue9j95ocDHA.2932 (AT) tk2msftngp13 (DOT) phx.gbl...

Quote:

If you look at the Advanced button at the bottom of the processing page,
you
will see that you can specify an output file which contains those fact
table
records which have missing dimension members. I would try that and then
look
at the records that where being recorded. You can either specify a limit,
like only allowing 100 error like this, or ignore output all error rows.

Hope that helps.

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no
rights.

"aarkay1" <member32218 (AT) dbforums (DOT) com> wrote in message
news:3327452.1062630317 (AT) dbforums (DOT) com...

I am having this unique problem while trying to process a cube. Every
time I try to process - Incremental or Full - it results in the
following error message:-

Analysis Server Error: Processing error [Object does not exist] 'All

01/01/2001

01/01/2001

01/02/2001' ;

We are using Sql Analysis Server 2000 with sp3 on a Pentium box having
Windows 2000 on it. I did some research and found an MS KB article #
234660 which said the same problem had existed with sql server 7, and
was later fixed in its sp2 release.

In my cube, I have more than 24 partitions, each with anywhere between
400K to 120K rows of data. The cube consists of 8 multi level dimensions
and has 4 measures in all.

I would appreciate any hint or help anyone can provide to resolve
my problem.

- Raj

--
Posted via http://dbforums.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Cube Processing Problem...

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

Re: Cube Processing Problem... - 09-03-2003 , 09:44 PM

Re: Cube Processing Problem... - 09-04-2003 , 05:04 PM