Hello,
We have a fact table which has a measure called Reserves. We also need one which shows the Change in Reserves from one month to the next. This cannot be done in the fact table as we use cognos currency conversion so any differences due to currency fluctuation would be lost.
We want the Reserve measure to be converted and then the Change in Reserves measure to be calculated from it. Is there a way of calculating the Change in Reserves measure so that it would be done after currency conversion?
Thanks!
We have a fact table which has a measure called Reserves. We also need one which shows the Change in Reserves from one month to the next. This cannot be done in the fact table as we use cognos currency conversion so any differences due to currency fluctuation would be lost.
We want the Reserve measure to be converted and then the Change in Reserves measure to be calculated from it. Is there a way of calculating the Change in Reserves measure so that it would be done after currency conversion?
Thanks!