cancel
Showing results for 
Search instead for 
Did you mean: 

Records are not showed in Info Cube

Former Member
0 Kudos

Hi,

Data is successfully Loaded , Green, Records are shown in PSA.

But not showed in Info cube.

when I check Info cube ---> Manage

In the Requests Tab --- <i>Added Records are shown 400 records</i>

in <b>Transfered records 0 records.</b>

why Records are not added in Info cube ?

Please Help me.

Thanks

prasanna

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos
Former Member
0 Kudos

Hi Friends Prakash,shameem,sankar,srinivas, K.mohan

Thank you for your valuble time, I am checking the Update rules and other details

I will get back to you

soon I will assign points

Thanks

Prasanna

Former Member
0 Kudos

Hi Friends,

I applied the SAP note 353042.

Deleted Setup Data.

as per the note I choosen <i>industry sector. 'Standard'</i>

I set the <i>application indicator 'BW' to active, using Transaction 'BF11'.</i>

Filled the SetupData.

Now Records are Added, But not All Records.

<b>Transfered Records are 11084</b>, But <b>added Records are only 3235.</b>

any Idea Friends ?

I assigned points

Thank you

prasanna

Former Member
0 Kudos

Hi Prasanna,

Its not a problem with ur added records...

- It can be any routines used in ur updates rules

- If the records are havin same characteristic when you load data into a cube so the records are summarized by same characteristics

-In case of ODS due to Overwriten

thanks

Former Member
0 Kudos

Thank you srinivas for your Reply, I couldn't understand you, can yo give me Briefly why I am getting only few Records rather All Records .

waiting for your Reply

thank you once again

prasanna

Former Member
0 Kudos

hi,

Are u using any routines in ur update rules?

added records means num of records got summarized /filtered /deleted ...etc by using routines..

u can see this for each datapack @ RSMO> Details tab>Processing(data package)>update(1000>300)...

thanks

Former Member
0 Kudos

Hi srinivas Thanks for the Information.

Below is the Details information.

Processing (Data Packet): Everythig OK

Data Package 1 (11084 Records) : Everythig OK

Update PSA (11084 Records posted): No Errors

Data save in PSA started

11084 records written in PSA 2LIS_03_BF_GB

Transfer rules (11084 --> 11084 Records): No Errors

<b>Update rules (11084 --> 3235 Records): No Errors</b>

InfoCubes to be updated: 1 Cube(s)

InfoCube 0IC_C03 Will be Updated

Start of Update-rule processing for infoprovider 0IC_C03

End of update-rule processing for infoprovider 0IC_C03

Number of data records changed form 11084 to 9576 in start routine

Update (3235 new/0 changed): No errors

3235 records added to FactTable 0IC_C03

Processing end: No errors

Processing 2 finished

Processing 1 finished

-


total Records are 11084 Records but we are receiving only 3235.

Now my doubt, what we receiving records are filtered in Update Rules ?

Do i need to do some thing in Update Rules to receive All records ?

I am in confusing ?

can you help me please.

Thanks a lot

prasanna

Former Member
0 Kudos

Hi srinivas,

Yes I checked in Update Rules, There are routines are there

for all key figures ie : 17 routines are there.

Please check

I have pasted 2 routines

-


PROGRAM UPDATE_ROUTINE.

$$ begin of global - insert your declaration only below this line -

INCLUDE rsbctgn_top.

INCLUDE rsbctgn_update_rules.

$$ end of global - insert your declaration only before this line -

FORM compute_data_field

TABLES MONITOR STRUCTURE RSMONITOR "user defined monitoring

USING COMM_STRUCTURE LIKE /BIC/CS2LIS_03_BF

RECORD_NO LIKE SY-TABIX

RECORD_ALL LIKE SY-TABIX

SOURCE_SYSTEM LIKE RSUPDSIMULH-LOGSYS

CHANGING RESULT LIKE /BI0/V0IC_C03T-ISSVS_VAL

RETURNCODE LIKE SY-SUBRC

ABORT LIKE SY-SUBRC. "set ABORT <> 0 to cancel update

*

$$ begin of routine - insert your code only below this line -

  • fill the internal table "MONITOR", to make monitor entries

  • only goods issue is considered

IF ( COMM_STRUCTURE-processkey EQ '100' "Other Issues

OR COMM_STRUCTURE-processkey EQ '101' "Returns / Vendor

OR COMM_STRUCTURE-processkey EQ '104' "Material Transfer

OR COMM_STRUCTURE-processkey EQ '105' "Stock Adjustment InvD

OR COMM_STRUCTURE-processkey EQ '106' "Stock Adjustment Other

OR COMM_STRUCTURE-processkey EQ '110' ) "Issues from Stock Transfers

AND COMM_STRUCTURE-bwapplnm EQ 'MM'

  • only movements which are relevant for stock control

AND COMM_STRUCTURE-stockrelev EQ '1'

AND COMM_STRUCTURE-cppvlc <> 0

  • see OSS note 630254

AND ( COMM_STRUCTURE-stockcat IS INITIAL OR

( COMM_STRUCTURE-stockcat CA 'EQ' AND

COMM_STRUCTURE-indspecstk CA 'AM' ) ).

  • result value of the routine

RESULT = COMM_STRUCTURE-cppvlc.

  • if the returncode is zero, the result will be updated

RETURNCODE = 0.

ELSE.

  • if the returncode is not equal zero, the result will not be updated

RETURNCODE = 4.

ENDIF.

  • if abort is not equal zero, the update process will be canceled

ABORT = 0.

$$ end of routine - insert your code only before this line -

*

-


PROGRAM UPDATE_ROUTINE.

$$ begin of global - insert your declaration only below this line -

INCLUDE rsbctgn_top.

INCLUDE rsbctgn_update_rules.

$$ end of global - insert your declaration only before this line -

FORM compute_data_field

TABLES MONITOR STRUCTURE RSMONITOR "user defined monitoring

USING COMM_STRUCTURE LIKE /BIC/CS2LIS_03_BF

RECORD_NO LIKE SY-TABIX

RECORD_ALL LIKE SY-TABIX

SOURCE_SYSTEM LIKE RSUPDSIMULH-LOGSYS

CHANGING RESULT LIKE /BI0/V0IC_C03T-RECVS_VAL

RETURNCODE LIKE SY-SUBRC

ABORT LIKE SY-SUBRC. "set ABORT <> 0 to cancel update

*

$$ begin of routine - insert your code only below this line -

  • fill the internal table "MONITOR", to make monitor entries

  • only goods receipt is considered

IF ( COMM_STRUCTURE-processkey EQ '000' "Other Receipts

OR COMM_STRUCTURE-processkey EQ '001' "Goods Receipt / Vendor

OR COMM_STRUCTURE-processkey EQ '004' "Material Transfer / Receipt

OR COMM_STRUCTURE-processkey EQ '005' "Stock Adjustment InvD

OR COMM_STRUCTURE-processkey EQ '006' "Stock Adjustment Other

OR COMM_STRUCTURE-processkey EQ '010' ) "Receipt from Stock Transfer

AND COMM_STRUCTURE-bwapplnm EQ 'MM'

  • only movements which are relevant for stock control

AND COMM_STRUCTURE-stockrelev EQ '1'

AND COMM_STRUCTURE-cppvlc <> 0

  • see OSS note 630254

AND ( COMM_STRUCTURE-stockcat IS INITIAL OR

( COMM_STRUCTURE-stockcat CA 'EQ' AND

COMM_STRUCTURE-indspecstk CA 'AM' ) ).

  • result value of the routine

RESULT = COMM_STRUCTURE-cppvlc.

  • if the returncode is zero, the result will be updated

RETURNCODE = 0.

ELSE.

  • if the returncode is not equal zero, the result will not be updated

RETURNCODE = 4.

ENDIF.

  • if abort is not equal zero, the update process will be canceled

ABORT = 0.

$$ end of routine - insert your code only before this line -

*

ENDFORM.

-


Thanks

prasanna

Former Member
0 Kudos

hi,

The records got filtered @ Start Routine level...and updated few records to cube

Sit ith Abaper and Debug the start routine and try to understd the logic why it gets Filterd/deleted...

thanks

Former Member
0 Kudos

Thanks Srinivas.

prasanna

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

Check is there any rountine at TR rules level or Update rules level.

Regards

Sankar

Former Member
0 Kudos

Hi Prasanna,

Check your update rules.....And check the "Details" tab in the Monitor Screen, that should tell you, what went wrong.

Also have a look at these threads:

Sham'm

Former Member
0 Kudos

hi..

are you filtering data in your Start Routine?

do you have any Start or End Routines?

check your transformations.

What is your DTP Setting, FULL LOAD or DELTA? I want you to try with FULL Load. If it won't work... try below one...

In the rules details... all the Rules assigned to "Direct Assignment". in the Source fields section... assign IO to Field and activate your Transformation and reload your Data.

hopr it helps..

Former Member
0 Kudos

Hi Prakash Thank you for immidiate Response,

I am loading Data to a Business Content Cube 0IC_C03,

I am using the Data source : 2LIS_03_BF

I am doing Full Update.

I am working with BI 7.0, but i am following 3.5 senario.

source system ---> Data source ---> PSA --- > TR ---> IS ---> UR -- > Cube

no start Routinees are there.

Thanks

prasanna

Former Member
0 Kudos

Hi Prasanna..

Did u loaded 2lis_03_BX and Compressed marker Update.

Please check this thread and let me know..

thanks

Former Member
0 Kudos

Hi,

Transferred records are the records that had passed your Transfer Rules.

Added records are the ones that get past your Start Routines and the individual routines that u write for the characteristics present in the update rules.

so whenever u have added records as zero, it means your records have got deleted when it passed the update rules.

If you still face issues, let me know what you see in the details tab.

sham'm