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.Solved33Views0likes2CommentsHiding 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!!!29Views0likes2CommentsBooks 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!11Views0likes0CommentsHow 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?25Views0likes1CommentTask 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.13Views0likes0CommentsNarrative 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!!25Views0likes0CommentsTask 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 you14Views0likes0CommentsCannot save same value from parameter twice in SQL Table Editor
I have created an SQL table editor component for one of my applications. One of the columns in the SQL table can be updated by the user, and is tied to a parameter that is used as a dropdown by the users. However, if the user tries to update that column in two rows to the same value only the first row will be saved, but if the two rows are populated with different values from the linked parameter the table is saved just fine. Has anyone else experienced this? Has anyone discovered a workaround? Thanks, Tom RSolved49Views0likes3CommentsPowerBI Custom Data Adapter
I have built a OS data adapter off of a cube view that has a parameter that prompts for entity. I subsequently built PowerBI query to pull data via this data adapter. I can get the PowerBI query to pull data if I hardcode the Entity parameter value in the Custom Subst Vars in PowerBI. What I would like to do is replace hardcoding the Entity value with list prompt for the user. That will let the user decide which entity they want to pull when they refresh the query. Any ideas on how to create this functionality? #PowerBI78Views0likes1Comment