Recent Discussions
Carriage Return in Annotation data on Cube View
Hi All Does anyone know how to add a carriage return in Annotation text (if it's possible)? We have a Cube View with an annotation member that displays data. Currently the annotation text can take up most of the screen on some rows andit would be really useful to be able to enter a carriage return. I have tried Environment.NewLine, vbCrLf, \r\n, <br>
Version 8 formatting issue with Books/Cube Views produced in Excel?
Just checking to see if anyone else has been experiencing the following issue with Version 8. We are currently testing the upgrade from 7.x to version 8 and have run into a huge formatting issue with our books that are produced to Excel and sent out to management via postal service. The source cube views for a batch use the same column template. We have Excel column width formatting set up for each of the columns (but consistently on each column). When the cube views are run and exported to Excel, the column width is not being recognized in most of the columns. I have tried direct formatting, I have tried with a literal parameter and getting the same results no matter what. I don't see where I can attach the workbook itself but am attaching a screen capture sample . In this case text wrap is set to False and column widths are set to 100. Note the results. Oddly, in like the first book, some of the sheets ARE recognizing the column width. I'm just wondering if anyone has experienced this and has found a workaround or determined why this is happening.
Dashboard Report - calculating % on Group Sum values
Hi all, I'm trying to figure out how to insert a field within my report's Group Footer that would perform a calculation on other Group Sum fields. In my Group Footer, I'm summing up Contract Amount and Contract Margin fields from the Detail band. I would like to calculate the Margin % based on these sums and have no idea how this is done. Any advice would be greatly appreciated! Cosimo
Dynamic Scenario in Cube View columns based on selection
I know I can have a different scenario where I can combine actuals and forecast each month with data management job and I can use AllPriorYInearInclusive for Actual columns and AllNextInYearInclusive for Forecast to do this when i want just months. But I want to also have quarters summing 3 months potentially actuals and forecast together if date selected is in middle of quarter. And YTD columns summing actuals and forecast. Below is example of what i want to achieve. Is there CubeView Extender i can build to make this happen. For Quarter and YTD columns i can just use getdatacell(CVR(Col1)+CVR(Col3)+CVR(Col5)... etc. but i would like to somehow switch actuals to forecast for all future months of WFTime, TimePOV or Parameter selection.
Inserting a chart into a Word xfdoc error: Entries cannot be opened multiple times in Update mode.
hi, I am trying to insert a chart into a Word xfdoc from the Word Insert menu and completing some data points, which I can do. However, when I try to run/process the document out of OneStream it gives me an error message:Entries cannot be opened multiple times in Update mode. Is a native Word chart not allowed? The data is not linked to OneStream (although that would be ideal). Is there any Event handler to work around this? I'm in 8.0, not sure if this is available in Narrative Reporting in 8.2+? thanks, Greg
Spreadsheet Related Error Message
Hi Everyone, When trying to access the Spreadsheet section in our application, we were met with this error message that we did not recognize. We were unable to open the Spreadsheet section because of this unless we opened the application in a new window. Has anyone seen this error message before or know what the root cause for it was?Chart drops to zero instead of showing no data
Hi, A dynamically calculated KPI returns "Nothing" for future months in the Actuals and therefore I expected the line in the advanced chart to stop at the current month. However, it's not doing that, instead it is dropping to zero, creating a rather undesirable effect. I can't imagine that this is the default behavior of OneStream. Am I doing something wrong? Did I overlook a setting or is there another way to prevent the drop to zero for non-existing data?
Cube View supression with Dynamic Calc member
Hello, I have a dynamic calc UD8 member, where I put small value grater then 0 (0.00001) to be able to display certain rown even when the initial value is 0. This works with FormulaPass, but does not seem to work with dynamic calc. Does anyone know if there could be a problem that dynamic calc values get supressed when all CV supressions are set to "True"? Thank you!
