Recursive Error Whenever use Parameter Map Filter in FM Package?

[longhorndkr]

Gents,

Can anyone help me figure out a problem that has been be-deviling me?  I have a star-schema FM data model with 3 layers, Foundation (db) view, Business View and a Dimensional view.  The Foundation view is just selects on my imported tables, the Business view is composed of model query subjects whose names are basically prettied up from the relational and the Dimensional layer is composed of regular dimensions  to give drillable reporting (and a measure dimension, of course).   I am using Cognos 8.4.1 on Windows w all fixpacks.

Client wanted reporting by individual user so I
1) added a Parameter Map (against a system user table that gives me the username of the user logging in and their key in the fact table; in this case DimTeacher_ID), and then
2) applied a Security Filter on my Fact table (that basically filters the Fact to that user's data based on the userid (DimTeacher_ID) key in the Fact). 

Here is my Security Filter:  [Foundation View].[Fact_Student_Test_Score].[DimTeacher_ID]   = #$Teacher_Map{$account.personalInfo.userName}# . 

I applied the Filter against the Fact in my Business layer.  The model checked out, no errors in validation, Testing showed the proper values being filtered, etc.  Everything looks good in the model. 

When I publish my package and run my report off it, however, I get about 50 "GEN-ERR-0008 A possible recursive definition involving the parameter map 'Teacher_Map' based on query items that were detected."   I have checked and re-checked the model and there are no recursive elements, joins, etc.  My scope looks fine, all of my dimension tables are related to the Fact via PK-FK relationships in my Foundation View.  The Business View is just model query subjects of the tables in the underlying Foundation View except the Fact has been filtered using the aforementioned Security Filter.

The ONLY way I can get rid of the errors is to point all of my regular dimensions in my Dimensional view (which I am using in my report) to the Foundation View instead of the Business View.  Remember, the Business View Fact table has my Security Filter.  My Measures dimension in my Dimensional layer is pointing to the Business View Fact table though (because that is what is filtered). 

Any ideas what is causing my recursive errors?  The SystemUser table the PMap is based on is a standalone table.  I removed any joins of the userid key from it to the Fact to try to eliminate the errors with no luck.

Effectively, if I point the dimensions in my Dimensional layer to the Foundation (db) View, I am avoiding using my Security Filter (which is in my Business layer)!!  Any help would be VERY appreciated!!!!

Thank you,
Dave

[longhorndkr]

One correction to my earlier post above:  My Security Filter shows [Foundation View].[Fact...].[DimTeacher_ID] even though I said I am filtering on BUSINESS View Fact table...  that's just a typo because I've been switching back and forth between the Foundation View and my Business View to try to get the dang thing to work/make errors go away. 

Again, anyone that's run into something like this?  Any help or suggestions would be AWESOME!

[MFGF]

Hi,

Two suggestions:

1. Move the filter to the foundation view query subject

or

2. Leave the filter where it is and modify it to use the DimTeacher_ID item in the business view.

Cheers!

MF.