Cognos Analytics with Watson

 View Only
Expand all | Collapse all

The data item... contains an operation across 2 fact streams and involves detail items.

  • 1.  The data item... contains an operation across 2 fact streams and involves detail items.

    Posted Thu June 09, 2022 05:04 PM
    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
    ------------------------------


  • 2.  RE: The data item... contains an operation across 2 fact streams and involves detail items.

    Posted Fri June 10, 2022 07:08 PM
    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/
    ------------------------------



  • 3.  RE: The data item... contains an operation across 2 fact streams and involves detail items.

    Posted Mon June 13, 2022 03:57 PM
    Well how do you do!
    Thanks Jeam - that did it.

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