You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

HCM OTBI Report Multiple Selection Parameter

edited Aug 15, 2017 10:13PM in Reporting and Analytics for HCM 9 comments

Summary

HCM OTBI Report Multiple Selection Parameter Not Working

Content

Hi,

I'm trying to use multiple selection parameter ( menu type ) in data set sql query but report fails when multiple values are selected. 

If anyone knows how to use multiple selection menu as parameter in data set sql query, please advise.

Below are steps that I tried and failed

1. Create data model with multiple selection enabled parameter ( menu type )
    In Data Set query, put parameter condition ( WHERE field1 IN ( :param1 ) ) 
2. Create report from data model 
3. Select multiple value in parameter menu and run report 
4. Report fails with error message 

Thanks,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!