We are under construction!
You may experience downtime, errors or visual oddities, but we anticipate all will be resolved by the end of the day.
Forum Discussion
Report Book - Loop with a XFBR string
We are looking to turn some of our existing cube views into report books to loop through entities. Right now we use an XFBR string (referencing Brapi.Workflow.Metadata.GetParent) instead of a parameter to determine the entity. Is it possible to create a report that loops through the entities with the XFBR string or would we have to duplicate the cube views and use a parameter instead?
Hi, I may be misunderstanding the question as I am not sure why you are using GetParent.
However, to loop through entities in a cube view to put the same cube view multiple times into a book (PDF; Excel) you need to create a Loop (Documentation: Loop) and a Change Parameter (Documentation: Change Parameters) in your book.
The documentation gives the example of using all base entities in a Loop using the Member Filter Option:
- E#[NA Clubs].Base
This loops over each base entity under NA Clubs and performs the process for however many base entities there are.
And below the loop one has to use a Change Parameter and set Change POV to True, as per documentation:
- E#[|Loop1Variable|]
POV: Set to True to change the book’s POV without having to change the actual cube view or report.
(It's been a while since I set this up myself, so forgive me in case there is some inaccuracy here. Test it to make sure it works as intended.)
The documentation is comprehensive and hopefully gets you where you need to get to:
- E#[NA Clubs].Base
