The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

SamuelGorgonio's avatar
SamuelGorgonio
New Contributor II
3 years ago
Solved

Reporting on Time from Application tables

I noticed that the application tables have an odd time format in column called timeid   is there another table that houses the times in 2023M3 format or is there a way to convert this colu...
dashboards
  • ckattookaran's avatar
    ckattookaran
    3 years ago

    You must use a data table edit method to get the correct time. Use SQL to get the datatable, then do something like

    datatable.Columns.Add("TimeName")
datatable.Columns("TimeName").ReadOnly = False
datatable.Columns("TimeName").MaxLength = -1

For each dr as DataRow in datatable.rows
dr.BeginEdit
dr("TimeName") = TimeDimHelper.GetNameFromId(dr("TimeId")
dr.EndEdit
Next

     that should get you what you are looking for.

ckattookaran's avatar
ckattookaran
Valued Contributor
3 years ago

You must use a data table edit method to get the correct time. Use SQL to get the datatable, then do something like

datatable.Columns.Add("TimeName")
datatable.Columns("TimeName").ReadOnly = False
datatable.Columns("TimeName").MaxLength = -1

For each dr as DataRow in datatable.rows
dr.BeginEdit
dr("TimeName") = TimeDimHelper.GetNameFromId(dr("TimeId")
dr.EndEdit
Next

 that should get you what you are looking for.