on 10-08-2008 11:25 PM
Hi,
I would like to add cost center to existing layout.
Currently we are loading data into BCS using flat file .
In BCS we have current layout existed with below format.
Header
Controlling area
Fiscal year
Posting period
Data Rows
Company
Item
Profit Center
Functional area
Trading partner
Period Value LC
Period Value GC
Even we are getting flat file from R/3 as above format.
Now our Business required cost center in BCS as their requirment and need to be bring from R/3 to BCS.
In R/3 our ABAP people are working to bring the cost center from R/3 and made a flat file for us.
In BCS we need to load the file which has new cost center,which was comming as per the new requirment.
Please advise me how to add cost center in Data Rows of BCS.So that it can accomidate new cost center which is comming from R/3.
Please some advise me on this and answer would be appreated.
First step is to ensure, in BW workbench, that cost center is already a characteristic in the BCS Basic/Transaction InfoCube . If not, it must be added. However precaution is advised with any such change as it is significant change.
Second, in the BCS workbench, in the databasis it must be ensured that cost center is assigned a role of subassignment. If not, it must be added and the databasis must be subsequently regenerated.
Third, in the BCS workbench, ensure cost center is assigned to the cons area. If not, it must be added and the cons area must be subsequently regenerated.
Fourth, in the flexible file method, the cost center must be added: UCWB > Consolidation Functions > Data Collection > Flexible Upload. Drag the characteristic cost center to the placement in the data rows where it is to be in the file. Save the changes.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks alot Dan.
I need to include Cost center in BCS Basic/Real time cube.
In our case the Cost center is not avaialble in the BCS Cube.
Then i need to follow the steps which you told me.
Step 2: I need to assign the cost center to assigned a role of subassignment.But i am not able find the roles UCWB.
In BW, once the characteristic is added to the infocube, it must be assigned to the dimension "subassignment". Then in the databasis it should be available for this role.
Dan, that's not accurate. There is no such a requirement. Not necessarily to place the characteristic into 'Subassignment' dimension. Any dimension (except of the system's one, like time etc.) is suitable.
Prasad,
I knew how to add char to cube in BW.But i am not sure about BCS .
- What's the difference in assigning the infoobject (CostCenter) to the infocube, doesn't matter if it's the basic (ordinary) or the BCS totals cube?
I will follow as you said.
- Taking the BW310 or SEM240 is very useful.
Once it is done then what are the next steps need to do it.
- What's done? What's the question?
I am assigning points to you
- I do not need the points assigned for nobody knows what. Feel free to unassign them.
Hi Prasad
It is not advisable to add cost center to the existing data model since it will mess up the existing data. SEM BCS is a different animal than BW and you need to understand the whole functionality end to end. Your problem will not be solved just to know how to add cost center to the existing data model which has wide ramification if data is already there in the system.
Siva Kumar,
How would i accomidate Cost center characterstic in BCS.
The current flow cost center was not available and the falt file which i am getting have a cost center now.
withough having cost center characterstic in BCS,how can i load the flat file which has cost center in BCS.
Please advise me.
User | Count |
---|---|
9 | |
4 | |
3 | |
3 | |
2 | |
2 | |
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.