How to get description of entity to appear when using a loop in a report book
I have a member filter loop set up to cycle through the children members of a parent entity in a report book using |Loop1Variable|. I also have |Loop1Variable| in the Page Caption of the cube view for the report book. Currently, the report book shows the name of each entity in the loop. What do I do to get the description of each entity in the loop to appear on the report?
Using Change parameter passing value for Delimited list in Report books is not working.
I have Delimited list parameter for scale in Cube views, when added the Cube views to Books and given the value to parameter using change parameters option but it's still prompting for it when I ran the book. Any suggestions, without updating the Cube views and get with Books only.How to suppress blank pages in a PDF book
Originally posted by Mark Williams I have created a PDF book that loops over a large group of entities and has a page based on a cube view for each entity. Around 10%-15% of the pages are blank. Is there an easy way to have the book skip pages for entities with no data?Error when running CubeView
Originally posted by Jacqueline McBride I tried running a CubeView I just created and received the following error message: "Error processing shared Cube Views. The maximum number of Cube View references has been exceeded." The application I am working in shares many row sets and column sets for various CubeViews. Does this error message means there is a limitation to the amount of times you can share rows/column sets? Thanks in advance! -JackieBook Designer
Question on how to loop UD#1 children using the member filter type, UD#1 loop definition and a POV parameter. I get only the first child’s data on all of the multiple pages. If I same my select department I am able to see the different pages but no data is coming into the Cube View. Posted by Carol Vredeveld Migrated from ChampionsChange the color of the Header bar in a report
Originally posted by Bart DeHaas I have a cubeview that is run in a reporting book. I have created a Cubeviewer extender rule to change some formatting. For example, to put a different logo on the report based on the entity. It works fine. On the report there is also a header line and I can adjust the header line height by the following code ElseIf uiItem.UIItemType = XFReportUIItemType.PageHeaderLabelBar Then uiItem.Height = 1 I also wanted to change the color to the company color. But it does not do it, I used uiItem.Bordercolor. But it keeps it black (See below picture, what I am looking for). Does somebody know how to do this?
Report Books - Loop, NOT Excel TABs and or Spread sheets!
Report Books LOOPS - A Loop is a sequence of instructions that will continually run a process as many times as is defined in the Loop Definition. For example, a book can be set up to loop through all the base entities under a particular hierarchy and generate an instance of the same Cube View Report for each entity. See you Building Basic Report Course for details - this is only a quick reminder that excel sheets are not the best way. Keep it all in OneStream. see this QuickTips course for details: 🤣 https://onestream.thoughtindustries.com/learn/video/quicktips-intermediate-reverse-engineering-a-report-book-part-1 Try this out on yout local OneStream App. 🕺We have a Report Book looping through a group called Clubs, a parent of children, NA Clubs and Europe Clubs etc. Screen 1 - Entity Dimension -Clubs, this books will loops through each group and sub-groups and children in clubs. The Book will loop for all entities within Clubs :watermelon: Report Books set up: Parameters (Entity). Now the customer can stop using excel sheets to see entity data - use OneSrream books - remember to check the COMBINE ALL ITEMS icon to have each entity report printed or shown on one file OneStream. Preview reports books before use. These entity report would appear in line one after each other in OneStream not as see on exactly this screen shot (I needed to reduce the size of this post). Can we use an IF Statement to add more looping base on a UD Dimension member parent and children such as Product? Try it. See my next LOOP post for details. Happy Looping 😂
