Cognos Analytics

 View Only
Expand all | Collapse all

Cognos Analytics 11.11 Dashboard decimal places

  • 1.  Cognos Analytics 11.11 Dashboard decimal places

    Posted Wed April 17, 2019 03:24 PM
    ​I have a table that (in framework) that has a calculated field (Average Fees) which takes the sum 2 columns and divides them.  The calculations are correct in the table.  I see I have 8 decimal places (exactly what I need for basis points).  However, when I pull the table into the dashboard via a 'Dataset' the decimal places are lost.  I can format the avg fees field to ###.##, but that doesn't help.  I have tried to cast as decimal with no luck.

    Any thoughts?​

    ------------------------------
    Jenifer Broughton
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Cognos Analytics 11.11 Dashboard decimal places

    Posted Tue April 23, 2019 09:27 AM
    Hello @Jenifer Broughton ​

    To help narrow down the issue, could you test the following:
    1. Using the package and not the data set, do you see the same issue in the dashboard?
    2. Could you try the data set in a report? Do you see the same issue?

    I will also working on seeing if I can create something similar using the Cognos Samples

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

    Original Message


  • 3.  RE: Cognos Analytics 11.11 Dashboard decimal places

    Posted Wed April 24, 2019 06:21 AM
    ​Thank you for the reply.

    If I view the dataset, I can see all the decimal places.
    If I create a report, I can see all the decimal places.




    ------------------------------
    Jenifer Broughton
    ------------------------------

    Original Message


  • 4.  RE: Cognos Analytics 11.11 Dashboard decimal places

    Posted Wed April 24, 2019 06:49 AM
    Hi,
    Could you please any screenshot for the same..
    Actually i am not getting any error. I have used calculated fields in reports and as well in dashboards in C11.0.12

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

    Original Message


  • 5.  RE: Cognos Analytics 11.11 Dashboard decimal places

    Posted Wed April 24, 2019 08:34 AM
    Edited by System Test Fri January 20, 2023 04:19 PM

    @Jenifer Broughton - Using Cognos Analytics 11.1.1 - If you apply data formatting to the Average Fees column you can control the number of decimal places that is displayed.

    In the Dashboard on the source panel select the Average Fees column and click on the 3 dots and click Data Format. Next, select Number or Currency and here is where you can specify the number of decimal places to be displayed.

    ​



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

    Original Message


  • 6.  RE: Cognos Analytics 11.11 Dashboard decimal places

    Posted Wed April 24, 2019 08:45 AM
    Hi,

    Kindly find the below screenshots for Dashboards.

    Step 1: Select on particular visualization.



    Step 2 : Right Click on it and click on format



    Step 3 :Select on required format instead of Auto.





    Original Message


  • 7.  RE: Cognos Analytics 11.11 Dashboard decimal places

    Posted Wed April 24, 2019 12:54 PM
    ​Hello,

    I'm using  IBM Cognos Analytics 11.0.11 which does not have the 'Data Format' property option, unfortunately.  I have also tried to 'format' the Avg Fees' as well and that does not work.  An example of my fees would be .00023563.

    ------------------------------
    Jenifer Broughton
    ------------------------------

    Original Message


  • 8.  RE: Cognos Analytics 11.11 Dashboard decimal places

    Posted Wed April 24, 2019 01:05 PM
    Hi Jenifer,
    I did the operation via a cast as follows:
    cast (cast ([QUANTITY] / [EXTENDED_PRICE_AMT] , decimal(18,4)), varchar(30))
    It gives output like:


    What did your expression with cast look like?
    // Henk

    ------------------------------
    HENK CAZEMIER
    ------------------------------

    Original Message


  • 9.  RE: Cognos Analytics 11.11 Dashboard decimal places

    Posted Thu April 25, 2019 02:18 AM
    Hi,

    Step 1:

    Drag particular calculated data item into Visualization on dashboard. 



    Step 2 : Select on the visualization and expend it 





    Step 3 :  Click on format option and select on desired format










    Original Message


  • 10.  RE: Cognos Analytics 11.11 Dashboard decimal places

    Posted Thu April 25, 2019 06:37 AM
    ​I am on version 11.11. 

    Siva,  thanks for your input - I am not getting an error of any kind.  I have also tried to set the format of the Avg Fees but it doesn't work.

    Denny , thanks for your input,   I'm on 11.11 so I do not have the new properties feature related to the measures.  That will be a nice one to have!

    I've tried to cast the avg fees in the view, which works fine when you create a report, even if I open a dataset created against the view I see all the decimal places.  It's just when I use the dataset in the dashboard, I do not see the decimal places and since all the Avg Fees (basis points) are like .0001234 , .002345 (examples)
    The axis on the graph is 0 to 1 and to 'show the values on the bars it shows 0.00.  So not useful.

    ------------------------------
    Jenifer Broughton
    ------------------------------

    Original Message