COGNOiSe.com - The IBM Cognos Community

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

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.

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

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.

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

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