Recent Discussions
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)anilpersaud3 hours agoNew Contributor II1.5KViews2likes11CommentsIn-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. CheersChrisBriscoe9 hours agoNew Contributor II7Views0likes0CommentsFilter Cost Centers without Data in Books
I created a Reporting book with a loop on CC's. Is there a way I can filter the Tabs without data in the Report? I am planning to implement and test the options listed below but I also wanted to check with the OS community if they ran into this issue and the solution they implemented to fix this Issue. 1.Assign a Text to the CC's with Data and use IF condition to only export data for the Cost Centers with the Text 2.Create Alternate Hierarchy for the CC's that have Data (Note: This list won't change)SolvedTauseefAliKhanB2 days agoNew Contributor III297Views0likes3CommentsDynamically replace header text with Description for Parents or Name and Description for base
Using an expansion such as .Tree is there a way I can have the header text display the member description for parents and the name & description for base members?Samwise4 days agoNew Contributor II6Views0likes0CommentsRefreshing an emailed spreadsheet
We just upgraded from 8.4 to 9.0, and almost certain before we could email a spreadsheet with XF functions and immediately refresh the spreadsheet with button in the ribbon when already logged in. Now the Refresh Sheet button is grayed out, and now you have to "save as" the spreadsheet then refresh because the spreadsheet is in "read only" mode. I'm trying to decide if it changed with the upgrade, or if one of the Preferences settings affect this, or if we are just not remembering correctly. Any ideas or are we just wrong?johnal679 days agoContributor25Views0likes1CommentAutomate Excel workbook refresh
We have an Excel workbook with a *lot* of embedded cube views and table views. Some sheets have two Cube Views with Excel formulas showing significant differences. Others have stacked Cube Views showing Import, IFRS Adjustments and Total. We cannot use Books because of this. It takes about an hour to refresh the workbook so we want to automate the refresh somehow. Anyone have any suggestions about how to automate the refresh? Thanks MarcusMarcusH9 days agoValued Contributor12Views0likes0CommentsGenesis Parameters (Filters) Issue
I am having an issue with cube view parameters within the Genesis content block "Cube View Comments"? I receive one of two errors - (1) Index was out of range (parameter 'index') or (2) Parameter is not supported. However, if I put the exact same cube view in the "Cube View Advanced" content block, the parameters work exactly as expected. Is this a bug or is there something I'm doing wrong? Any help would be greatly appreciated.aricgresko10 days agoContributor III25Views0likes1Comment