Report Books - If Statement
Hi There,
I am trying to create a book with a loop on our UD4 (project). I have it working but I want to add an IF statement to filter out tabs that contain no data. Referencing a previous post, I ...
Forum Discussion
Hi anilpersaud: you're really close, just a few things to change and we can hopefully get this working for you.
Regarding the changes to the BR:
- You only needed to modify the sections that indicated 'SET A DEFAULT HERE' which it looks like you've set correctly.
Modifications to make it work in your CV. For your member filter, try:
U4#TotProject.CustomMemberList(BRName=XFR_MemberList_ByDataBuffer, MemberListName=MemberListHasData, MemberExpansion=[Base], Sort=[True], MaxNumOfMembers=[20])
A few notes on the changes I made above:
- The X#Member is meant to represent the dimension you are pulling and the initial starting member to expand from, in this case U4#TotProject
- Sort, you'll want to pick either 'True' or 'False'
- The rest of the dimensions can be removed when used in the CubeView as they will simply pull from what is defined in your Cube View POV. However, you can also retain them if you'd like the member list to generate from the unique dimensions you've referenced rather than following the Cube View POV.
- General reminder, the rest of the dimensions will follow those defaults you've set, but can also be overridden as needed.
When you go to use this in a Report Book:
- The Report Book does not have the concept of the Cube View POV, hence you will need to include those Data Unit dimensions in the syntax of the CustomMemberList
- Usage in the Report Book Loop Member Filter will look like:
-
U4#TotProject.CustomMemberList(BRName=XFR_MemberList_ByDataBuffer, MemberListName=MemberListHasData, MemberExpansion=[Base], Sort=[True], MaxNumOfMembers=[20], Cube=[00_CorpRpt], Entity=[RealEntityHere-or-|!UseAnEntityParameter!|], Cons=[Local], Scenario=[Budget_V2], Time=[2024])
Let me know if that gets it going for you.
Cheers, -db
I have set up my defaults and cube view member filter in a simple cube view, but the Finance rule seems to not be returning anything from the data buffer. How could I debug this?
Hi jwagner: can you share the syntax you are using from your cube view? I'd check that first.
For more formal debugging: you could temporarily add some logging before and after the databuffer is pulled. I'd check the 'fullFilter' to ensure you have a properly formed databuffer query, as well as the first lines of the databuffer itself.
Hi, what's strange is I am able to get a valid member list back from the cube view but can't get it to work through a Book.
Cube View Syntax: U5#PRJ_Top.CustomMemberList(BRName=XFR_MemberList_ByDataBuffer, MemberListName=MemberListHasData, MemberExpansion=[Base.Where(Text5 = 4010)], Sort=[True], MaxNumOfMembers=[20])
Book Syntax: U5#PRJ_Top.CustomMemberList(BRName=XFR_MemberList_ByDataBuffer, MemberListName=MemberListHasData, MemberExpansion=[Base], Sort=[True],
Cube=[Project], Entity=[PRJ_Top], Cons=[USD], Scenario=[PRJ_Planning], Time=[|!prm_SelectTime_PRP!|])I want to use a parameter in the Member Expansion piece of the syntax, I have an error log showing the different data buffer filters between a book and cube view, the cube view is returning a data buffer with valid records, while the book returns no records. I'm a bit stumped here