Multiple Dates

israrkhan — Wed, 29 May 2013 17:09:39 GMT

Hi Community,

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.

Suggestion Please.

Kind Regards

Khan

Re: Multiple Dates

er_mohit — Wed, 29 May 2013 18:18:28 GMT

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