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!!!
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?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 you
PowerBI 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? #PowerBI
Scenario management for FX
We are in the design and build phases of OneStream and it is really important to me that we get the foundation right and use OneStream the way it was intended to be used. What are the recommended design solutions in OneStream to enable users to quantify the FX translation impact separate from performance when comparing one period of time to another (e.g., YTD actuals versus budget or full year latest forecast versus full year budget). Hi HFM we do this through recalculation scenarios. For example, we have the following budget and forecast scenarios. 14 forecast scenarios - one for each month, one to recalculate the prior forecast at the most recent actual rates (used for comparisons against YTD and month actuals), one to recalculate prior forecast at the forecast rates (used for full year comparisons to prior forecast and full year budget). The latter two get overwritten every month with the latest previous forecast data and new rates. 3 budget scenarios - one for the original budget, one to recalculate the budget at the most recent actual rates, one to recalculate at the latest forecast rates. The latter two get overwritten every month with the new rates. The process works well in HFM. Should we design the same solution in OneStream? How do other people manage this?
