IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
1 reply Latest Post - ‏2012-08-10T11:39:00Z by kiwisuz
250 Posts

Pinned topic Cognos 10 Transformer with Framework Package as Data Source

‏2012-08-08T10:37:54Z |

I am planning to develop a Cube using Transformer. The data source is the Framework Manager package (There are already some filters predefined for the package).

Is there any way that I can use these filters in the FM Package to filter the data that comes into Transformer via FM Package?

Thanks in Advance

Updated on 2012-08-10T11:39:00Z at 2012-08-10T11:39:00Z by kiwisuz
  • kiwisuz
    2 Posts

    Re: Cognos 10 Transformer with Framework Package as Data Source

    ‏2012-08-10T11:39:00Z  in response to SystemAdmin
    Not directly from the package, as in transformer you can only add columns from whatever source you are using, you can't add where clauses.

    A better/best practise would be to create a report off the package in Cognos and then use the report as a source for the the cube. Then you can use your predefined filters. It is also much easier to test your results from the cube against the report as well.