It's been so long long that I've done this I am seeking some guidance.
The business problem I have is to derive a new calculated field to determine Throughput (Records Per Second)
Formula: (((batch_job_execution.end_time - batch_job_execution.start_time) * (24*60))) / (write_count)
The Results from above basically give me a Time Formatted Field and I am seeking an Intgerger field.
I take it I need to do a CAST or other type of formatting function(s) and it most likely needs to be broken down
within the calculated field above.
If someone can provide some guidance as how best to approach this problem, that'll be GREAT!!
If I need to provide some more information, please let me know as well.
(TIMESTAMPDIFF(SQL_TSI_MINUTE, "batch_job_execution.end_time", "batch_job_execution.start_time")*24*60) / (write_count)
Appreciate if you mark as correct
For issues let me know
if need use SQL_TSI_SECOND for seconds instead of minutes as SQL_TSI_MINUTE
Edited by: Srini VEERAVALLI on Jan 8, 2013 5:24 PM
Thank you for the quick response.
I will not be able to try this until tomorrow when I have access to the system.
At first glance I am questioning whether the TIMESTAMPDIFF function will carry over the timestamp
output format to the end result?
The end state result I am seeking will have to be an INTEGER reflecting (Records Per Second - 999999999)
Let me know your thoughts.
I attempted to use the TIMESTAMPDIFF function and I am receiving error ORA-00904 invalid identifier.
I do not find this function in my Oracle SQL book so I'm assuming this might be a function that was created internally
within your enterprise. Please correct me if I am wrong. This may have to be the path I take. (Create a FUNCTION to perform TIMESTAMPDIFF processing)
Again, this is just some of my thoughts based on my research and I could be far off.
Please advise or confirm my suspicions.
You suppose to use given expression in OBIEE Answers->Criteria-> Column expression.
If you are not using BI and trying to execute in sqlplus then make sure you use TO_DATE function if reqired
Edited by: Srini VEERAVALLI on Jan 9, 2013 1:07 PM