Announcement
ABCFeatured Content
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.m_b_b_153 hours agoNew Contributor II8Views0likes0CommentsReport 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)anilpersaud4 hours agoNew Contributor II1.5KViews2likes11CommentsLoading Annotations Only via a Workflow
Is it possible to create a data source to load annotations only from a flat file. I am tagging the annotations in the flat file with the View dimension. It seems like the data source always wants an "Amount". Is this case I have no amount so when I Ioad the data file, I get an error that "No Valid Data Keys in File". It seems that this should be possible. Maybe I should do this via Excel loads.SolvedGreg_S9 hours agoNew Contributor II3.7KViews1like9CommentsDynamic Dashboards – Passing Parameters with Repeat Arguments.
5 MIN READ Magic is just science that we don’t understand yetsameburn9 hours agoContributor III2.3KViews10likes8CommentsIn-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. CheersChrisBriscoe10 hours agoNew Contributor II7Views0likes0CommentsConsolidation 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?NidhiMangtani10 hours agoContributor III9Views0likes1CommentWhat is Api.Cons.IsCurrency?
I came across this piece of code today: If (((Not api.Entity.HasChildren()) And (api.Cons.IsLocalCurrencyForEntity())) And api.Cons.IsCurrency()) I'm guessing the last statement is to be sure that your Cons dimension POV is not on a "non-currency" member such as Elimination. Have I guessed correctly? And if so, then wouldn't this already be accounted for in the api.Cons.IsLocalCurrencyForEntity condition? If I haven't guessed correctly, then my question is what does this condition check for?SolvedBobNelson11 hours agoNew Contributor III24Views1like1CommentCube 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?ZAH2 days agoNew Contributor3.5KViews0likes7CommentsGenesis 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.mkerslake2 days agoContributor145Views1like2CommentsRegister 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 Expressjcooley2 days agoContributor III29Views0likes0Comments
Getting Started
Learn more about the OneStream Community with the links below.