Hi techies
I am facing a peculiar problem.. I need to change salary revision status from the present percentage to the new percentage. But if I change to new percentage Salaryrevision%5 to salaryrevision%new..
Value of salary revision is getting changed in both actual and budget versions.. can anyone please help me in solving the issues. please i am in deep trouble with this.. and its of high importance..
regards
cogplan
Hi Cogplan,
I'll need a touch more detail to be able to help out here. Is this Analyst or Contributor? What's the difference between Actual and Budget versions in your system - are these 2 models, or do you have a dimension with Actual and Budget? What's the nature of the change you're trying to make in Cognos Planning terms, is this a change to a d-list item's calculation field from an old percentage to a new one?
If you're updating the d-list item, this will apply to anywhere this item occurs. Would it make sense to add a d-list item for 'SalaryPercentage' to the cube you're using, then populate it appropriately for each period or budget/actual? If you then changed your calculation from SalaryRevision=Salary*0.05 to SalaryRevision=Salary*SalaryPercentage it would then pick up dynamic percentages.
You could also look into populating this field by d-link from an assumption cube.
I hope that gives some ideas to follow up.
Regards,
Alexis
Thanks Alex
You have provided me another way of doing it.
Actually model is the same and only version dlist has Actual and budget dlist items.And cube was using only a single calculation dlist all throughout the model. Hence I have made certain changes in the calculation dlist itself
Calc Dlist Changes
I have created a new dlist item say version , used the dlist fomatted items by calling version dlist items say actual, budget
After that in Salary Revision Calculation
If (Version=0)
then (Salary Revision)%5
If (Version =1)
then 0
else 0
and this method is working fine.
Thanks for inputs Alex
Regards
CogPlan