on 2013 Jun 26 9:55 AM
Hi,
Cost Center Masterdata in BW is currently time dependent and therefore restricts users from doing year over year comparisons based on valid masterdata for a given time period.
The business would like to do year over year reporting with masterdata being valid for the given time period. For example, if 2011 Cost Centers are being compared to 2012 the masterdata for 2011 must display for that result set and 2012 masterdata for that year in the same report. Currently BEx offers a key date field in the query properties that only allows the user to chose a single date for a given year. This limits the users ability to do year over year comparisons with relevant masterdata.
please suggest me some solution.
As Yasmein said, You have to handle this in the Infoprovider level. Add the attribute fields to the Infoprovider and use Read master data rule type.
Finally, you can use these date fields in the query filter or in default values panes.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ompreet,
Assume you have 0profit_ctr as the attribute of 0costcenter. Assume your data is:
0costcenter 0date 0amount
A1 01.01.2012 5
Assume profit center for A1 is now PC1, but it was PC2 at the time of 01.01.2012. To show that add profit center to your infocube. While assigning in the transformation, add 0costcenter and 0date characteristics to source fields of the rule for profit center (in the rule assignment screen). Select rule type as "read master data", select 0costcenter in "from attr. of" dropdown. You will see a clock icon in the right side. Click on that and in the screen select 0date in "start frm" dropdown.
Hope it helps
Yasemin...
This link will address your requirement.
HI,
Does Cost center master data in added in Dimesion of respected IC.
Then it will store historical data for respected Cost center.
Regards,
Vijay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ompreet,
For this kind of requirements we generally use to handle that in infocube level in our system. You can add the master data attributes to the dimensions of the cube, and fill them throug transformation. In the rule you can assign the date acordingly.
Hope it gives an idea
Yasemin...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
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.