Skip to Content
author's profile photo
Former Member

Replacement Path

Hi All,

In my dso i got two characteristics A_Time and T_Time, data type of both characteristics is TIMS.

In query i want to calculate difference between these two time, so i tried using replacement path but i am not able to achieve correct result.

When using replacement path, there are options in Dimension ids such as price,quantity,number,date..in this there is no time option.

If we cant use repalcement path to calculate time difference...why

Suggest any valuable ideas to achieve this result in query level

Regards

Prakash

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • author's profile photo
    Former Member
    Posted on Aug 17, 2007 at 11:17 AM

    Prakash,

    Use a formula variable with replacement path and cal result in days using the vailable function.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi venkat,

      I used formula variable with repalcement path but while specifying 'dimension settings' there is no 'time' option like date..I want result also in time

      Any ideas to calculate time difference if it is defined as characteristics..

      Can anyone give some solution..

      Regards

      Prakash