Skip to Content
avatar image
Former Member

Loaded data amount into cube and data monitor amount

Hi,

when I load data into the cube the inserted data amount in the administrator section shows 650000 data sets. The monitor of that request shows a lot of data packages. When I sum the data packages, the sum is about 700000 data sets.

Where is the difference coming from?

Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 20, 2010 at 02:53 PM

    Check here...

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi ,

      If it is a full load to the cube , all the records are updated in it since in a cube data can be overwritten.

      If it is a delta load and u want to see why the difference occurs between the records transferred and added in cube ,

      u can go to the manage tab in dso , go to the contents tab ,there click change log button at the below , check the number of entries in that table , the number of entries are the added records in cube since only these records are the new records other records with the same key are already present in the cube.

  • avatar image
    Former Member
    Sep 20, 2010 at 01:11 PM

    Transferred 700000 vs 650000 added ?

    check if any routines in transformations between ds and cube which are not updating to the fact table

    Edited by: Srinivas on Sep 20, 2010 3:15 PM

    Add comment
    10|10000 characters needed characters exceeded