Filtering Data when building against a Package

[ComplexQry]

How is this done?  I want to build a cube against a Package, but I am not aware of how you filter the data.

[twlarsen]

Why not build a report off of the package and use a filter in the report?  That would be your datasource.

[ComplexQry]

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.

[twlarsen]

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 :)

[cognos8developer]

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