How to include Member IDs in data export
We are using an extender business rule to run FdxExecuteDataUnit and write the data (with dimensionality) to a file. The file generated seems to be a standard format with a column for each dimension...
Forum Discussion
Hi Denise
You can get a dictionary of any members you need to capture e g key = Name, value = MemberId. Then create a new DataTable and add additional columns as required
Then you can loop through your fdx DataTable and use the dictionary to reference the Member Ids so that you can derive the datarow values to pass into your new column e.g MemberID in your new DataTable
Using a dictionary shouldn't really impact performance from this extra step in your code. I have used this approach before to derive extra columns from fdx data
Hope this helps
Sam