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
NOTICE: 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.
This topic has been locked.
1 reply Latest Post - 2012-08-10T11:39:00Z by kiwisuz
Pinned topic Cognos 10 Transformer with Framework Package as Data Source
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-08-10T11:39:00Z at 2012-08-10T11:39:00Z by kiwisuz
kiwisuz 2700029KN22 PostsACCEPTED ANSWER
Re: Cognos 10 Transformer with Framework Package as Data Source2012-08-10T11:39:00Z in response to SystemAdminNot 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.