Forum Discussion

anilpersaud's avatar
anilpersaud
New Contributor II
2 years ago

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 ...
Extensible Documents
Reports
jwagner's avatar
jwagner
New Contributor III
2 months ago

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?

db_pdx's avatar
db_pdx
Valued Contributor
2 months ago

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.

  • jwagner's avatar
    jwagner
    New Contributor III
    2 months ago

    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!|])

    • jwagner's avatar
      jwagner
      New Contributor III
      2 months ago

      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 

       

      • db_pdx's avatar
        db_pdx
        Valued Contributor
        2 months ago

        Hi jwagner: feels like you're close. If its working in a CubeView/QuickView then it feels like a syntax issue when using it in the book. Try hardcoding values for everything first before switching to parameters in the input function. 

        As well, can you copy and paste the output you referenced? I cannot read the screenshot.

        Edit: additionally, this is being used to define the Loop component of the Report Book, correct? The Loop type should be Member Filter if it is not already.