Birst Summarization Issue

Chai Chang

I am having a weird summarization with 3 lines that are the same serial number, but the record key "Trailer Numeric Sequence" is different. All 3 lines have different status, which is Complete, Invoiced, and Cancelled. In my Birst report, I have the Selling Price analyzed by Invoiced Date. Shouldn't it only summarized the one with that invoiced date or status? Yet, it's summarizing all 3 lines altogether.

Here's an example. Since it is analyzed by Invoice Date and even if I filtered by the status = I, its's still showing the -395,355.13. These fields are all from the same dataset.

So I looked at the published data and found that it's tripling each line 3 times and also other lines are having the same affect, and explained why it's tripling the data.

In the Scripted Source, I do have it delete, so not sure why it's duplicating the same data. Any ideas on what else I can do?

Diane McElhiney

There are many questions that you need to answer for the proper direction. We need to determine how the data is modeled and processed.

What is your source of this information, Infor Data Lake or non-Infor data? What is the SQL in the Query-Based Object? Is the QBO SELECT only one object, or is there a join that could produce a Cartesian join?

By viewing the View Published Data for Trailer Master Scripted Source, the data output could be from a Cartesian join in the script. Supply the text from the SELECT and the Script sections of this Scripted Source.

What is your Source and Transaction Policy in Source Properties?