on 07-04-2011 6:22 AM
Hello Experts.
In month dataview when we copy value from one KF to other via macro, it gets copied correctly, but when a week lies in two month, the values is not correctly copied.
Take e.g. of last week of Aug 2011, where it lies in Aug as well as in Sept. In Month dataview the values are copied corrected in Aug & Sept, but not in week view. Can anyone please help me, how to fix this. We want the same values in week data view too.
Regards
Rahul Chitte
Hi Rahul Chitte ,
I think you are executingor created macro for montly data view .So system copies the values for month view.
If you display these values in weekly view in this case system applies the time based dusaggregation,so the values may not be same as sorce KF.if you want same results as in weekly view of source KF then create the macro in weekly view.
Regards,
Sunitha
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Rahul
I think you will notice a difference between monthly and weekly views when the week falls in two months. Taking the same example that you have used , lets say the value for august month is 100 ( for the last week that falls in aug and sep the value is 25 + 35 for the 3 days of aug it is 25 and for 4 days in sep it is 35). So in the monthly view you will see 100 and this 100 will just include the 25 of the last week and the 35 will be taken into account in sep month. But in the weekly view the entire 25+35 (60) will show up against that the last week of aug and that makes perfect sense . If your doubt is still not clear , please elaborate your requirement
Thanks
Aparna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
4 | |
3 | |
2 | |
2 | |
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.