Catalog User-Class Filter and IWR

[griffindm]

I have written a series of Impromptu Series 7 reports using the above object in a DATASET filter. The filter allows users to see rows where a user ID value matches their user-class name. IWR is running against an Oracle 8i database from an IIS5 Win2K server. The filter works fine in the client product, with respectable performance, but when run on the web, the report runs without invoking the user-class filter, resulting in a much larger data retrieval and lots of undesirable rows. There is no mention of the problem in the Cognos knowledge base.

Anyone seen this problem before or know of a work-around?

Thanks in advance.

Regards,

Dave Griffin
The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ20-2863 first!

 

[Prasad678]

Hi Dave,
U said, the filters are working fine before publishing.

Have u mapped AccessManager Userclass & Catalog level UserClass in IWR?

I faced a similar problem, not exactly the same.
For the userclasses in Catalog, I had set some filters for some columns of a table. When published, the filters didn't get applied & all the details were shown.

In Report Administration-IWR, in the UserClassMapping tab, I mapped AccessManager Userclass & Catalog level UserClass for a particular ReportSet & then the filters were working properly.

Hope I understood ur problem & helped u.

Regards,
Prasad.

 

[griffindm]

Hi Prasad,

I have mapped the users to user classes in Access Manager. However, when the catalog user classes where generated, it placed the user classes in question just below the Root, not under a lower parent class where the filter should be inherited from. I moved the classes to the proper location, but that did not fix the problem. I am going to blow away the user classes and generate again from scratch to see if that helps. I'll post a solution if I find one. If anyone else see one first, I'd appreciate it.

Thanks again. It's good to hear that that the user class filters will work eventually.

Dave Griffin
The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ20-2863 first!

 

[quatermass]

Hi Dave,

I had a similar problem today with user classes and IWR.

Having set up user-class filters on the tables in the catalog, IWR was ignoring them.

I guess you will be running the reports as flexible processing, but when the report was at limited local processing the report was ignoring user-class filters.

Changing the report to flexible solved the problem, and user-class filters were used.



Kevin **************************************************************
Rock is Dead (Long Live Paper and Scissors)**************************************************************

 

[griffindm]

Thanks Kevin. That's is useful information for everyone.

Regards,

Dave Griffin
The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ20-2863 first!

 

[griffindm]

If anyone is interested in this problem, I have an update. It turns out that IWR was respecting the catalog userclass filters IF they were directly applied in the report. If they were being applied via a DATASET in the filter, they were being ignored. I have escalated this up to Cognos and will post when they have further information.

Regards,

Dave Griffin
The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ20-2863 first!

http://www.decisionsupportgroup.com