on 02-09-2006 8:13 AM
Hi Experts
I have a question on Change log table in ODS. When i execute a query on the ods, From where the OLAP Processor
get the data for the changed records....
1. Do i get the data from active table?
2. Do i get the data from change log table?
Regards
Annie
hi,
its active table only.
Every ODS objects is represented on the data base by 3 transparent tables.
1.Active data table : It is a table containing the active data .
2.Activation quene tube It is used for saving ODS data records that are to be updated but that have not have been activated. But the data is deleted after the records have been activated.
3. Change log table :
It is used for updating delta from the ODS objects into other data targets such as ODS objects (or) info cubes.
REegards,
Manoseelan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi Annie,
i think you are faster
hmm in practice it seems 'too fast' in a month, deleting psa has no effect to ods data delta (you will need psa to reconstruction), but change log 'helps' in handling data changes, normally data will still being change in a month, some even a year or more
hope this helps.
Hi Annie,
I hope the following links ll b useful to u.
http://help.sap.com/saphelp_nw04/helpdata/en/6d/1fd53be617d524e10000000a11402f/frameset.htm
http://help.sap.com/saphelp_nw04/helpdata/en/fb/0025391d4f000be10000000a114084/frameset.htm
http://help.sap.com/saphelp_nw04/helpdata/en/ea/597d3c7b159f6ce10000000a114084/frameset.htm
Hope it helps...let me know
Regards,
R.Ravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
For reports u will get the data from Active tables and if the ODS is feeding another ODS or Cube it will go from Change log table.
Hope this helps.
Rgds,
Ravindra.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi Annie,
bw query get data (last value) from active table.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The active one !
(In fact, it's enough to consider that on the active data table - and not the change log one - you can build index to gain in performance....) and to activate BEx reporting !
Bye,
Roberto
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.