COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => BI Modeling (Transformer) => Topic started by: ComplexQry on 07 Dec 2009 12:51:30 PM

Title: Filtering Data when building against a Package
Post by: ComplexQry on 07 Dec 2009 12:51:30 PM
How is this done?  I want to build a cube against a Package, but I am not aware of how you filter the data.
Title: Re: Filtering Data when building against a Package
Post by: twlarsen on 07 Dec 2009 03:11:27 PM
Why not build a report off of the package and use a filter in the report?  That would be your datasource.
Title: Re: Filtering Data when building against a Package
Post by: ComplexQry on 07 Dec 2009 03:53:45 PM
Sounds like that is the best option.  I was wanting/hoping that all of that could be done from within Transformer.  Maintaining 2 files (FM Model and Transformer Model) is better than maintaining 3 files (FM Model, Transformer Model, and Report Studio Report).  At least that is what I was envisioning.  It seems kind of silly that you can source from a package, but not tell it how you want to filter it.
Title: Re: Filtering Data when building against a Package
Post by: twlarsen on 09 Dec 2009 12:32:28 PM
I think you're misunderstanding how they should be used.  If you really want to filter the data using a package, you would make the the filter in Framework Manager and re-publish the package.  That's more in-depth then changing a filter in a report.

Using a report is more setup time in the begining, but easier to change later on.  Using a package is easy setup, but harder to change later on.

You also have to remember that it's pretty simple to create a list report off of a package :)
Title: Re: Filtering Data when building against a Package
Post by: cognos8developer on 03 Jan 2010 09:38:43 PM
You can always add a filter in your Package.

When it is published & avaliable, when you "Modify Columns" on your query in Transformer you can add a filter which will reduce your result set.

Then you can always update the Filter in the package and it will automatically update any models that use it.

Cheers