When subtracting 2 dates, the result is a number; however, it creates an attribute. Here is the formula:
TIMESTAMPDIFF(SQL_TSI_DAY, {date 1},{date2})
How can I change it to a fact?
I'm using NetSuite Analytics Warehouse.
You can add SUM() before your calculation:
SUM(TIMESTAMPDIFF(SQL_TSI_DAY, {date 1},{date2}))
SUM didn't work, but MIN and MAX do. I assume because the result of the formula is just one result.
Hi @User_F2RD3,
you have to add an aggregate function to change the column from attribute to metric
When I add it to a column, I don't get the Aggregate function.
Also, I don't want to aggregate the result.
SUM didn't work. However, MAX and MIN, did. I assume that since the formula produces one result, MIN and MAX produce the same result and change it to a Fact.
Mathematically what you are saying makes sense - but check for the compatiblity of the two functions TIMESTAMPDIFF and SQL_TSI_DAY. I think the first one expects a full timestamp, whereas the second only seems to provide the DAY without the rest of the hours, minutes, seconds?
Hi, I'm new to OTBI & FDI and need your help. Is it possible to do a report to identify missing default expense account in FDI or OTBI? Thanks for your help.
Hi Team We are using SCM- Maintenance subject areas for reporting . We enabled the Asset related DFFs (CSE_ASSETS_B) under Data Configuration successfully but the Asset DFFs are not reflecting under Descriptive Flexfield Folder . We do not see any Asset folder even under the Descriptive Flexfield folder . Please advise if…
We made some changes in the Fusion UI, and those changes were reflected correctly in OTBI but not in FDI. To refresh the data in FDI, the Oracle support team advised me to reload the relevant functional area (Absence Management). I navigated to Application Administration → Human Capital Management, selected Absence…
Data are synchronized with Oracle HCM and I can see PN 2470, which was terminated in the past. If I add any assignment information I find no records, why?
In an analysis/report, when the Bottom Up Manager details are selected from the hierarchy, the Top Position Person record drops out. This is due to the fact that this top level position does not have a record in the Fusion table : PER_MANAGER_HRCHY_CF which is the source to load OAX$OAC.DW_MANAGER_CF_DH . The requirement…
