Hi,

This problem has been driving me crazy for the past few days and I really have no clue at all about how to solve the problem and where to look.

With 1 refresh of the cube the following MDX returns correct data but after the next update of the cube, the same MDX does not display any data at all

SELECT
{[Period].[All Period].[2005].[Quarter 1].Children} ON COLUMNS,
{[SalesType].[All SalesType].[Local],[SalesType].[All SalesType].[Exports]} ON ROWS
FROM Sales
WHERE ([Measures].[NetSales])


Desparately calling experts for some clues/what I should look for. Any clues please

Thanks.

************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

What kind of processing is the next update of the cube?

Refresh or full processing will remove all data and recreate the data from
the scratch. If the generated SQL statement during next update does not
retrieve the related data, it's natural that the data disappear.

Ohjoo Kwon

"Learner" <wantnospam (AT) email (DOT) com> wrote

all

Hi Ohjoo,

Thanks for the reply.

By the "next update" I meant that I am doing a full rebuilding of the dimension and FULL processing of the cube.

The reason for my confusion is that the source data is exactly the same but with every "update", it seems that the aggregations are getting messed up. Any clues??



************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

If a dimension is processed with rebuild, the cube containing it also has to
be processed with full process. It means all partitions within the cube also
have to be reprocessed respectively.

Ohjoo Kwon


"Learner" <wantnospam (AT) email (DOT) com> wrote

up. Any clues??

If the cube is partitioned, you need to check the partition containing the
data also was reprocessed.

Plus, you'd better execute the generated SQL statement during cube
processing at Query Analyzer.

Ohjoo Kwon


"Ohjoo Kwon" <ojkwon (AT) olap (DOT) co.kr> wrote

Thanks.

Yes I am doing a FULL process of the cube after I am doing rebuilding the dimensions. So I think so far I am okay.

Regarding the partitions: I did not create any partition 'MANUALLY' and the only parititon that I have is the one that was made automatically when I first created the cube. When I process the cube, the sole partition is getting processed correctly. I say this becuase the window (that appears when I process the cube) does not display any errors and everything appears to go correctly.

I did copy the SQL statement from the window that I have mentioned above and then ran it in QA. All i can say is that it runs and returns all the rows that are in my fact table -basically it returns a big flat unnormalized table.

But this brings me tomy original question i.e. what can be causing the problem that I am facing

Regards.

************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

If then, I think there must be not any problem.
Well...I'm trying to think out what problem...

I bother you again to find out the problem by yourself.

Change the storage mode to ROLAP.
Start Profiler.
Do cube processing.
Stop Profiler.
Follow the traced SQL during cube processing step by step.

I hope you can get some clue.

Ohjoo Kwon


"Learner" <wantnospam (AT) email (DOT) com> wrote

first created the cube. When I process the cube, the sole partition is
getting processed correctly. I say this becuase the window (that appears
when I process the cube) does not display any errors and everything appears
to go correctly.
rows that are in my fact table -basically it returns a big flat unnormalized
table.

Sounds very similar to a bug I came across in Analysis Services SP3.
They have a hot fix for it and theoretically it should be in the
upcoming SP4.

http://support.microsoft.com/default...b;en-us;829050


Ohjoo Kwon wrote:

Hi,

Thanks to both of you for your replies.

OLAPMOnkey thank you for showing me a ray of hope. I'll wait for SP4... any ideas when it will be released?

************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

It is in beta now and should ship late spring / early summer.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) 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.

"Learner" <wantnospam (AT) email (DOT) com> wrote