Cognos Analytics

Cognos Analytics

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


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only
  • 1.  cA11.1.7Excel Formatting

    Posted 10/02/20 08:07 AM
    in CA 11.1.7 I have BIG text need to be display in excel , But i have fixed cell size and overflow width 2 in - white space -No Wrap / Default
    Spacing & breaking used all option (Break, Normal etc..)

    Getting the output


    Pls advice any inputs . it used work in earlier version with these setting
    enabled • RSVP.EXCEL.XLS2007_ALLOW_WRAPPING_SINGLE_CELL =TRUE and • RSVP.EXCEL.XLS2007_COLUMN_WIDTH_CONTROL=TRUE as well

    Need to show as below format in report 



    ------------------------------
    Chandra Medarametla
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: cA11.1.7Excel Formatting

    Posted 10/07/20 09:59 AM
    Team - Any inputs please

    ------------------------------
    Chandra Medarametla
    ------------------------------



  • 3.  RE: cA11.1.7Excel Formatting

    Posted 10/08/20 08:30 AM
    Edited by System Admin 01/20/23 04:40 PM
    Perhpaps the bug has reoccurence: PH15622: ADVANCE PROPERTY RSVP.EXCEL.XLS2007_ALLOW_WRAPPING_SINGLE_CELL IS NOT WORKING IN CA 11.1.3
    Ibm remove preview
    PH15622: ADVANCE PROPERTY RSVP.EXCEL.XLS2007_ALLOW_WRAPPING_SINGLE_CELL IS NOT WORKING IN CA 11.1.3
    Advance property RSVP.EXCEL.XLS2007_ALLOW_WRAPPING_SINGLE_CELL is not working in CA 11.1.3
    View this on Ibm >
     

    ------------------------------
    Dariusz Danielewski
    ------------------------------



  • 4.  RE: cA11.1.7Excel Formatting

    Posted 10/08/20 10:31 AM
    @Dariusz Danielewski

    Thank You  For the update , the APAR bug above is 11.1.3 , you mean still it dont fix in 11.1.7 .?

    Thanks

    ------------------------------
    Chandra Medarametla
    ------------------------------



  • 5.  RE: cA11.1.7Excel Formatting

    Posted 10/08/20 10:32 AM
    Dunno, Chandra. That's what IBM Support is for. They will be able to test and let you know if it came back.

    ------------------------------
    Dariusz Danielewski
    ------------------------------



  • 6.  RE: cA11.1.7Excel Formatting

    Posted 10/10/20 05:06 PM
    @Dariusz Danielewski ​ - Thanks you . Let me know once tested , mean we will open a case

    ------------------------------
    Chandra Medarametla
    ------------------------------