Data Ingestion

Reports

• Data Ingestion

  A bar chart that shows counts per fact table. Counts are aggregated across all companies.

• Data Ingestion Details

  Displays counts per fact table per company, which can be compared to data in LN.

Filter

• Company. Default is the company in the LN user data.
• LN Analytics Product

Data ingestion reports are available per LN Analytics Product, showing related fact counts. You can switch between data ingestion reports using this filter.

The fact counts for LN Analytics Product Foundation are retrieved from these main tables in LN:

Count	LN table	Compare in LN
Opportunity	tdsmi110	Opportunities (tdsmi1110m000). Do not select Open Opportunities Only. Do not select My Opportunities Only.
Opportunity Item	tdsmi113
Sales Contract Line	tdsls301	Sales Contracts (tdsls8330m000) Contract Lines tab. Show All.
Sales Order Line	tdsls401	Sales Order Fulfillment Workbench (tdsls4601m100). Include Already Delivered Lines. Do not Include Total lines.
Sales Schedule Line Plan	tdsls307	Sales Schedules (tdsls3611m100). Schedule Lines tab. Show All. Filter on Requirement Type = Planned. Count lines that do not have status Canceled, Canceling in Process, Replaced or Replacing in Process.
Sales Schedule Line Actual	tdsls307	Sales Schedules (tdsls3611m100). Show All. Count records on Schedule Lines tab with filter on Requirement Type <> Planned Count records on Pick-up Sheets tab. Count records on Sequenced Schedules tab. For each tab: Count lines that do not have status Canceled, Canceling in Process, Replaced or Replacing in Process.
Production Order	tisfc001	Production Orders (tisfc0501m000)
Production Operation	tisfc010 ticst002
Production Material	ticst001
Production Total Cost	ticst010
Purchase Contract Line	tdpur301	Purchase Contracts (tdpur8330m000) Contract Lines tab. Show All.
Purchase Order Line	tdpur401	Purchase Order Fulfillment Workbench (tdpur4601m300). Include Already Received Lines. Do not Include Total lines.
Purchase Schedule Line Plan	tdpur311	Purchase Schedules (tdpur3610m100). Show All. Schedule Lines tab. Filter on Requirement Type = Planned. Count lines that do not have status Canceled.
Purchase Schedule Line Actual	tdpur311	Purchase Schedules (tdpur3610m100). Show All. Count records on Schedule Lines tab with filter on Requirement Type <> Planned. Count lines that do not have status Canceled.
Financial Balance	tfgld205
Service Warranty Transaction	tsctm501
Service Contract Quote	tsctm200	Contract Quotes (tsctm2100m000)
Service Contract Change	tsctm320
Service Configuration Line	tsctm110
Service Coverage Term	tsctm120
Service Coverage Term Line	tsctm130 tsctm131 tsctm132 tsctm135 tsctm136 tsctm139
Service Contract Cost	tsctm480
Service Contract Revenue	tsctm400 tsctm450 tsctm480
Service Fixed Price Term	tsctm111
Service Quote	tsepp100	Quotes (tsepp100m000)
Service Quote Line	tsepp110
Service Quote Cost Line	tsepp120
Service Call	tsclm100	Call Overview (tsclm1509m000)
Service Probability Analysis	tsclm350	Service Resolution - Probability Analysis
Service Failure Analysis	tsclm370 tsclm400
Service Order	tssoc200	Service Orders (tssoc2100m000)
Service Order Activity	tssoc210
Service Engineer Assignment	tssoc205	Service Engineer Assignments (tssoc2505m000). Filter on Origin = Service Order.
Service Depot Repair Item Line	tsmsc110	Maintenance Sales Order Item Lines
Work Order	tswcs200	Work Orders (tswcs2100m000)
Work Order Activity	tswcs210
Work Order Repair Cost	tswcs440
Customer Claim Line	tscmm110	Customer Claim (tscmm1600m100). Count all for Customer Claim Lines.
Supplier Claim Line	tscmm210	Supplier Claim (tscmm2600m100). Count all for Supplier Claim Lines.
Service Rental Equipment Calendar	tscfg262
Accounts Receivable	tfacr200

The fact counts and main tables for the LN Analytics Products Program Cost Ledger and Quality Management are described in the related user guides.

To retrieve LN counts, you can start the sessions mentioned in the previous table. Alternatively, you can complete these steps:

1. In LN, navigate to Tools > Integration Tools > Data Publishing Management.
2. Start the Publish Data (ttdpm5205m000) session.
3. Select the All Data Sets option.
4. Select the Publish Initial Load option for all companies, and specify package, module and table for the main source tables listed above.
5. Select the Count option and click Publish.
6. Inspect the log file, using the view button.
7. The current counts per table per company are displayed, which you can compare with the data ingestion detail report.