Hello!!!
I am using Crystal Reports 2008, Business Objects Enterprise XI R3 with Oracle 10g
I have developed a business view (BV) that feeds a dynamic cascading prompt. This issue is tied to the top level prompt in the cascade.
The BV data foundation has a couple formula fields.
1) "Region" (CHAR) which contains MID(CurrentCEUserName,4,10) - 1st 3 are ignored
2) "Match" (Boolean) which contains TRUE/FALSE on UPPERCASE({@Region}) = LEFT(UPPERCASE({Command.REGION}),10)
The BV business element has a filter "ISMatch" that is set to the data foundation Match formula being true.
This worked great until we encountered an issue in UAT. When more that one Infoview user (all with different user IDs) run the report at the same time, their individual user IDs seem to get mixed up in the process. So user "Toronto" is getting region "East" values in the dynamic cascading prompt and the "East" user might be getting the "West" user's values. Yes, very strange.
I am assuming this is some sort of a caching issue on the BOEXI server but I can not figure it out. Anyone ever see this sort of thing before?
Any feedback would be appreciated.
I am using Crystal Reports 2008, Business Objects Enterprise XI R3 with Oracle 10g
I have developed a business view (BV) that feeds a dynamic cascading prompt. This issue is tied to the top level prompt in the cascade.
The BV data foundation has a couple formula fields.
1) "Region" (CHAR) which contains MID(CurrentCEUserName,4,10) - 1st 3 are ignored
2) "Match" (Boolean) which contains TRUE/FALSE on UPPERCASE({@Region}) = LEFT(UPPERCASE({Command.REGION}),10)
The BV business element has a filter "ISMatch" that is set to the data foundation Match formula being true.
This worked great until we encountered an issue in UAT. When more that one Infoview user (all with different user IDs) run the report at the same time, their individual user IDs seem to get mixed up in the process. So user "Toronto" is getting region "East" values in the dynamic cascading prompt and the "East" user might be getting the "West" user's values. Yes, very strange.
I am assuming this is some sort of a caching issue on the BOEXI server but I can not figure it out. Anyone ever see this sort of thing before?
Any feedback would be appreciated.