Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only
Expand all | Collapse all

Prompt Problem

  • 1.  Prompt Problem

    Posted Mon December 02, 2024 11:57 AM

    The default prompt value was working in version 11.0 but not in version 11.1.7 FP8.

    Reporting is against a TM1 cube. The default value entry is set up as a MUN

    [Somecube].[Version].[Version].[Version]->:[TMR].[Version].[Version].[Current Versions^Actual Mths 2024]

    When the prompt page appears the default value does not show whereas it did in the prior version

    Various things have been tried, changing from a MUN to an alias, putting an incorrect value in to see if it is seeing the default, it is and it errors when incorrect.  Strangely enough the first prompt on the page, Week, also has a default value and it works, however that is a value of 01 and not a MUN.

    We fully understand that 11.1.7 FP8 went out of support a few months ago, but we are unable to upgrade at this time. We tried logging a ticket with IBM Support asking if this was a known FP8 issue (or if an IF was available), but the ticket was shut down immediately.

    If anyone in the Community can shed some advice on anything to try, that would be greatly appreciated.



    ------------------------------
    David Schlessinger
    ------------------------------


  • 2.  RE: Prompt Problem

    Posted Tue December 03, 2024 02:00 AM

    Can you confirm the Default Selection MUN is still returned by the qVersion query?



    ------------------------------
    Marc Reed
    ------------------------------



  • 3.  RE: Prompt Problem

    Posted Tue December 03, 2024 04:44 AM

    I suspect this is the problem. With TM1 the same member may appear in different places in a hierarchy. Considering the key is [Current Version^Actual Mths 2024], if the set being returned by ActualSC has a member with the key [Actual Mths 2024] it wouldn't match. 



    ------------------------------
    Paul Mendelson Product Manager
    Product Manager
    PMsquare
    ------------------------------



  • 4.  RE: Prompt Problem

    Posted Tue December 03, 2024 09:06 AM

    Hi Marc,

    Yes the query returns the member that is set as default



    ------------------------------
    David Schlessinger
    ------------------------------



  • 5.  RE: Prompt Problem

    Posted Wed December 04, 2024 07:09 AM

    I Agree!



    ------------------------------
    thomas blaket
    ------------------------------



  • 6.  RE: Prompt Problem

    Posted Tue December 03, 2024 09:11 AM

    Hi Paul,

    Tried setting to the 2 MUNS it appears as.

    Again, this worked fine in V11.0 but not in V11.1.7FP8, so something has changed in the way the default value works.

    And cannot get Support to look at it, even though FP8 was released late February 2024, just a couple of months before 11.1.7 went out of Support.



    ------------------------------
    David Schlessinger
    ------------------------------



  • 7.  RE: Prompt Problem

    Posted Tue December 03, 2024 09:34 AM

    @David Schlessinger , even though the default selection doesn't work, does the MUN [Somecube].[Version].[Version].[Version]->:[TMR].[Version].[Version].[Current Versions^Actual Mths 2024] appear as a selectable value in the prompt when the report runs?



    ------------------------------
    Marc Reed
    ------------------------------



  • 8.  RE: Prompt Problem

    Posted Tue December 03, 2024 10:09 AM

    Hi @Marc Reed

    Yes, it is a selectable value in the drop down list, along with everything else in the query.



    ------------------------------
    David Schlessinger
    ------------------------------



  • 9.  RE: Prompt Problem

    Posted Wed December 04, 2024 04:03 AM

    Well if it is a bug then we'll need to find a workaround.

    Just out of interest, what happens if you add the MUN that is the default selection as a static value to the prompt? Does the MUN appear twice when the prompt runs or just once?



    ------------------------------
    Marc Reed
    ------------------------------



  • 10.  RE: Prompt Problem

    Posted Wed December 04, 2024 11:42 AM

    @Marc Reed   Yes, the MUN does appear twice in the prompt list. However it also makes the default work, so all is good.  No idea why though? Any thoughts?  Many thanks for the help.



    ------------------------------
    David Schlessinger
    ------------------------------



  • 11.  RE: Prompt Problem

    Posted Wed December 04, 2024 12:13 PM

    If a static value and query value are identical then I would only expect it to appear once in the prompt.

    As you have two entries, it would imply that in your prompt the static and query MUNs are not identical. Which would also align with the original issue that you reported.

    I would export your prompt query to csv and check the MUN is exactly what you are expecting - including spaces and the like.



    ------------------------------
    Marc Reed
    ------------------------------



  • 12.  RE: Prompt Problem

    Posted Thu December 05, 2024 10:15 AM

    Hi @Marc Reed

    We had already exported and the MUN was what we were expecting. This was all working fine in 11.0, now not working in 11.1.7 FP8. Clearly a bug in FP8.

    Thank you so much for the workaround. Very muchly appreciated!

    David



    ------------------------------
    David Schlessinger
    ------------------------------