on 04-17-2014 4:49 AM
Hi
Is ther is any method for deleting the dimension members and processing the dimension after that automaticaly.
in the members ther is a hierachy existing .plese give teh code
Thank you
But deleting of members requires also deletion of all transaction data stored on this member...
Vadim
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Posting a transaction data of 0 is not the same as deleting the transaction record. You need to remove that record, completely, from the database. This means you need to do a lite optimization using the 0 compression.
However, its not only deletion of the transaction data. You also need to ensure that the member is not referred anywhere, for example, in the BPFs.
Hope this helps.
we are creating a dummy wbs members with values and need to copy that value sto th e original once teh budget got approved .after copying the values the DUMMy wbs need to deleted.
So i am using the badi custom logic and in the ct_data making the dummy as 0 and the copying the value to th eoriginal .
then using the save method with row flag eq D and using Process method to automaticaly procedd teh dimension.
but not getting the expected .please help.
thank you
*START_BADI Z_MOVE_DUMMY
QUERY = ON
WRITE = ON
*END_BADI
code
LOOP AT ct_data ASSIGNING <ls_rec> .
<ls_result_rec> = <ls_rec>.
READ TABLE <fs_members_result_table_cx> ASSIGNING <fs_member_attr_wa_cx>
WITH KEY ('ID') = <fs_project>.
IF sy-subrc EQ 0 .
ASSIGN COMPONENT 'PROJECT_NEW' OF STRUCTURE <fs_member_attr_wa_cx> TO <fs_prjnew>.
IF <fs_prjnew> IS NOT INITIAL .
ASSIGN COMPONENT 'SIGNEDDATA' OF STRUCTURE <ls_result_rec> TO <fs_signeddata>.
lv_value = <fs_signeddata>.
CONDENSE lv_value.
CLEAR <fs_signeddata>.
APPEND <ls_result_rec> TO <lt_final>. for zero
<fs_signeddata> = lv_value.
<fs_project> = <fs_prjnew>.
APPEND <ls_result_rec> TO <lt_final>. for new value
ELSE.
APPEND <ls_result_rec> TO <lt_final>.for existing value
ENDIF.
ENDIF.
ENDLOOP.
REFRESH :ct_data.
ct_data[] = <lt_final>.
free <lt_final>.
sort ct_data.
please help
no 😞
i have tried that also .getting a successful log with details
QUERY: ON
WRITE: ON
BADI EXECUTION TIME IN TOTAL :41625.00 ms.
DATA TO WRITE BACK:
ACCOUNT BUDGET_VER CATEGORY CURR DATASOURCE DIVISION PROJECT TIME SIGNEDDATA
666701 Final Beyond_Budg_Yr AED Input 110000 1065512 2015.12 175.00
666701 Final Beyond_Budg_Yr AED Input 110000 1100001.2015.00001 2015.12 0.00
666701 Final Beyond_Budg_Yr AED Input 110000 1100001.2015.00002 2015.12 0.00
666701 Final Beyond_Budg_Yr AED Input 110000 1100001.2015.00003 2015.12 0.00
666701 Final Beyond_Budg_Yr AED Input 110000 1100001.2015.00004 2015.12 0.00
666701 Final Beyond_Budg_Yr AED Input 110000 1100001.2015.00005 2015.12 0.00
666701 Final Beyond_Budg_Yr AED Input 110000 1100002.2015.00001 2015.12 40.00
666701 Final Beyond_Budg_Yr AED Input 110000 1100002.2015.00002 2015.12 20.00
666701 Final Beyond_Budg_Yr AED Input 110000 1100002.2015.00003 2015.12 35.00
666701 Final Beyond_Budg_Yr AED Input 110000 1100002.2015.00004 2015.12 30.00
666701 Final Beyond_Budg_Yr AED Input 110000 1100002.2015.00005 2015.12 50.00
666701 Final Budg_Yr AED Input 110000 1065512 2015.12 125.00
666701 Final Budg_Yr AED Input 110000 1100001.2015.00001 2015.12 0.00
666701 Final Budg_Yr AED Input 110000 1100001.2015.00002 2015.12 0.00
666701 Final Budg_Yr AED Input 110000 1100001.2015.00003 2015.12 0.00
666701 Final Budg_Yr AED Input 110000 1100001.2015.00004 2015.12 0.00
666701 Final Budg_Yr AED Input 110000 1100001.2015.00005 2015.12 0.00
666701 Final Budg_Yr AED Input 110000 1100002.2015.00001 2015.12 10.00
666701 Final Budg_Yr AED Input 110000 1100002.2015.00002 2015.12 20.00
666701 Final Budg_Yr AED Input 110000 1100002.2015.00003 2015.12 25.00
666701 Final Budg_Yr AED Input 110000 1100002.2015.00004 2015.12 40.00
666701 Final Budg_Yr AED Input 110000 1100002.2015.00005 2015.12 30.00
666701 Final Budget AED Input 110000 1065512 2015.12 300.00
666701 Final Budget AED Input 110000 1100001.2015.00001 2015.12 0.00
666701 Final Budget AED Input 110000 1100001.2015.00002 2015.12 0.00
666701 Final Budget AED Input 110000 1100001.2015.00003 2015.12 0.00
666701 Final Budget AED Input 110000 1100001.2015.00004 2015.12 0.00
666701 Final Budget AED Input 110000 1100001.2015.00005 2015.12 0.00
666701 Final Budget AED Input 110000 1100002.2015.00001 2015.12 50.00
666701 Final Budget AED Input 110000 1100002.2015.00002 2015.12 40.00
666701 Final Budget AED Input 110000 1100002.2015.00003 2015.12 60.00
666701 Final Budget AED Input 110000 1100002.2015.00004 2015.12 70.00
666701 Final Budget AED Input 110000 1100002.2015.00005 2015.12 80.00
33 RECORDS HAVE BEEN WRITTEN BACK.
(AED.'000') | |||||
Project Code | Description | Proposed 2015 Budget | Expenditure Profile | UPLOAD DOCUMENT | |
Budg Year 2015 | Beyond Budget Year 2015 | ||||
1100001 | 1100001 | 300 | 125 | 175 | Upload Document |
1100001.2015.00001 | Dummy | 50 | 10 | 40 | 0 |
1100001.2015.00002 | Dummy | 40 | 20 | 20 | 0 |
1100001.2015.00003 | Dummy | 60 | 25 | 35 | 0 |
1100001.2015.00004 | Dummy | 70 | 40 | 30 | 0 |
1100001.2015.00005 | Dummy | 80 | 30 | 50 | 0 |
I suggest that you reassign the hierarchy parent to an 'Archived WBS' node. This will separate from your WBS members from SAP, and your 'Plan / Dummy WBS' that were created only in SAP BPC.
Once this is reassigned to a new parent, users will need to refresh their master data (you can do this via the EPM Add-in under 'More' or create a button for hte user to use VBA; then they should see the amount.
If there is truely no data (your ABAP has offset / deleted the data against the member you currently plan to delete) then an administrator can delete them weekly or monthly with ease if you have a lite optimise (with zero elimination) scheduled daily.
Hi All,
The issue because of the BADI UJR_WRITE_BACK. I am using this badi for the same model .so when running this DM the write_back badi is executing and all the data is got refreshed.
Is ther any way to get the running DM name .so i can put the check inside the badi .
Thanks for all the replies .
Hi,
You need to look into the class - IF_UJA_DIM_DATA.
Please refer to the below link from SCN:
http://scn.sap.com/docs/DOC-41342
Hope this helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
13 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.