OneStream Community

JamesKirkby · 02-03-2022

Hello: I've integrated a set of transaction details from a GL into a bi-blend cube within OneStream. I'd like to aggregate along the UD1 dimension so we can see the data at the parent level for each transaction. The dimension consists of a set of par...

JamesKirkby · 11-30-2021

Hello: Has anyone had any success with grouping columns in a cube view in a report linked to excel, or grouping them as they export? Of course in the data explorer version you can use the tree function and toggle the row expansion mode to get the int...

JamesKirkby · 11-11-2021

I have a report book I've built that loops thru a dimension and creates a tab for every member in a ud hierarchy. I've set book to label the tabs using the CVUD2 and CVUD2Description. It works quite well except there are some descriptions that have h...

JamesKirkby · 07-11-2023

Could you use conditional formatting to make the Excel text blue in the first and last column, while white in the middle with Excel wrap text false? I don't think there is a way to do this using header format default settings. the border settings mig...

JamesKirkby · 07-11-2023

You know I haven't had a need to do that yet - but would be interested to hear other's ideas.

JamesKirkby · 06-14-2023

We've used the the api.Data.SetDataAttachmentText function to set the data attachments in the past. This function uses a member script to set the value in the dataattachments table which is where the annotation type data is stored. Specifically we've...

JamesKirkby · 10-14-2022

I think this only works when exporting. When you use a linked cube view connection I don't think it works.

JamesKirkby · 07-27-2022

Hi There:I've created a YTD Trial Balance pull using this code on GITHUB. This should point you in the right direction. I would suggest making the connection via ODBC if possible; we had an API integration prior to implementing this and even with a r...

OneStream Community

User Statistics

User Activity

Aggregation BI-Blend non-attribute dimensions without base members

Group Columns/Excel Outline in Columns on Cube Views

Hyphen in Excel Report Book Items

Re: Cube View - Excel Column Headings

Re: Writing Annotation data in a Finance Rule (like SetDataBuffer)

Re: Writing Annotation data in a Finance Rule (like SetDataBuffer)

Re: Group Columns/Excel Outline in Columns on Cube Views

Re: OneStream - NetSuite