![[Avatar]](/images/avatar26.png){kind=avatar}
daveb78
1p
1 comments posted · 0 followers · following 0
13 years ago @ Art of Business Intell... - OBI Time Dimension Wee... · 0 replies · +1 points
If your physical database is Oracle you could do something like this:
Evaluate('to_char(%1,%2)' as integer, Evaluate('last_day(%1)' as varchar(10), "Indirect Sales”.DIM_TIME.MONTH ), 'WW') - (Evaluate('to_char(%1,%2)' as integer, "Indirect Sales”.DIM_TIME.MONTH, 'WW' ))
Evaluate('to_char(%1,%2)' as integer, Evaluate('last_day(%1)' as varchar(10), "Indirect Sales”.DIM_TIME.MONTH ), 'WW') - (Evaluate('to_char(%1,%2)' as integer, "Indirect Sales”.DIM_TIME.MONTH, 'WW' ))
Invention