Hi,

I am building a Metadata for Interactive reports. My report requirement is, when user logs in he should get list of regions related to his job profile. I am able to populate a comma separated list of regions in session variable "sRegion" using an action sequence.

Now, I want to use it as a contraint in Metadata business Model. So I am trying to write following condition:

IN(BT_TRegions.BC_Region;"SESSION("sRegion")")

However, above condition reads session variable as full string and not as separate region: Eg. "FA,NY,GA" etc. hence the report does not return any value.

Is there any way I could read regions separately?

Regards,
Jayesh