Cognos Auto Multi Select Cascading Issues
I tried to implement below solution to achieve multi cascading prompt requirement when there are more than 2 dependent prompts:- http://www.ibm.com/developerworks/library/ba-pp-reporting-scripting_techniques-page673/ It worked beautifully on IE with Cognos 10.2.2 FP3 along with sorting function. There is one issue users came back with in this approach. Issue # 1 1. It was not working on Report page. To solve this, created a small lookup table for prompts and use back button on report page to go back to Prompt Page. In Query itself, created a dummy query to get ALL combinations. Used it to union with prompt data query to get it in multi cascading selection. Issue # 2 Second issue popped up as we press Back button, JavaScript runs again and populate all possible values in child prompts though selected values are still highlighted. This results in situation when user can select a combination from child prompt to get zero records. As soon as User clicks on any paren