Cognos Analytics

​Hi Team,

While working on C11 Dashboard using Crosstab/List we are facing issue summary level %(calculation) values not showing . we are getting value N/A. could you please help me on the same.

Below are details with screenshot for your reference.
Cognos Version: 11.0.11
Dash board using  Crosstab
Calculation logic for % New column : ([Sales (query)].[Sales fact].[Quantity] / ([Sales (query)].[Sales fact].[Revenue] * 100))
Sample screenshot:

Thanks & Regards,
Venkat SubbaReddy

------------------------------
Thanks & Regards,
Venkata Subba Reddy.
SMS SR CoE, Report Specialist.
------------------------------

#CognosAnalyticswithWatson

Same problem here, anyone?
The same applied if the measure is calculated in the cube package.

------------------------------
Dagur Egonsson
------------------------------

Original Message:
Sent: Thu December 27, 2018 03:05 AM
From: Venkat SubbaReddy
Subject: C11 DashBoard Crosstab Summary level % values not showing

​Hi Team,

While working on C11 Dashboard using Crosstab/List we are facing issue summary level %(calculation) values not showing . we are getting value N/A. could you please help me on the same.

Below are details with screenshot for your reference.
Cognos Version: 11.0.11
Dash board using  Crosstab
Calculation logic for % New column : ([Sales (query)].[Sales fact].[Quantity] / ([Sales (query)].[Sales fact].[Revenue] * 100))
Sample screenshot:

Thanks & Regards,
Venkat SubbaReddy

------------------------------
Thanks & Regards,
Venkata Subba Reddy.
SMS SR CoE, Report Specialist.
------------------------------

#CognosAnalyticswithWatson

​We ran into the same problem with percentages in v11.0.8.  The message explanation we received from IBM was "The crosstab in dashboards do not currently support summaries for calculations with certain aggregation types. It is on the roadmap to resolve this issue which is currently targeted for later this year." 

The issue was resolved in v11.1.x.

------------------------------
Missy Miller
BI Analyst
ND Information Technology Department
Bismarck ND
7013284307
------------------------------

Original Message:
Sent: Thu December 27, 2018 03:05 AM
From: Venkat SubbaReddy
Subject: C11 DashBoard Crosstab Summary level % values not showing

​Hi Team,

While working on C11 Dashboard using Crosstab/List we are facing issue summary level %(calculation) values not showing . we are getting value N/A. could you please help me on the same.

Below are details with screenshot for your reference.
Cognos Version: 11.0.11
Dash board using  Crosstab
Calculation logic for % New column : ([Sales (query)].[Sales fact].[Quantity] / ([Sales (query)].[Sales fact].[Revenue] * 100))
Sample screenshot:

Thanks & Regards,
Venkat SubbaReddy

------------------------------
Thanks & Regards,
Venkata Subba Reddy.
SMS SR CoE, Report Specialist.
------------------------------

#CognosAnalyticswithWatson

We are on v11.1 R1.
In which release was this solved?


------------------------------
Dagur Egonsson
------------------------------

Original Message:
Sent: Mon July 08, 2019 03:34 PM
From: Missy Miller
Subject: C11 DashBoard Crosstab Summary level % values not showing

​We ran into the same problem with percentages in v11.0.8.  The message explanation we received from IBM was "The crosstab in dashboards do not currently support summaries for calculations with certain aggregation types. It is on the roadmap to resolve this issue which is currently targeted for later this year." 

The issue was resolved in v11.1.x.

------------------------------
Missy Miller
BI Analyst
ND Information Technology Department
Bismarck ND
7013284307

Original Message:
Sent: Thu December 27, 2018 03:05 AM
From: Venkat SubbaReddy
Subject: C11 DashBoard Crosstab Summary level % values not showing

​Hi Team,

While working on C11 Dashboard using Crosstab/List we are facing issue summary level %(calculation) values not showing . we are getting value N/A. could you please help me on the same.

Below are details with screenshot for your reference.
Cognos Version: 11.0.11
Dash board using  Crosstab
Calculation logic for % New column : ([Sales (query)].[Sales fact].[Quantity] / ([Sales (query)].[Sales fact].[Revenue] * 100))
Sample screenshot:

Thanks & Regards,
Venkat SubbaReddy

------------------------------
Thanks & Regards,
Venkata Subba Reddy.
SMS SR CoE, Report Specialist.
------------------------------

#CognosAnalyticswithWatson

It should be there in R1 although you get more useful results starting in R2. 

R2 also has the calculate after aggregation setting, which allows you to have a bit more control over how and when things are aggregated and, if you are using a multi-fact query, allows you to execute the query.

------------------------------
IAN HENDERSON
------------------------------

