OneStream Community

Thomas_Bennett · 06-11-2024

Hi all, I might be having a dumb moment here but I cant work out how to overcome a formatting issue. Im trying to restyle some reporting, all the formatting is on style parameters and in this case my highlighted columns are being overriden by the row...

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 · 06-12-2024

Hi Db, sorry yes i'm aware of the order of evaluation. The problem is that the formatting is row specific, group rows are highlighted but in the case of this report the column background highlighting should take precedence over that highlighting. In ...

Thomas_Bennett · 06-12-2024

Hi Henning, yep sorry thats what im trying but I have many rows to override as the rows are dynamic and parametrised to be one of 11 possible row sets. I dont fancy creating another 11 row sets and maintaining both sets either.

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

OneStream Community

User Statistics

User Activity

Global Row override for formatting CVs?

Add a non CV Excel workbook to a book.

Isolate error logging down to a business rule.

Re: Global Row override for formatting CVs?

Re: Global Row override for formatting CVs?

Re: Use XFMemberProperty to get year from time parameter

Re: Running Consolidation from WF

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