OneStream Community

AndreaF

Hi all, does this 2021 OS community post by OneStream still hold true? I would like the cells from the FTE row to be formatted in a certain way (for example set the background to red) when the FTE check cell amount is not zero. Is there a way other t...

AndreaF

Hi,I have a data management step which runs an extensibility rule. In the rule I am using the “Throw New XFUserMsgException” command to return error messages.For example:Throw New XFUserMsgException(si,"","","Error: Copy cannot be completed. Source S...

AndreaF

Hi all,I have a data management step which is of "execute business rule" type, and make use of parameters so that when I run it, it prompts me to select the parameters. The parameters are "member dialog" parameters.Now, since I want users to be able ...

AndreaF · 04-20-2023

Hi all, I have a dashboard with an SQL table editor component. Through the component in the dashboard, I can save text to the table, including special characters. For example, there is no problem in saving a string containing α (alpha). Now I am tryi...

AndreaF · 03-27-2023

Hi, I have an application DB table with a date column and I am using the LoadCustomTableUsingDelimitedFile function to load a CSV file to the table. The xfDateTime# token is assigned to the column in the LoadCustomTableUsingDelimitedFile function. Th...

Re: Unable to delete Entity member

Hi, the easiest way is to create a Data management step (Application tab/Data management) of "Clear data" type. One of the fields let you filter on Entity so you only clear the data of that entity

AndreaF

Hi, yes the "insert into" command works in OneStream.The command I've used to create the table is: "Select * Into NewTableName From OldTableName Where 1 = 2"

AndreaF

To give an update, I have been able to pass the parameters from the combo boxes to the data mng step via the standard button.One thing to consider and that I was initially getting wrong is that the parameters to pass must be the member dialog paramet...

AndreaF

Thank you for providing the code sample, very useful! I've used it to update some LookupRowFieldValue functions from using the criteriaExpression to the dbWhere object and I can confirm the code provided works well!

AndreaF · 04-20-2023

Hi, I have uploaded the test file to WeTransfer. Let me know if I should share it via a different method. Thank youSpecialCharTestFile.csv

OneStream Community

User Statistics

User Activity

Conditional formatting based on the value of other rows and columns

Return message on successfully completed extensibility rule

Run a parametrised data management sequence from a dashboard

Loading CSV containing special characters to an application table

Dates format issue with LoadCustomTableUsingDelimitedFile function

Re: Unable to delete Entity member

Re: Create Table As Select

Re: Run a parametrised data management sequence from a dashboard

Re: New Syntax for LookupRowFieldValue()

Re: Loading CSV containing special characters to an application table