If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Filters in Packages

Started by Cng2005, 20 Nov 2007 03:29:54 AM

Previous topic - Next topic

Cng2005

Hi Gurus,
I need to create 3 packages based on the same model , however these packages will have filters on the COMPANY-ID
like
PACK1 == filter on COMPANY-ID='HU'
PACK2 == filter on COMPANY-ID='HM'
etc
This is required because an user can be a member of 1 or more companies, and he would need to create different reports on the packages....
If I am not clear, pl let me know and I will try to explain my situation better.

many thanks


rockytopmark

Pleaseeconsider 3 different Packages that are virtually identical... only different data... and instead consider using Data-Level (Row level) security.  This way you will not have to maintain 3 sets of Namespaces/Queries/Items.

Based on your Authentication Provider, you have access to what Groups the active user belongs to, and with that information, you can limit the rows to only those that correspond to their company(s).  1 set of Namespaces and queries, whose data is controlled seamlessly by the user's credentials.

If you choose to stay with 3 Packages, you will need a layer of Model Queries in 3 seperate Namespaces that will represent each company.  The model Queries will differ (from namespace to namespace) only in that they will have a filter that limits the data to a specific (and different) company.

Packages, unfortunately for you, are just collections of metadata objects and are not subject to have filtering done explicitly on it or its contents.  That is done in the Query Subject object.

Cng2005

many thanks for the reply. Your first suggestion is great.
I made a Data Security in the company table and assigned filters to specific User groups and kept just 1 package.


many thanks :-)