Cognos Analytics

 View Only
  • 1.  How to hide part of report when prompt is not choose

    Posted Thu September 05, 2019 05:16 AM
      |   view attached
    Hi,
    I have prompt page with several prompts from same hierarchy, levels. On the report page in crosstab I have inserted those hierarchy levels. Now I want to create, when user choose just first Level1 in prompts, to hide all others levels from report. If users choose all level prompts, then to show all those data on report.

    How to succeed  this. I have attached example of croostab with levels.

    Thanks for help.


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

    #CognosAnalyticswithWatson


  • 2.  RE: How to hide part of report when prompt is not choose

    Posted Thu September 05, 2019 08:26 AM
    How about using a conditional block? It may affect the report performance if the crosstab contains a large amount of data though.

    Can you show your prompts so that I can think of a better solution? :)

    ------------------------------
    Luna
    ------------------------------



  • 3.  RE: How to hide part of report when prompt is not choose

    Posted Thu September 05, 2019 09:18 AM
    Hi @Learner Cognos thank you for help. I have regular prompt page, with value prompts, where prompt value1 is Level1, second prompt2 is Level2... and those are cascading prompts, where prompts from Level2,3... are optional. So, I want if user does not choose nothing from prompt 2,3... to hide Level2,3.. from report.

    I have also think to create separate crosstab for each Level, maybe that will be more functional? ​

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



  • 4.  RE: How to hide part of report when prompt is not choose

    Posted Thu September 05, 2019 10:43 PM
    I think you may create a conditional block which contains separate crosstab for each level. 

    I have tested that the query will not be executed if it is not shown by the conditional block. So there is no worry about using conditional block causes slowly-running report.