i have various Resource/Project dimensions and 1 fact table and 1 Time
Period dimension
The dimensions are Resource and Project Info. The fact table contains the
keys and the resulting Actual Work and Scheduled Work
the dimensions process successfully; the cube processes successfully, the
database processes successfully,
However, there are records that don't display in the cube

I can see/query these 'missing' records in the fact table using Query
Analyzer. I've verified offsetting records in the Resource and Project
Dimensions

Is there a valid reason(s) or conditions or situations why the records would
be in the Fact table via query analyzer yet not show up in the cube?

any suggestions on what to troubleshoot would be greatly appreciated.

There is a possibility that your fact table has keys that are not in
one of your dimension tables. A good way to troubleshoot this would be
to get the SQL statement that AS generates when processing your cube
and paste it onto a query window and then remove one dimension table at
a time from the query to see which one returns the right number of
rows. This way you would have narrowed down to the offending dimension
table from where you can compare the values in it to the corresponding
values in the fact table.


TroyS wrote:

Thanks...
how would i go about getting...' the SQL stmt that AS generates when
processing your cube....'

I'm sure this is something in Analysis Manager but i'm not familiar with
extracting the cube process to a SQL statement

thx


"Karthik" <karthiksmiles (AT) gmail (DOT) com> wrote

Another posibility is if you have 'count' function for one of your measures
and a particular record has NULL value for that measure (i.e. Project # is
null). While Query Analyzer counts the entire row (i.e. count(*)), AS counts
non-null values of a specific column (i.e. count(project_ID)).

Pasha


"TroyS" wrote:

When the processing of the cube is done, the success dialog will have a list
of actions performed. Select the line that says "Partition 'Name' Execute:
SELECT ...." then click View Details. Copy and paste the statement to Query
Analyzer (delete everything before ":").


Pasha

"TroyS" wrote:

You can also turn on process logging in the server properties and the
relevant SQL statements will be saved to a text file.

When faced with these situations I usually comment out the field list
form the select statement and replace it with a "COUNT(*)", then I
comment out all the joins and add them back one at a time. If one of
your dimensions is excluding facts you will see the row count drop when
you add the offending join back.

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell