Delet Setup tables

[Former Member]

Hi Experts

why we need to delete setup table when extract structure change?

i know littel bit reduce the redandent of data! if it is wrong correct me.

if it is worng why?

if it is right could plz give little bit explanation?

Txs

Gita

[Former Member · Accepted solution]

Hi Vijay kumar

even i schdule the job i did not get data, we are using qued delta. But i want to know V3 also?

and Genaric explain with 3 delta options.

Tnks

Gita

[Former Member · Accepted solution]

When you are using Queue delta, then you should first check at LBWQ whether there are any Queues (similiar to MCEX11)present or not. If any queue is present only then when you schedule job at LBWE all the records present at LBWQ are moved to the RSA7.

Note :

Records that are posted to LBWQ are delta records. So, its happens only after you done init.

Coming to Generic

Scenario:

Assume that, your view contains a fields say doc number (numeric), created time, calender day, and there are 50 records with doc numbers 800100 to 800150 in it.

when you do initilization, all the 50 records will be moved to BW System.

Now, assume that, another 10 records(delta records) are added to the view i.e 800151 to 800161documents then how the system extracts these delta records? This depends on the delta option you selected.

1. Numeric Pointer : Your view should contain atleast one field like a counter (eg Sales doc number).

2. TimeStamp : Your view should contain atleast one field like time (eg created on)

3. Calendar day : You view should contain alteast one field like day (eg Document date)

Now, as you chosen Numeric pointer (then you have choose the field doc number), when you done the initilization, all the 50 records will be moved and the pointer points at record where doc number is 800150. Then, when you schedule delta load, all the records with doc number greater than 800150 are treated as delta records and will be extracted and pointer will be moved to record with doc number 800161

Assume that, your delta load is failed and no records are loaded to BW System. No when you do delta again, the system tries to pick records with doc number > 800161(as pointer is already moved). rite?

In order not to miss the delta records, the system maintains all the last delta records at RSA7 (you can see them, when you select repeat delta radio option) but you will never have current delta records in RSA7.

Hope you got the concept!!

Vj

[Former Member]

Thank u Vijay

Even schdule the job i did not get the Data to RSA7

what is the next procedure?

and i came to one conlustion for genaric there is no possiblity to 0 to 0 recodrs success fully updated even the data changes happen in the R/3 side??

Tnsk

Gita

[Former Member]

Yes, in the example that I took previouslu, though you have a changed a doc 800156 in R/3 side, you cannot extract this changed record to bw because already the pointer is moved to 800161.

"Even schdule the job i did not get the Data to RSA7"

As I mentioned, check whether you have any queues present at LBWQ. (as I understood you are using Queue delta).

thanks

Vj

[Former Member]

Plz let me clear at the end

Tnks

Gita

[Former Member]

HI Vijya Tnks for reply,

U mean for filling of 4th field data with historical data we have to delete the steup table? if i do not want the data to 4th field with the historical data there is no need delete steup table?

i am coming to the consultion as when we remodify the extractstructure, steup table data is not lost. if any worng in my words plz correct me....

i need all the senarios(in LO update mode v3 and queued, in genaric with time stamp, calday, numaric point) for data is not updated into delta queue

i read some forms but i am getting clear pic.. plz help me???

Thns&Reg

Gita

[Former Member]

Thanku very much kamal

k, u told it is better to delete setup delet table???

Ple i need clear explanation.

one more i have to doughts regarding

I) lo delta not updated into RSA7 in this senario what we have to do?

2) In genaric also same senario what we have to these senarios??

I refer some form links but i did not get

plz help these questions, i hope u will give the solution

Tnx

Gita

[Former Member]

Hi Gita,

Why we need to delete the setup tables, when we change the Extract Structure?

What is the structure of setup tables, I mean, what fields are present in the setup tables?.

The answer for this is, all the fields that you defined in the Extract Structure are present in the Setup tables. Now assume that you have defined Extract Structure with 3 fields, then setup table is generated with those 3 fields only. The only difference here is Extract Structure will not hold the data, where as setup tables holds the data. Now when you do Statistical setup, all the data are populated from application tables into setup tables for those 3 fields only.

Now assume that you have changed the Extract Structure by adding another field( now, a total of 4 fields). then when you activate the extract structure, setup table will regenarate with 4 fields but however, you will not have data from 4th field.

So, in order to populate data all the fields, you will first delete data in the setup tables, then change the extract structure, then do statistical setup again.

LO delta not updated into RSA&,

there can be many reasons, check what update method you are following.

You have the datasource listed in the RSA7? If not, then you didnt do the init properly.

If yes,

Probably, you are not using Direct Delta, instead you may be using Queue Delta or Unserialized V3 update. In such case, you have to schedule the job at LBWE.

In generic, also it is the same, anyway, let us know what delta option(is it timestamp or calday, or numeric) you are following.

Thanks

Vj

[Former Member]

Jasprit Singh

Thanku very much

i did not get u r explantaion could u give little bit clear!

Y we delete the setup tables?

Txs

Gita

[Private_Member_9643]

Lets say if you have done some init of setup table with some selection. Now some situtation comes when you want to do init your setup table again, in this case its better to delete old initlized values from setup tables, i.e. delete setup tables.

[Former Member]

Delete Setup Table and then Fill it , is done when we are doing reinitialization of the Cube Data.