My client want to analyse the sales every month. But the "month" they defined is beginning from the 21st day of every month to the 20th day of next day. However, cognos transformer don't support such custom level of time dimension. How to custom this? Thanks!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to custom time dimension?
- Thread starter optilio
- Start date
Hmm.
How about, if your date comes from [sales_date], you create a calculated field in the data source, called [calc_date] which is add-days([sales_date],-20)?
You can then create a date dimension for Years and Months using [calc_date]. Once created, add a Day level using [sales_date] as the "source" and "order by". You should now have a date dimension that shows a month comprised of 21st to the last day for that month, together with the 20 days of the subsequent month.
soi la, soi carré
How about, if your date comes from [sales_date], you create a calculated field in the data source, called [calc_date] which is add-days([sales_date],-20)?
You can then create a date dimension for Years and Months using [calc_date]. Once created, add a Day level using [sales_date] as the "source" and "order by". You should now have a date dimension that shows a month comprised of 21st to the last day for that month, together with the 20 days of the subsequent month.
soi la, soi carré
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question