Cognos Analytics

Two Fact tables ([Request], [Response]).
[Response] has nonconformed dimension ([Response Type])
Created stand alone calculation [Request Count] from the Request table.
Created stand alone calculation [Response Count] from the Response table.
Created calculation in Dashboard [Response Rate] = [Response Count] / [Request Count] - this is working fine across all dimensions. 
Creating the same calculation in FM as stand alone calculation validates without issue in FM and test returns expected result.
However, adding the stand alone calculation to the dashboard fails with "The data item [query].[id_1226029894] contains an operation across 2 fact streams and involves detail items. Please ensure that each term is aggregated before the operation is applied."
The aggregation for the stand alone calculation has been tested as both Automatic and Calculated.

Any thoughts on why this calculation works when created in a dashboard but not in FM?

------------------------------
David
------------------------------

#CognosAnalyticswithWatson

Hi,

Are you using DQM package?

Did you try creating formula like total([Response Count]) / total([Request Count]) ? And then setting aggregation to Calculated.

------------------------------
JEAM COELHO
Cognos Solution Architect

LinkedIn: https://www.linkedin.com/in/jeamcoelho/
------------------------------

Original Message:
Sent: Thu June 09, 2022 05:04 PM
From: David Hill
Subject: The data item... contains an operation across 2 fact streams and involves detail items.

Two Fact tables ([Request], [Response]).
[Response] has nonconformed dimension ([Response Type])
Created stand alone calculation [Request Count] from the Request table.
Created stand alone calculation [Response Count] from the Response table.
Created calculation in Dashboard [Response Rate] = [Response Count] / [Request Count] - this is working fine across all dimensions. 
Creating the same calculation in FM as stand alone calculation validates without issue in FM and test returns expected result.
However, adding the stand alone calculation to the dashboard fails with "The data item [query].[id_1226029894] contains an operation across 2 fact streams and involves detail items. Please ensure that each term is aggregated before the operation is applied."
The aggregation for the stand alone calculation has been tested as both Automatic and Calculated.

Any thoughts on why this calculation works when created in a dashboard but not in FM?

------------------------------
David
------------------------------

#CognosAnalyticswithWatson

Well how do you do!
Thanks Jeam - that did it.

------------------------------
David
------------------------------

Original Message:
Sent: Fri June 10, 2022 07:08 PM
From: JEAM COELHO
Subject: The data item... contains an operation across 2 fact streams and involves detail items.

Hi,

Are you using DQM package?

Did you try creating formula like total([Response Count]) / total([Request Count]) ? And then setting aggregation to Calculated.

------------------------------
JEAM COELHO
Cognos Solution Architect

LinkedIn: https://www.linkedin.com/in/jeamcoelho/

Original Message:
Sent: Thu June 09, 2022 05:04 PM
From: David Hill
Subject: The data item... contains an operation across 2 fact streams and involves detail items.

Two Fact tables ([Request], [Response]).
[Response] has nonconformed dimension ([Response Type])
Created stand alone calculation [Request Count] from the Request table.
Created stand alone calculation [Response Count] from the Response table.
Created calculation in Dashboard [Response Rate] = [Response Count] / [Request Count] - this is working fine across all dimensions. 
Creating the same calculation in FM as stand alone calculation validates without issue in FM and test returns expected result.
However, adding the stand alone calculation to the dashboard fails with "The data item [query].[id_1226029894] contains an operation across 2 fact streams and involves detail items. Please ensure that each term is aggregated before the operation is applied."
The aggregation for the stand alone calculation has been tested as both Automatic and Calculated.

Any thoughts on why this calculation works when created in a dashboard but not in FM?

------------------------------
David
------------------------------

#CognosAnalyticswithWatson