1 Reply Latest reply: May 29, 2013 2:18 PM by Mohit Sharma RSS

    Multiple Dates

    Israr Khan

      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
          Mohit Sharma

          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