Question:
I have two data loads into the cubes and at time of the data load I need to take into account one figure called discount rate before loading the data the discount rate as to be applied to each record loaded into the cube.
But our users constantly change this single number - discount rate please can any of you suggest the best way of implementing this.
Thanks
Sheryl
Answer:
if this figure is in R/3
Enhance the extractor and fill this field in the user exit.
If this figure is in BW (i don't think so)
Retrieve the figure in the start routine of the update rules.
Gr,
M.
Answer:
This value is in BW. As I said it is a simple scenario
I have a number discount percentage that would be 25%
this month and could be 18% next month. This value as
to be taken into account at the time of data load and
applied to all record.
Cannot see how to implement this in BW.
Thanks
Sheryl
Answer:
Maintain discount rate as an attribute of an infoobject. Your users can maintain the value of this discount rate manually or you may have to create a screen to populate this value. Further if you need to keep track of changes make this attribute time dependent.
Use the above value in the start routine / transfer rules in the calculation.
Does that help???
Answer:
Elango
Thanks for the tip.
But to maintain master data I need to give Admin workbench access and also access to SAPgui for BW.
Some people do not want access to be given to users for SAPGui in BW. This is the only issue I see any solutions to this ?
Thanks
Sheryl
Answer:
In that case maintain a Ztable for this info object in R/3 and let them maintain this ztable there. Create a generic data source on this and feed it as a mster data into BW dependng on the frequecy of the changes and using the start routine you can call this while uploading it to tge cube.
Other option maintain this value in a flat file and upload it to a master data in BW and use start routine to fill it.
Bugs life
Answer:
The sad part is SAP is still so primitive even to maintain this Ztable users need the SAPGui access - we are back to square one. I looked at all these issues.
Thanks
Sheryl
Answer:
well in that case I would think may be it is maintained as a flat file and then loaded as a flat file and work with the start routine. Any time this value changes they could update it to bw as master data. This seems to be the only solution if the users dont want to get acces to sap Gui at all.
Bugs life