i have 2 simplw question please answer:
1) I Have To Develope a Balance Score Card, There Are 13 KPI in Different Excel Files and qvd's.
Each KPI Have its own Date In Different format then others, so is it possible to create one calendar to analuse all KPI with one date, OR
How to handle with all dates.. (Some KPI are for two year eg 2011 and 2012, and some are sine 2000, and some since 2005)
sp shall i join all table with Date or how to deal.
2) how to change Month format January to Jan, in Number tabe i am changing to MMM , But its not changing the format.
You have to make master calender then using floor function with your different date you can link with this calender.
make sure that the date format for all datefield is same .Hope it helps You
you could join also for doing that but it quite complicated table because your all Fact tables are attached in one table
Hope it helps you