Books to PDF - Multiple Entities
Hi All, I'm having a hard time running a book that creates a pdf by entity in an automated fashion. I've created a book with a loop calling a file which is a book of cube views. Running that book individually works well. When running the book that contains the loop, it works fine when saved as a .pdfbook but the problem I run into is that it times out due to processing time when I try to run it for multiple entities. The book is about 80 pages or cube views. So I created a .zipbook version of the same book with said loop to run it from Data Management in the background. The problem I'm now running into is running the .zipbook version creates 80 pages of blank reports rather than the data I saw in the .pdfbook. If anyone has any suggestions, I'll take them. Thanks!5Views0likes0CommentsReport error for just 1 user?
Hi, we have a user that is receiving the following error message when trying to run a report in the People Planning module. I cannot recreate the issue as an admin, it's working fine for me... What is quite odd is that the reports worked fine for her up until a week ago. Possible solutions we already tested: (1) Reset IIS (2) validate no changes in security (3) log out and back in. Has anyone ever seen this before?31Views0likes2CommentsRounding in cube views - Best practice
Hi all, I am sure this topic has been covered before, but I am looking for what the community is doing in terms of rounding issues (as they apply to CV's). Especially in the case of when financial reports are scaled (to thousands or millions). Are most just jamming differences in via forms as needed. Is there some sort of automation that can account for rounding issues? Any advice would be most welcome and appreciated here. Thanks!24Views0likes1CommentTop 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, BrianSolved1.2KViews1like7CommentsExcel Crashing-OneStream Add-in
We’ve been getting reports from our users that the Excel add-in is crashing. It happens most often when working with files on shared drives, files that contain links to other files, or larger workbooks. The behavior is inconsistent, sometimes everything runs fine, and then the same test will crash another time. When the same files are stored locally on their machine, the issue is seen less often. However, this isn't a feasible work around with our group. The issue feels more widespread since our upgrade to 8.5.1. We’re currently on Excel add-in version 8.5.1.17017. Curious if anyone else in the community is seeing the same pattern with their users? Would be great to compare notes and see if this might be a broader issue. Thanks for any feedback or suggestions!43Views1like1CommentUD8 Member Not Working Anymore
Hello, I previously created a UD8 member to find a max value out of a string group of data for specific accounts. It was working fine last year and when I was looking at it for our tax team, it just shows blank as the value. Can someone help me out and see if I'm missing something. We did upgrade to version 8.4 from 7.4 last year and I don't know if that caused something to not work. Here is the UD8 codes I made. First is for the max value Dim dAmount_1 As Decimal = api.Data.GetDataCell("T#Pov:U8#CFC_IC").CellAmount Dim dAmount_2 As Decimal = api.Data.GetDataCell("T#PovPrior1:U8#CFC_IC").CellAmount Dim dAmount_3 As Decimal = api.Data.GetDataCell("T#PovPrior2:U8#CFC_IC").CellAmount Dim dAmount_4 As Decimal = api.Data.GetDataCell("T#PovPrior3:U8#CFC_IC").CellAmount Dim dAmount_5 As Decimal = api.Data.GetDataCell("T#PovPrior4:U8#CFC_IC").CellAmount Dim dAmount_6 As Decimal = api.Data.GetDataCell("T#PovPrior5:U8#CFC_IC").CellAmount Dim dAmount_7 As Decimal = api.Data.GetDataCell("T#PovPrior6:U8#CFC_IC").CellAmount Dim dAmount_8 As Decimal = api.Data.GetDataCell("T#PovPrior7:U8#CFC_IC").CellAmount Dim dAmount_9 As Decimal = api.Data.GetDataCell("T#PovPrior8:U8#CFC_IC").CellAmount Dim dAmount_10 As Decimal = api.Data.GetDataCell("T#PovPrior9:U8#CFC_IC").CellAmount Dim dAmount_11 As Decimal = api.Data.GetDataCell("T#PovPrior10:U8#CFC_IC").CellAmount Dim dAmount_12 As Decimal = api.Data.GetDataCell("T#PovPrior11:U8#CFC_IC").CellAmount Dim dAmount_13 As Decimal = api.Data.GetDataCell("T#PovPrior12:U8#CFC_IC").CellAmount ' Create an array of the original amounts Dim originalArray As Decimal() = New Decimal() { dAmount_1, dAmount_2, dAmount_3, dAmount_4, dAmount_5, dAmount_6, dAmount_7, dAmount_8, dAmount_9, dAmount_10, dAmount_11, dAmount_12, dAmount_13 } ' Create an array of absolute values Dim absArray As Decimal() = originalArray.Select(Function(x) Math.Abs(x)).ToArray() ' Find the index of the maximum absolute value Dim maxIndex As Integer = Array.IndexOf(absArray, absArray.Max()) ' Return the original value that corresponds to the maximum absolute value Return originalArray(maxIndex) CFC_IC Code Return api.Data.GetDataCell("(I#01000:U8#None + I#01200:U8#None + I#01250:U8#None + I#01900:U8#None + I#05130:U8#None + I#05140:U8#None + I#10100:U8#None + I#10110:U8#None + I#10120:U8#None + I#10130:U8#None + I#10140:U8#None + I#10150:U8#None + I#11100:U8#None + I#14100:U8#None + I#17900:U8#None + I#17910:U8#None + I#19100:U8#None + I#20100:U8#None + I#21100:U8#None + I#26100:U8#None + I#27100:U8#None)") Thanks, Will11Views0likes0CommentsXFGETCELL #REFRESH
Certain users aren't able to refresh sheet containing XFGETCELL. Only shows #REFRESH. In OneStream task activity, it shows that the task has failed with an error message "Summary: Error processing dimension. The item was not found. Dim, OneStream.Shared.Common.DimPk, 0, -1." This should not be related to access since I was able to refresh sheet using another profile with the same roles.35Views1like1CommentIssue with Cubeview with comments Genesis content block
I'm creating a cubeview with comments page and trying to have comments tied to each individual group but comments are only saving with our top level group and not moving with the parameter. I've entered comments on our other groups and get the same result. Below is what I have entered in commentary configuration. Any ideas?20Views0likes0CommentsTask Manager - Duration longer than 30 Days?
Hey everyone, In Task Manager, I was wondering if we could set duration longer than 30 days? As of now, the only max option for a task is 30 days. Can it not be any more or extended? Any feedback or suggestion is welcomed. Thank you.10Views0likes0CommentsNarrative Reporting Issue
Hello! Has someone tried Narrative reporting in 9.1 version? I am currently experiencing issues: 1.- Inserting charts/Advanced Charts / Reports if someone could insert an exaple on how they have done it. 2.- I cannot vie the artifacts and acces them, this message keeps popping up (and the names are fine) Thank you so much for the help!!19Views0likes0Comments