Skip to Content
0
Former Member
Mar 26, 2007 at 06:17 PM

Reporting based on Fiscal Period, Week, Month in BI?

225 Views

Dear Bwers,

I have a situation where i have data in SQL server table and i have two dates in that Activity Date and Ship date that are based on Fiscal Year. Now in BI, the enduser wants to report with these dates with the buckets like period, week, month. Is it possible to model and report this in BI? What should i map these fields to in order to report on Period, Week, Month that is based on Fiscal year?

All or any help will be appreciated?

Thanks

Raj