If it is essbase/planning,
I've created something like this for our requirement using MaxL,
spool on to C:\UserAll_groupAll.csv;
display user in group all ;
Columns in file are fixed width delimited, right alinged. Once we seperate the columns values gets left aligned and you can use for your reoirting.