Cognos Controller

Latest Discussions

  • Hi John, I have seen this problem many many times over the years - it is extremely common. By default, Excel will typically try to run (update / autocalculate) an Excel spreadsheet when it is opened (especially from an email). The solution is very ...

  • Hi John, Probably a bit late, what we do in our Excel reports is we have a data sheet that pulls back all the data from Cognos Controller (with the fgetval formula) and then we have another sheet called data values in the Excel report which is an exact ...

  • Hi Paul, Financial Analytics Publisher (FAP) is the portion of Controller that you can configure (if you want) to publish the Controller data from its source (typically a MS SQL database) to a TM1 (now properly known as 'Planning Analytics') cube. This ...

  • Thanks Richard for the reply. Sorry for my ignorance, but what is FAP cube? Is it an interface between controller and or applications? Paul Cherubin Group Reporting Manager ...

  • Hi Khai No, this is not possible in the Excel link. You would have to use expand structures in the report generator. In the Excel-link you must always tell exactly the dimensions you want to see, no expansion possible. ------------------------------ ...

  • Is it possible to retrieve all counter companies for one company using Controller Excel functions? For instance, I would get a list of all counter companies I have internal transactions with, for one intercompany account. Is this possible? ------------------------------ ...

Latest Blogs

Log in to see this information

Either the content you're seeking doesn't exist or it requires proper authentication before viewing.

Latest Files

Log in to see this information

Content coming soon!