on 09-25-2006 3:23 PM
Hi,
I want to increment a counter in an ODS when loading data into a cube.
The ODS looks like this :
0CALYEAR | 0FC_COUNT |some other charac.
The cube has a start routine. Everytime the start routine is called, I would like to update the ODS counter according to 0CALYEAR specified in the infopackage.
Does anybody has a clue on how to do that ?
Thank you very much
Pierre-Yves
What is the key of the ODS? 0CALYEAR??
You can do an SQL 'UPDATE' at the end of the start routine to the active table of ODS. However, that is a bad idea.
Do you really want to update it once for each start routine run (start routine can multiple times for the same load execution if there are multiple data packets)?
If you do have to update the ODS this way, you should probably -
- Create a Z table with ODS key and this no field;
- update the Z table in the start routine
- create a datasource on this z table and update the ODS with it.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It might be easier to load through a z table.
Have an ABAP program run after the successful run of load to cube (as next step in the process chain) which creates an entry in the z table, incrementing count by 1. Or if it is ok, this program can directly read the active table of ODS and update the same by incrementing the count using SQL (again, a bad idea to directly update the ODS table).
I am not sure if this 'count' is going to be much useful. What if you back-out an incorrectly loaded request (will it decrease the count?), or, if it is a 'repeat delta' or 'repair full' kind of requests, how would you apply this logic? It might be easier to check the no of requests from the 'manage' tab of the cube, or, go to say table RSICCONT in SE16 and get the no of records for a cube (which will give you the no of requests added to it).
User | Count |
---|---|
98 | |
11 | |
11 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.