OneStream Community

Thomas_Bennett · 10-16-2023

Hi all. So I have a book set up that creates an excel workbook based on a loop of entities. It works absolutely fine, however, the book is 300 worksheets or so. Therefore its pretty handy to have an Index page. Is there anyway to splice a worksheet n...

Thomas_Bennett · 05-23-2023

Hi All,Ive got a problem with transformation/load cube workflow steps in our build, It has been in our applications for over six months (an older dev application has the same problem). This error doesn't seem to cause a problem in our data although m...

Thomas_Bennett · 10-19-2023

Probably overkill but you could write a brstring rule, send your parameter to that and substring it. I mocked it up here: CV Column:rule: Output:

Thomas_Bennett · 10-19-2023

I believe you need a Import Validate,Process workflow Then set up a calculation definition:It comes with a handy Load+Process button to run both steps at the same time.

Thomas_Bennett · 10-19-2023

Shame about that, Not the end of the world though. I can add the finishing touches and the page with VBA. Cheers, Tom

Thomas_Bennett · 10-18-2023

Thanks Jack! Shame the Freeze pane option isnt already in OS. You could assume book functionality is a lower priority than system reports like CVs and Dashboards but they are so handy as accountants loooove Excel! I guess for now its trusty VBA! As f...

Thomas_Bennett · 10-18-2023

here is an example of one of my working books: Parameter: Loop: Change param: If statement, It was shorter and more intuitive using Loop1displayvariable :and the book object, note I dont have any required input parameters. This might be your issue as...

OneStream Community

User Statistics

User Activity

Add a non CV Excel workbook to a book.

Isolate error logging down to a business rule.

Re: Use XFMemberProperty to get year from time parameter

Re: Running Consolidation from WF

Re: Add a non CV Excel workbook to a book.

Re: Add a non CV Excel workbook to a book.

Re: Using Change parameter passing value for Delimited list in Report books is not working.