I'm trying to use Report Studio to write a 13-month financial statement report. The data is published to a TM1 cube from Cognos Controller through FAP. In addition to the measures for a given month, FAP also publishes a time-dependent company structure, so that obtaining a correct display of December 2012 results, for instance, depends on the December 2012 company structure (Structure Version) being selected.
The problem I am having is one of forcing the data returned for a given month to conform to the Structure Version for that month. The intended result is that for a 13-month view beginning with December 2011, the Dec 2011 data is displayed with the Dec 2011 Structure Version, Jan 2012 is displayed with the Jan 2012 Structure Version, and so on.
Any suggestions on how to accomplish this?
Thank you.