Data issue with Months and Days?

21 Views

I have a issue with the data. i am loaded inventory data to the cube from R/3 System and after that i loaded some data by using some fields to the same Infocube. the data loaded by using flat file is Month Rate 01.2013 100 02.2013 140 03.2013 120 i Need a report like below Day Rate Stock 01.01.2013 100 220 07.01.2013 100 350 18.01.2013 100 640 But in the Report output i am getting like below Day Rate Stock 01.01.2013 100 220 07.01.2013
350 18.01.2013 640 How can i achieve this? please help. in the cube i have data like below: Day Month Rate Stock 01.01.2013 01.2013 100 220 07.01.2013 01.2013 100 350 18.01.2013 01.2013 100 640