URGENT:changing calculation dlist items changes the values in multiple versions.

[cogplan]

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

[Rutulian]

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

[cogplan]

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