Skip to Content
author's profile photo
Former Member

Dataload from Cube to ODS

Hi Guru's,

I am trying to load data from cube to ODS ( Full update), My req is green in monitor and says that there are no records in corresponding source system , but I have records in cube, where to investigate this

its really urgent,

please answer me

thanks,

krish

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    author's profile photo
    Former Member
    Sep 30, 2005 at 10:01 AM

    Hi,

    Try this:

    Compress the cube and then load data to ODS.

    With rgds,

    Anil Kumar Sharma .P

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      I have seen the following statement in one of the note.Let me know if it is useful to you.

      <i>In addition, the DataMart interface always extracts with activated DB aggregation. The extraction of InfoCubes is the only exception in which key figures with one of the aggregation methods NO1, NO2 or NOP appear.</i>

      I hope,The note: 565086 is very use ful to you.

      It also gives the statement :

      If the SQL statement contains the fact view (name: /.../V<Infocube>F), deactivate the fact view temporarily, as described as in note 561961 (set the RSADMIN parameter to the value "NEVER").

      So try this.

      With rgds,

      Anil Kumar Sharma .P

  • Sep 30, 2005 at 10:06 AM

    Hi Krish,

    Could you please describe what you have done (export DS, which infopackage you scheduled etc.)?

    Best regards,

    Eugene

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Krish,

      please let us know the steps you did from generation of export data source to creation of update rules .... as suggested by eugene. It is not neccessary to compress a cubes data to load it into the next data targets.

      Siggi