Any Cognos experts?? If so, I am working with a client. We have extracted certain time intervals in seonds and are using these intervals in our cubes. The problem is that when the client is attempting to validate the data they are using a source system that displays all time interval calculations in MM:SS. Is there a way in Cognos 8 Report Studio that I can convert these seconds to MM:SS so that I can then use these converted times in calculations to verify the number being seen the source system.
EXAMPLE. The time interval they are interested in is a total delivery time compared to expected delivery time. The next thing is that these delivery times need to be added up across many stores, regions, brand, Company so I need to know that the time intervals can be rollup in the HH:MM format. Any guidance would be greatly appreciated.
Start Free Trial
