Removing Duplicates from a Member Filter
Hi All, I have the following use case whereby in my parameter, I have a member list of C#Local,C#USD,C#JPY,C#|WFText2| whereby WFText2 will be currencies/consolidation members eg. CNY,EUR,SGD,USD,JPY Is there a way to filter the member list to remove duplicates such that if WFText2 is USD, the memberlist will return C#Local,C#USD,C#JPY instead of C#Local,C#USD,C#JPY,C#USD Any help is appreciated, thanks!
Monthly Breakdown and Annual Total in Cube View
I am creating a cube view. Currently, it is showing monthly view and annual total for Workflow year, but future years (2027 and 2028) are not showing annual total only. What should change to show both monthly breakdown and annual total for outer years (2027 and 2028)? T#|WFYear|.Months, T#|WFYear|, XFBR(Year_ParmSelect, SelectYearsRPT, YearsReport = |!ProcessYears!|, CurrScenario = |WFScenario|, wfYear= |WFYear|)
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!!
Open the Workflow Multi-Period Processing page from a dashboard button
Hi all, is there a way to open the "Workflow Multi-Period Processing" page from a dashboard button? we were able to open the pages for specific time (YYYYMM) and the different steps Import, forms, Adj. But what about the Multi-Period processing which is exeucted at the year level (e.g. 2025)? Which is the Workflow name to use in the Change POV and Workflow button POV Action? here is how we set the button Can anyone help? Thanks and regards MassimoHiding 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!!!
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?
