OneStream Community

HeatherB_eCap · 11-01-2022

When building a Data Source bound to a Connector business rule, if a need arises to use a Complex Expression, and that expression requires referencing several unbound fields, what is the proper statement to use to retrieve those field values in the e...

HeatherB_eCap · 10-21-2022

Hey everyone. We are implementing a use case for a client that requires import of transactional data found within a csv file. The data is comma delimited, and enclosed in quotes. For example, if the data source contained only three fields, this is wh...

HeatherB_eCap · 07-05-2024

Hi @MardayT, in my connector business rules, I use Replace statements to remove commas from all fields that might contain it. Then, you can use the args.line.split command in complex expressions to reference field values. Note that connector data sou...

HeatherB_eCap · 11-02-2022

Thank you @JackLacava, you've confirmed my suspicions. In my case, it sounds like I need to either move the work done in the complex expressions to the Connector rule itself, or "cleanse" the data in the Connector rule to remove the commas to avoid t...

HeatherB_eCap · 10-24-2022

Hi Krishna, I ended up writing a RegEx statement within the workflow automation rule I wrote to read each line in the file, find and replace the offending string, and write the dataset to a new file. It does not seem possible to handle this using a c...

HeatherB_eCap · 06-06-2022

Hi Sathish, yes, that would be my understanding. I would first delete from the Access Group Members table, as I'm not sure the DB is configured with a cascading delete. Then I would delete from the Access Groups table. The condition I would base dele...

HeatherB_eCap · 06-06-2022

Hi Sathish, I'm not aware of a feature available through the UI. If your company allows it, it would be possible to write a database script that performs a deletion from the Access Groups table, of groups not currently assigned to any account reconci...

OneStream Community

User Statistics

User Activity

Question about Complex Expressions built on Connector Data Sources

Two Double Quotes in Delimited Data Sources

Re: Question about Complex Expressions built on Connector Data Sources

Re: Question about Complex Expressions built on Connector Data Sources

Re: Two Double Quotes in Delimited Data Sources

Re: Mass Deletion option in RCM Groups

Re: Mass Deletion option in RCM Groups