tmckinno43
Technical User
I'm trying to create a business view in XI for creation of LOVs for dynamic cascading prompts in a Crystal Report.
The LOVs returned should be only those which are relevant to the security profile of the report user.
My understanding is that there exists a variable in Crystal which is exposed in Business Views which will return the username. My further understanding is that I can use this value in an SQL statement in the Data Foundation of the Business View to restrict the LOVs returned (using it as a parameter in the SQL against a table containing the row level security profile).
My problem is this: I don't know how to access this username in Business Views. Also, I'm pretty raw with Business Views generally, so if there are any caveats anyone could offer (or if any of the above seems wrong), along this general line of inquiry, I'd be most appreciative.
The LOVs returned should be only those which are relevant to the security profile of the report user.
My understanding is that there exists a variable in Crystal which is exposed in Business Views which will return the username. My further understanding is that I can use this value in an SQL statement in the Data Foundation of the Business View to restrict the LOVs returned (using it as a parameter in the SQL against a table containing the row level security profile).
My problem is this: I don't know how to access this username in Business Views. Also, I'm pretty raw with Business Views generally, so if there are any caveats anyone could offer (or if any of the above seems wrong), along this general line of inquiry, I'd be most appreciative.