Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Display 2 different measures using a time dimension
It works. In powerplay I used it to calculate the price elasticity. But is it possible to include this calculation inside a cube? This is the calculation: (new quantity - old quantity)/old quantity / (new price - old price)/old price. The price and the quantity...- voetpad
- Post #3
- Forum: Cognos solutions
-
Display 2 different measures using a time dimension
when using a time dimension (like QTD change) I see only one measure. Example : the change of quantity. But I want to see 2 measures using one time dimension. Example: I want to see the QTD change of quantity and QTD change of costs at the same time. How can I do that?- voetpad
- Thread
- Replies: 2
- Forum: Cognos solutions
-
%change of price and %change of quantity
Is it in Transformer possible to create a measure which uses this function: ((new quantity - old quantity)/old quantity *100%) / ((New price - old price)/old price *100%) New price and new quantity are known in the current period and old price and old quantity are known in the previous...- voetpad
- Thread
- Replies: 1
- Forum: Cognos solutions
