ContributionsMost RecentMost LikesSolutionsRe: Report Books - If Statement I've tried just about everything, Base without Text5 doesn't work, I manually hardcoded the MemberList that doesn't work either, must be a bug in a book, It's very strange and I think its related to ...Re: Report Books - If Statement Cube view Filter: FullFilter:FilterMembers(RemoveZeros(Cb#Project:E#PRJ_Top:C#USD:S#PRJ_Planning:T#2026:V#Periodic:F#PRJ_100_None:O#Top:I#Top:A#PRJ_TeamFTE:U1#None:U2#PRJ_Top:U3#PRJ_Top:U4#PRJ_Top:U...Re: Report Books - If Statement 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 bu...Re: Report Books - If Statement 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_ByData...Re: Report Books - If Statement 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? Re: Filter Cost Centers without Data in Books Hi would you be able to share or explain the custom business rule logic used to supress book tabs without data? I have a similiar problem but a text1 won't work for me. I want to only loop through ...Re: How to Dynamically Report on Extended Members from the Top Consolidation Cube? This is awesome @aforementi, I was playing around with this today and noticed that base members seem to show data but intermediary parents between cubes show no aggregation or data for them. I'm cur...Re: Is it possible to use spreadsheet component (Table View in it) in the Book ? Hi Sridhar, would you be able to share a code snippet of how you were able to use Vb.Net to export a data table into excel? I assume you used a business rule. Member PropertyID Data Dictionary Hello OneStream Community, A few days ago a colleague of mine wanted to know the meaning of the various PropertyId constants present in one of the Application Database Audit Tables. I was unab...Re: Updating a OneStream Application Table through Dashboard Extender/SQL Table Editor Hi Henning, I was updating a custom Application table that I created. But I do understand the point of what you are getting at.