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...
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...
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...
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...
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...
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...