Cognos Analytics

Expand all | Collapse all

Two Casecad Source for One Prompt

  • 1.  Two Casecad Source for One Prompt

    Posted 9 days ago
    Hi All,
     / C
       As per Client requirement, we require Two Cascade source for One Prompt.
    i.e.
    For Single Prompt Customer ID (using Search & Select Prompt) -- We Require two Parent / Cascade Source
    i.e.  Branch ID (Using Search & Select Prompt ) and Customer Type (Using Value Prompt).


    very thankful.


    ------------------------------
    Hashim Raza
    ------------------------------


  • 2.  RE: Two Casecad Source for One Prompt

    Posted 6 days ago
    Hi @Hashim Raza,
    If I understand what you are trying to do, you will need to create a two-tiered cascading prompt, so Branch ID would be the Cascade Source for Customer Type (or vice-versa), and then use that as the Cascade Source for the final (Customer ID) prompt.  You can then filter the source query for Customer ID prompt by BOTH parameters


    ------------------------------
    Albert Valdez
    albert@intelalytics.com
    ------------------------------