i'm just giving you a clue because it seems difficult to answer basically to a complex model.
May be you should create a MaseterCalendar table which will link with other tables in your model thru
"Date & <KeyField>" as a key
you then lighten your set analysis to date from calendar table
cheers Chris, thanks for the reply.
i do use a master calendar which is dissociated from the set allowing dynamic selections. The main issue is NULLS. Its almost like scripting a left outer join in set analysis.
i cant count from two different tables with just one expression due to the start/end dates.
i never, ever want to touch a SAP schema again. Ever.