Cognos Analytics

 View Only
  • 1.  Changing the Data Type in 11.0.13.1

    Posted Thu March 07, 2019 04:28 PM
    Hello,
    How can the data type be changed from from decimal to %? The properties appear to be set to decimal.

    Thank you


    Data format

    Decimal

    ------------------------------
    KEVIN BIDGOOD
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Changing the Data Type in 11.0.13.1

    Posted Thu March 07, 2019 07:01 PM

    Hey Kevin,

    Is this an uploaded file you will need to create a data module off of the uploaded file to create your percent calculation.



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



  • 3.  RE: Changing the Data Type in 11.0.13.1

    Posted Fri March 08, 2019 10:38 AM
    Hello Denny,

    This is all I see when I click on "New". There is no option for Data Module.

    New

    ------------------------------
    KEVIN BIDGOOD
    ------------------------------



  • 4.  RE: Changing the Data Type in 11.0.13.1

    Posted Fri March 08, 2019 11:03 AM
    Edited by System Fri January 20, 2023 04:47 PM
      |   view attached
    I would guess that you do not have correct permissions to use Data Modules. I would suggest checking with your Cognos sys admin to review your permissions or have a data modeler build the data module for you. Alternatively, you can create a custom calculation in the dashboard to create your percent calculation.

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



  • 5.  RE: Changing the Data Type in 11.0.13.1

    Posted Sat March 09, 2019 02:21 PM
    Hi Kevin,

    Please find the below attached visualizations..

    1) Select particular visualization go for properties and change the property of value label format from value to Percentage of Category.

    image.png



    image.png

    Thanks and Regards,
    Siva Bonu
    +919560388664






  • 6.  RE: Changing the Data Type in 11.0.13.1

    Posted Mon March 11, 2019 10:25 AM
    Hi Siva,

    I don't think this works for a cross tab report. But I was able to get a % by using a calculation. 

    Thank you.

    ------------------------------
    KEVIN BIDGOOD
    ------------------------------



  • 7.  RE: Changing the Data Type in 11.0.13.1

    Posted Sat March 09, 2019 02:25 PM
    Hi Kevin,
    Please find the below attached visualizations..
    1) Select particular visualization go for properties and change the property of value label format from value to Percentage of Category.

    Decimal Values Image:
    Decimal values showing
     
    % Values Image :
    % values
    Thanks and Regards,
    Siva Bonu
    +919560388664


    ------------------------------
    Siva Bonu
    +919560388664
    ------------------------------