OneStream Community

Koemets · 11-12-2022

Got a task to copy certain file from FileShare to Documents\Public because users security settings. Wanted to go with the standard System.IO.File.Copy(strSourceFile,strTargetFile) where source and targets are sting. Can get full source file path usin...

Koemets · 10-05-2022

Does anyone know if OneStream is capable of exporting into AWS S3 bucket?Thanks.

Koemets

We did this implementation for many clients. Once you got all the setups and creds on workday side, you connect to their DB and recreate the workday tables in the OS as custom tables (select * into...). Essentially you use connector BR that feeds the...

Koemets · 11-21-2022

if I understand correctly, you need that in the cube view, right?In this case I'll build a quick XFBR function with the following key functionality. Please note, I oversimplify few thing there for easier read/understanding. ' Say, your current period...

Koemets · 11-14-2022

I think what are you looking for is this:"A#MCF0015050_PLG = " & Acc1.ToString("#,###.00")Here is the decent read on formatting:https://www.thevbprogrammer.com/VB2010_04/04-01-FormattingNumbersDateStrings.htmIt's written infinitely better than Micros...

Koemets · 11-14-2022

Thank you. With minor corrections this worked. For the record (and future reference to whoever will search for it), FileShare root is located at sourceXFFileEx = BRApi.FileSystem.GetFile(si, FileSystemLocation.FileShare, sourceDir & "/" & sourceFile,...

Koemets · 11-14-2022

I don't have any code samples handy, but this will an Extensibility BR, triggered by "Execute Business Rule" Data management sequence, that you want to schedule in Task Scheduler.The BR logic is the follows:1) Declare your batch folder2) Loop thru al...

OneStream Community

User Statistics

User Activity

Documents\Public location

Exporting to Amazon S3 bucket

Re: Workday Import to OneStream

Re: How to get timeDim ie months in reverse starting with curr month followed by prev months? in col

Re: Format output of confirmation rule

Re: Documents\Public location

Re: File Explorer Manager (FEM) - Delete multiple folders?