OneStream Community

RyanDiehl · 04-13-2023

I'm trying to lookup the users in a workflow execution group so I can e-mail them when the harvest batch process runs successfully. Below is the code I'm using to try and lookup the users within a workflow execution group. The problem is I don't know...

RyanDiehl · 06-22-2022

I am well aware of the "Suppress Repeating Member Names" True/False box on a Quick View. I am looking for the exact same toggle on a Cube View. I could have sworn this was a very easy thing but I don't see it. In the below Cube View example below, th...

RyanDiehl · 04-29-2022

Has anyone been able to build a waterfall chart in BIViewer? I feel like this is something that I should be able to be done, but I can't find anything on it. Anyone know if this can be done? I know there is an advanced chart for waterfalls. Thanks

RyanDiehl · 01-17-2022

I am building a cube view with two rows and 12 columns. Assume POV=2021M12: The first row is A#Sales and in the second row I want the variance of the sales from row one this month minus the sales last month. (Think POV minus POVPrior1) In the Column ...

RyanDiehl · 04-14-2023

Thanks Eric! You are Awesome!I had found the same 1250 as the number it should be and that's what led me down that path. For those looking for the different "WorkflowGroupType" codes, below is where they are. The change from "Nothing" to "String.Empt...

RyanDiehl · 11-04-2022

Hey Eric, when you say that "reports are a better place to handle this" what exactly are you proposing? Is there a way to do a series of getdatacells on the reports themselves to make this work? Appreciate the help!

RyanDiehl · 01-18-2022

Thanks for the suggestion, I could probably put this in a UD8 and make it dynamic for all accounts but for the purposes of this thread, below is what I ended up using as the solution as a dynamic reporting account.----------'Variance to Prior Month:'...

RyanDiehl · 01-18-2022

Sai, thanks for the idea. The problem with the approach you listed is that the variance GetDataCell would apply to all of the rows. I need to have the first row display the Sales number for the period and the second row show the month over month vari...

OneStream Community

User Statistics

User Activity

Help with GetUsersInWorkflowGroup function

Turn off suppression of repeated member names in a Cube View

Waterfall Chart in BI Viewer?

Month Over Month Variance in the Row

Re: Help with GetUsersInWorkflowGroup function

Re: Adjustments for Scaled Financials - Best Practice

Re: Month Over Month Variance in the Row

Re: Month Over Month Variance in the Row