I created an InfoSet from two InfoCubes and a DataStore. I first brought in the main InfoCube and then I brought in the DataStore. I joined them and made the join a Left outer join because I do not want to limit the data in the InfoCube to on rows shared with the DataStore. Then I brought in a second InfoCube and joined it to the first InfoCube on Plant, Fiscal Year Period, and Fiscal Year Variant (we have multiple versions of fiscal year depending on which company we are reviewing).
The issue is, I am getting back 00000 for Fiscal Year Period. When I look at fiscal year period in each of the two InfoCubes that I am joining, it is populated in both. They also have similar values, so one would think the join would work appropriately, but it isn't. Anyone have any ideas on how to make this join work?