Hello all.
I am trying to calculate a difference between dates
sample: Time out - time entry
and need to calculate the difference between these hours , however it is necessary to make this calculation on cube in Transformer and the user will analyze the data using the analysis studio and it is essential the time values are in format hh: mm: ff.
Could someone help me please?
Thanks to all. ;)
1. You cannot do this in transformer. You'll need to do it in the datasource
2. In order to see hh:mm:ss in your cube it will need to be in a dimension - it cannot be a measure as measures can only be numeric.