Cognos Analytics

 View Only
  • 1.  Two Casecad Source for One Prompt

    Posted Fri July 31, 2020 04:42 PM
    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
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Two Casecad Source for One Prompt

    Posted Mon August 03, 2020 01:02 PM
    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
    ------------------------------