If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Force Structure Version and Month to correspond in report from FAP

Started by jon.abel, 15 Jan 2014 06:25:37 PM

Previous topic - Next topic

jon.abel

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.