Time Lag Tm1 Cube Rule dynamisch
['Measures P50 CFSales':{'Total L3M closed Periods AY'}]=N:DB('P50 CF Sales', 'All Periods', !Clients, !Debitors Top Level Plan, !Products Top Level Plan, 'L3M closed Persiods AY');
['Measures P50 CFSales':{'NetSales AY FC Cash'}]=N:DB('P50 CF Sales', DIMNM('PeriodsMonth',(DIMIX('PeriodsMonth', !PeriodsMonth)-
DB('P50 CF Sales', !PeriodsMonth, !Clients, !Debitors Top Level Plan, !Products Top Level Plan, 'TimeLAG Cash Edit')
)),
!Clients, !Debitors Top Level Plan, !Products Top Level Plan, 'NetSales AY FC');
Dein Kommentar
An Diskussion beteiligen?Hinterlasse uns Deinen Kommentar!