Original Message:
Sent: Tue July 09, 2019 06:25 AM
From: Dagur Egonsson
Subject: C11 DashBoard Crosstab Summary level % values not showing

We are on v11.1 R1.
In which release was this solved?


------------------------------
Dagur Egonsson

Original Message:
Sent: Mon July 08, 2019 03:34 PM
From: Missy Miller
Subject: C11 DashBoard Crosstab Summary level % values not showing

​We ran into the same problem with percentages in v11.0.8.  The message explanation we received from IBM was "The crosstab in dashboards do not currently support summaries for calculations with certain aggregation types. It is on the roadmap to resolve this issue which is currently targeted for later this year." 

The issue was resolved in v11.1.x.

------------------------------
Missy Miller
BI Analyst
ND Information Technology Department
Bismarck ND
7013284307

Original Message:
Sent: Thu December 27, 2018 03:05 AM
From: Venkat SubbaReddy
Subject: C11 DashBoard Crosstab Summary level % values not showing

​Hi Team,

While working on C11 Dashboard using Crosstab/List we are facing issue summary level %(calculation) values not showing . we are getting value N/A. could you please help me on the same.

Below are details with screenshot for your reference.
Cognos Version: 11.0.11
Dash board using  Crosstab
Calculation logic for % New column : ([Sales (query)].[Sales fact].[Quantity] / ([Sales (query)].[Sales fact].[Revenue] * 100))
Sample screenshot:

Thanks & Regards,
Venkat SubbaReddy

------------------------------
Thanks & Regards,
Venkata Subba Reddy.
SMS SR CoE, Report Specialist.
------------------------------

#CognosAnalyticswithWatson

We are now on 11.1 R3 but still we get N/A in the calculated columns !



------------------------------
Dagur Egonsson
------------------------------

Original Message:
Sent: Tue July 09, 2019 08:10 AM
From: IAN HENDERSON
Subject: C11 DashBoard Crosstab Summary level % values not showing

It should be there in R1 although you get more useful results starting in R2. 

R2 also has the calculate after aggregation setting, which allows you to have a bit more control over how and when things are aggregated and, if you are using a multi-fact query, allows you to execute the query.

------------------------------
IAN HENDERSON

Original Message:
Sent: Tue July 09, 2019 06:25 AM
From: Dagur Egonsson
Subject: C11 DashBoard Crosstab Summary level % values not showing

We are on v11.1 R1.
In which release was this solved?


------------------------------
Dagur Egonsson

Original Message:
Sent: Mon July 08, 2019 03:34 PM
From: Missy Miller
Subject: C11 DashBoard Crosstab Summary level % values not showing

​We ran into the same problem with percentages in v11.0.8.  The message explanation we received from IBM was "The crosstab in dashboards do not currently support summaries for calculations with certain aggregation types. It is on the roadmap to resolve this issue which is currently targeted for later this year." 

The issue was resolved in v11.1.x.

------------------------------
Missy Miller
BI Analyst
ND Information Technology Department
Bismarck ND
7013284307

Original Message:
Sent: Thu December 27, 2018 03:05 AM
From: Venkat SubbaReddy
Subject: C11 DashBoard Crosstab Summary level % values not showing

​Hi Team,

While working on C11 Dashboard using Crosstab/List we are facing issue summary level %(calculation) values not showing . we are getting value N/A. could you please help me on the same.

Below are details with screenshot for your reference.
Cognos Version: 11.0.11
Dash board using  Crosstab
Calculation logic for % New column : ([Sales (query)].[Sales fact].[Quantity] / ([Sales (query)].[Sales fact].[Revenue] * 100))
Sample screenshot:

Thanks & Regards,
Venkat SubbaReddy

------------------------------
Thanks & Regards,
Venkata Subba Reddy.
SMS SR CoE, Report Specialist.
------------------------------

#CognosAnalyticswithWatson

Hi,

We ran into the same problem with percentages in R7. Did any one found the solution?

------------------------------
JAGADEESH B S
------------------------------

Original Message:
Sent: Thu December 27, 2018 03:05 AM
From: Venkat SubbaReddy
Subject: C11 DashBoard Crosstab Summary level % values not showing

​Hi Team,

While working on C11 Dashboard using Crosstab/List we are facing issue summary level %(calculation) values not showing . we are getting value N/A. could you please help me on the same.

Below are details with screenshot for your reference.
Cognos Version: 11.0.11
Dash board using  Crosstab
Calculation logic for % New column : ([Sales (query)].[Sales fact].[Quantity] / ([Sales (query)].[Sales fact].[Revenue] * 100))
Sample screenshot:

Thanks & Regards,
Venkat SubbaReddy

------------------------------
Thanks & Regards,
Venkata Subba Reddy.
SMS SR CoE, Report Specialist.
------------------------------

#CognosAnalyticswithWatson