OneStream Community

Tobias · 12-07-2021

Hi,I have an Excel template file to import via the stage. This Excel is using a matrix-style for the values (time in columns) and also one column with a text commentary.As I have to change the view to “Annotation” in order to import a text value, I w...

Tobias · 01-12-2023

Currently, the only workaround we found was to not certify on the workflow itself, but just the import/forms steps. Or to create a special certification step, which does not impact the adjustment layer. The entity workflows should be closed centrally...

Tobias · 11-11-2022

Hi Kris,You can do it with a little trick: First, change the number status to "IsCalculated", then clear calculated data.ExampleDim script As String = "U2#Allo"api.Data.Calculate($"{script} = 0 * {script}")api.Data.ClearCalculatedData(script,True,Tru...

Tobias · 01-05-2022

Hi Tony,Thanks. That is what I did as a workaround, but it keep the looping / performance issue.Regards,Tobias

Tobias · 01-05-2022

Hi,Is there also an option the restrict by cube e.g. just running when saving data in a specific cube? I have a version which checks the data cells and retrieve the cube name from that, but doing so, I have the data volume topic.As the api.pov is not...

Tobias · 01-03-2022

Hi Steven,Please check your datasource settings. The "data structure type" needs to be "Matrix data".Regards,Tobias

OneStream Community

User Statistics

User Activity

Import TextValue from Matrix-Excel

Re: Posting group journal after certify workflow

Re: Best way to this calculation

Re: Can I test a manual input before save and/or calculate

Re: Can I test a manual input before save and/or calculate

Re: Import TextValue from Matrix-Excel