Is there a way to hide/show columns based on combo box value selection?
Here is the scenario: I have a Combo Box that holds value "Summary View" and "Detailed View". Based on the combo box selection value in the dashboard, the CV columns needs to update dynamically in CV. Summary View should have all columns except "Variance" Column. And when Detailed View is selected, This should have all columns including 'Variance' Column. The tricky part is that these are shared columns from another CV. And we already have a formula for 'Variance' column in XFBR. In Short: When Summary view is selected, Variance column should hide and when Detailed View is selected, all columns should show up! Any idea or a suggestions are greatly appreciated! Thanks.
Hiding Rows within a CV and more
Hi everyone!! I am trying to share a total amount that is calculated form one cubeview to another but it will not let me if I do not bring the source rows for the calculation (From the 1st CV to the 2nd) but I only want the totals. (If anyone knows how to do this great!!) My other alternative is to bring those rows and hide them. Does anyone know how to do this? Thanks!!!
display a Textvalue in a Cube View loaded in an import
I have configured a datasource where TextValue is taken from a column of a flat file to be loaded, the file loads well from the Import and I see the text for each loaded row, but I have not been able to display it in a CubeView, is this possible?
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!How to use the 'Remove' member expansion in a button 'Select Member' type
Hi, I have a member that I want to reference and pull in the tree underneath it but eliminate a few of the base memeber as options for my users to click on them. I'm trying to use the 'Remove' member expansion but its not working. Is there something I'm missing?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, Will
Substitution Variables with Desc and User Culture
Hi, It doesn't look like the cube view ":name" override using substitution variables respects the user's culture setting. The substitution variable goes instead to the default description. My example, I have account descriptions in German and English. My user ID is culture English. My cube view render the proper description when I don't use the override ":name()". I use the override, :name(|MFaccountDesc| growth %), and get this, I would expect the substitution variables to respect the user's culture.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!!
Cube View Time Out issue
Hello Team, I'm experiencing performance challenges with a CubeView that contains: 4 row dimensions (all using .base members) Multiple time period columns Dynamic calculations that are causing significant retrieval delays Current Challenge: The CubeView needs to be executed and its data exported externally, but the dynamic calculations are making the retrieval process extremely time-consuming. Attempted Solution: I've already tried converting the dynamic calculations to stored values using finance rules, but this approach has proven ineffective - it's still taking excessive time and not producing the desired results. Request: Could you suggest any alternative approaches or optimization strategies to improve the performance of this data retrieval and export process? Thank you for your assistance.
Cube View sum of columns sums only values from column with first child
Hi everyone, I'm having an issue with a cube view. I have a column whose parameter is E#GroupEntity.Base. When launched, it shows one base entity per column, with its respective data. I need to place a new column at the end of the cube view that sums the values of all the base entities. I tried to use the CVC function to sum columns, but it only sums the data of first base entity, ignoring all the other base entities. Is there a way to achieve what I need, and if yes, could someone please help me? Thank you!
