Recent Discussions
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!UD8 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, WillIssue 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?
Read only access to Ancillary Tables
8.5 environment, on prem. My understanding is that if I want read only access for users to Ancillary Tables I need to use the config utility and set Access Group for Ancillary Tables to a user group that would be different than Maintenance Group or Table Creation Group. I did this and my users in the group assigned to Access Group are able to edit ancillary tables. Then I found this documentation that implies that Access Group gives edit rights to ancillary tables. Does anyone have a definitive answer on this or know how to setup read only access to ancillary tables?
Narrative 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!!
Task Manager - Frequency not working
I have my task manager set up by Weeks: Therefore, I've been using Frequency ranges as 1-52 or 1,2,3 etc. as from the Task Manager guide. Let's say I want to make only 1 task group start on W1-W3. I input that into the task group and individual tasks but still it doesn't show up. However, if I don't put any frequency range, it shows up for all weeks I publish. I just want it to show up for 1 week. BCA #1 doesn't show up at all in any charts but BCA #2 shows up in all weeks published. I've also set up my Close Dates but it still doesn't work: Any pointers or tips? Thank youReport Books - Dashboard Chart
Hello, I have an automated report book and would like to expand the functionality to include charts (in addition to the existing cubeviews). I was able to add the chart, but I'm struggling with trying to control the formatting. I would like to modify the header and have the chart fill the page (too much white space). See below. Thanks! Is there a way to format the chart output, in particular I would like to enlarge the chart image and have it stretched across the page?
