Topic
1 reply Latest Post - ‏2012-08-10T11:39:00Z by kiwisuz
SystemAdmin
SystemAdmin
250 Posts
ACCEPTED ANSWER

Pinned topic Cognos 10 Transformer with Framework Package as Data Source

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

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

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

    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.