Forum Discussion
What's the use case? I would tend to think you want an XFBR based off parameters to return the list you want dynamically, but you mentioned it running only on Report. What is it you're trying to accomplish. It might help us troubleshoot
- RobbSalzmann2 years agoValued Contributor II
The use case is to get the member names for the first row of the report:
private List<string> GetFirstRowMembers(SessionInfo si, CVExtenderArgs args) { List<String> rowMembers = new List<string>(); CubeViewRow row = args.Report.CubeView.Rows.First(); List<CubeViewMemberExpansion> rowMemberExpansions = row.MemberExpansions; foreach(CubeViewMemberExpansion rowMemberExpansion in rowMemberExpansions) { string[] memberFilters = rowMemberExpansion.MemberFilter.Split(new char[]{',', ' '}); foreach(string memberFilter in memberFilters) { //This call returns null List<MemberInfo> members = BRApi.Finance.Metadata.GetMembersUsingFilter(si, rowMemberExpansion.PrimaryDimTypeName, memberFilter, false); //Returns null even with known, hard coded arguments //List<MemberInfo> members = BRApi.Finance.Metadata.GetMembersUsingFilter(si, "Account", "a#16999.children", false); foreach(MemberInfo member in members) { string nameAdDesc = member.Member.NameAndDescription; rowMembers.Add(nameAdDesc); } } } return rowMembers; }
- db_pdx2 years agoValued Contributor
It's still not clear what you are trying to accomplish:
"The use case is to get the member names for the first row of the report" to do what with them? Standard functionality can toggle displaying of member names and description. Is it that you want to change what is displayed when running the PDF report? Meaning, display Member Name and Description when in the native view, but only display Description when in the PDF report?
Or are you trying to do some sort of drill-down expansion when running the PDF? Or are you trying to create a custom member expansion?
Related Content
- 3 years ago
- 3 years ago
- 3 years ago