fiscal year on discharge date

[nfldbunker]

hi

i have data element in my reporting environment which is discharge date. i want to have a report nbased on fiscal year from april 1-march 31. how do i use the discharge date and make it inot fiscal date in my report

thanks

bunker

[twlarsen]

I would suggest setting up a date dimension table with a fiscal year column.  Then you could just pull that field into your report

Otherwise you could hard code a data item, but if you're going to use this in other reports you might want to think about the structure of your reporting environment.

[nfldbunker]

HI

would i set this jup in framework manager model and create a table (querry subject) to create the fiscal year.what would the code be for this situtaion. would i create more than just fiscal year and create other possible dates?

thanks for reply

[twlarsen]

You would setup the table in the database and bring it into your model.

I usually have a ton of columns in my date dimension table. Such as Fiscal Year, Week, WorkingDay, Posting Month, Calendar Month, etc.

[nfldbunker]

hi

I used a script in sql to create a time dimension table. how to i bring this into out production model and create proper relationship. do i create proper cardinality to discharge date?

thanks in advance

bunker

[twlarsen]

Bring it into your model just like any other table you bring in and link it to your date field in your fact table.