How to get common month from (DP1) Month and (DP2) Fiscal Period

Hi,

I have 2 data providers, one has Month Name(January, February, March, April.......) and its key figures, second data provider has Fiscal Period(JAN 2016, FEB 2016, MAR 2016.......) its key figures.

We have other dimensions also where we have done the merge:

e.g.

MaterialNo., Material Type,........

So if I show dp1's and dp2's key figure on merged MaterialNo. and Material Type data comes fine.

I have a requirement to show both key figure monthly basis.

Can you please tell me the way how can I do it.

Thanks,

Ankit