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

DcDev's avatar
DcDev
New Contributor II
1 year ago
Solved

SQL Table Editor Unable to Edit Any Values

I am trying to create a small POC for using a SQL Table Editor tool.  However, I am unable to edit a table row on the SQL Table Editor even after it is in a Dashboard with all of the settings to do s...
dashboards
  • Henning's avatar
    Henning
    1 year ago

    Hi, you are trying to edit an application database table. I strongly believe that this is not possible using SQL Table Editor. Allowing this would circumvent all auditing within the platform.

    You need to create your own custom table, save your FX data in there and then use a business rule to use native Apis to save the FX rates in FXRateType table.

sameburn's avatar
sameburn
Icon for OneStream Employee rankOneStream Employee
1 year ago

I agree with Henning .  You should not be trying to make changes to Application / System tables with a SQL Table Editor (this is why you cannot edit when viewing an application table).  This will not be audited and is not recommended.  This component is to be used with custom tables (e.g. ones created by you) not ones installed as part of the OneStream client installation e.g. FXRateTypes