Cognos Analytics

 View Only

  • 1.  How to run just one crosstab based on which prompt is choosen

    Posted Fri October 25, 2019 08:32 AM
    Edited by System Fri January 20, 2023 04:46 PM
    Hi,
    I have prompt page with four value prompts. Each value prompt represents single level of the same hierarchy, where prompts are cascading.  On the report page I have four crosstabs (with four queries) where each crosstab in row has single level and each crosstab is influenced by the single prompt value level.

    When user choose member from Level 1-prompt 1 I want to run just croostab with Level 1 , and not others. Also if someone choose member from Level 2 on prompt page I want to run just crosstab with Level 2, not 1,3 and 4 , and so on....

    How to manage this? I have attached two screenshots, how it looks in Cognos.


    ------------------------------
    Veljko
    ------------------------------
    #CognosAnalyticswithWatson


  • 2.  RE: How to run just one crosstab based on which prompt is choosen

    Posted Fri October 25, 2019 08:53 AM
    Could you use render variables?

    ------------------------------
    Chris Turner
    ------------------------------

    Original Message


  • 3.  RE: How to run just one crosstab based on which prompt is choosen

    Posted Fri October 25, 2019 10:08 AM
    I suppose that is possible but I do nor know how?

    ------------------------------
    Veljko
    ------------------------------

    Original Message


  • 4.  RE: How to run just one crosstab based on which prompt is choosen

    Posted Tue October 29, 2019 12:45 PM
      |   view attached

    @Veljko Attached is a sample report spec using the  ​GO Sales (analysis) package that produced the desired result. It uses a Conditional string variable and conditional block to display the correct Crosstab.

    The string variable checks to see at what point in the cascading prompts a selection has not been made (is not Missing)

    Review the spec and let me know if you have any questions.



    ------------------------------
    DENNY NAREZNY
    ------------------------------

    Attachment(s)

    txt
    IBM Spec.txt   18 KB 1 version
    Original Message


  • 5.  RE: How to run just one crosstab based on which prompt is choosen

    Posted Fri November 01, 2019 03:55 AM
    Dear @DENNY NAREZNY thank you very much for help. It works perfect.
    ​

    ------------------------------
    Veljko
    ------------------------------

    Original Message