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.
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. Cheers
Refreshing 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?Automate 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 MarcusGenesis 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.
