Announcement
ABC
Recent Activity
Create new Documents in Narrative Reporting
Hi, I am attempting to upload files for our Narrative reporting and I am failing miserably here... I would like a CubeView report in either Microsoft Word or PowerPoint. I have following the instructions online within Word to Insert >> Field >> DocVariable and input the Syntax as instructed: I add it to my Narrative files and keep getting errors about parameters. I went as far to change the report so there are no parameters and all the dimensions are defined within the CubeView. Any ideas what I could be missing? Or does anyone have an example of what they used for their syntax and uploads? I can't seem to find this initial step.
Report Books - If Statement
Hi There, I am trying to create a book with a loop on our UD4 (project). I have it working but I want to add an IF statement to filter out tabs that contain no data. Referencing a previous post, I tried adding an IF statement to filter out an account (A#TotSGA in our case). This is the statement I am using, but it doesn't seem to work. XFCell(Cb#00_CorpRpt:E#7420:C#Local:S#Budget_V2:T#2024:V#Periodic:A#OtherSGA:F#EndBal:O#Top:I#Top:U1#Top:U2#Top:U3#Top:U4#|Loop1Variable|:U5#Top:U6#Top:U7#None:U8#None) <> 0.00 I have attached screenshots and referenced the previous topic below. Any help is appreciated! Re: Suppress NoData Tabs in Book Using Loop - OneStream Community (onestreamsoftware.com)
In-Sheet Actions
In-Sheet Actions In-sheet actions enable you to quickly interact with your data directly in Excel and Spreadsheet. Creating a button streamlines the following actions: Refreshing a worksheet or workbook Submitting a worksheet or workbook Running a data management sequence When you insert an In-Sheet Action button (e.g., Submit, Refresh, or Run DM Sequence) on a Quick View sheet in Excel: It defaults to size 12 font Attempts to increase the font size (e.g., via Excel formatting) often do not persist after refresh or submission This can make the button look too small or misaligned in more styled dashboards. If you managed to format this In-Sheet Action very well, I would appreciate your input. CheersConsolidation in a Dynamic Cube
Hi Experts, I have a dynamic read only cube, source of this cube is a relational table having details like salary band, department, position, benefits %, tax %, etc. I am simulating some calculations in workspace assembly and setting records in the dynamic read only cube. I see expected data at base entity levels. How can I see correct data at the top entity level? Entity structure: I see same data at multiple levels. Asia and AllRegions data should not be same. Also drill down results are same at multiple levels which is weird. So if we are setting data at base entities in a dynamic cube, how does consolidation work here? JackLacava , would you please clarify this?
Cube View Comments
Hello All, I have a cube view in which i am using on the Row Level a GetDataCell Function, example GetDataCell(Account1+ Account2): Name (Trade). on the column level i have a Comment using the V#Annotation:Name(Comments). however, on the GetDataCell the Comment is highlighted in Green. is there a way to be able to allow the user to write a comment on row that contains a GetDataCell function?
Genesis Replay Now Available!
1 MIN READ On this episode of Tech Talks, Jacqui Slone and Doug Kinchley join Matt Kerslake to discuss OneStream Genesis. Join them and learn how Genesis is unlocking new possibilities for finance teams to click-to-configure new financial and operational models, launch new planning processes, and enhance reporting and analysis with ease. This replay will be available here until July 18th and always available on Navigator as part of your Passport subscription.
Register now for the July edition of Tech Talks!
1 MIN READ All aboard the CPM Express! On this edition of Tech Talks, join Marley Watson, Tom Linton and Matt Kerslake as they explore this streamlined and comprehensive framework that encompasses essential CPM functions (Financial close, Consolidation, budgeting and Forecasting) that facilitates quick deployment suited for organizations with straightforward, functional needs! Be sure to register now before all seats are taken! Tech Talks: All Aboard the CPM Express
