Cube creation 
Author Message
 Cube creation
I have been creating large cubes very successfully.  I was
on my 8th one when it didn't process properly.  My SQL
table has 14,953,206 rows.  The cube process ended without
error but only had 8,917,056 rows accounted for.

I copied my table starting at row 8,900,000 and started
the process again.  This time out of 6,053,207 rows I
ended up with 3,710,303.

Does anyone have a clue where to start to figure this out?



Sun, 03 Apr 2005 05:55:43 GMT
 Cube creation

Does your cube is optimized ?

if not, then Analysis Services used a joined query with each dimension table
to insure that each row read from the database has a member for each
dimension.

so, control if your source table is correctly filled and each row is
correctly linked to your dimension table.

For example, if you input table is linked to a "product" table, added an
"unknown" product, and link all rows without a good product to this unknown
product. (and do this for each dimension)

finally, if your input table is correctly configured and each row is
correctly linked to each table, then you can optimize your cube to
accelerate the process time.

Good luck.



Quote:
> I have been creating large cubes very successfully.  I was
> on my 8th one when it didn't process properly.  My SQL
> table has 14,953,206 rows.  The cube process ended without
> error but only had 8,917,056 rows accounted for.

> I copied my table starting at row 8,900,000 and started
> the process again.  This time out of 6,053,207 rows I
> ended up with 3,710,303.

> Does anyone have a clue where to start to figure this out?



Sun, 03 Apr 2005 08:15:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Alternative Regular Cube creation besides Cube wizard/Editor method

2. Is any C++ sytax or sample for Cube creation

3. any guides on this? (cube creation)

4. Global Cube Creation BUG (675)

5. CUBE - Creation ??

6. Problem: Define Custom member on local cube creation (Not measures dimension)

7. Is there Any C++ syntax/sample for cube creation (.cub)

8. basic cube creation

9. Dynamic cube creation

10. Analysis Server & Remote Cube Creation Problem

11. help for two text tables(dim and FACT table) for local cube creation.


 
Powered by phpBB® Forum Software