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
V#Trailing12MonthTotal
Hi , I am trying to use the V#Trailing2-12MonthTotals in my reports. Could any expert users please advise if the TrailingTotal in View Dimension works only for P&L numbers or they work for Balance Sheet and Retained Earnings totals also. Any reponse will be much appreciated. Thanks Sam
Top Ten and All Other
Hi. I have a cube view / customer sales report where I can get my top ten customer sales, and I have a row that has the total sales. How can I make a row to show 'All Others' so I can foot the lines to the total sales? I've tried a CVR calc but it pulls in the top customer only. Thanks, BrianRow Formula is overring Ud8 Calc
Hi Team, In our report we are having multiple formula's in row and columns (Can't apply the row or column overrides). So, have created a UD8 Dynamic calc. though after applying the UD8 member in column, row formula is overring the UD8. Can please help us to resolve the issue.SQL Table Editor Dynamic Drop down
Hi Community, I have a question. I'm working with a SQL table editor and need to implement dependent dropdowns. Specifically, based on the value selected in the first column, I want the second column to display a corresponding set of dropdown options. Is this possible to achieve? If so, could you suggest any approach that can help me implement this functionality? Thank You!
