INFOR BI Dashboard Issue

[vip1982]

Hello Everyone,

I would appreciate your support into the issue below, INFOR till now didnt solve it for us.

We have installed the following:

1) Infor Business Vault Enterprise Edition 11.3.2
2) Infor BI OLAP Server (64 bit) 11.0.0.365
3) Infor LN Analytics Foundation 10.5.2

We are using Infor LN FP9.

We have 2 companies: 222 and 333.

Company 222 has common Master data in it which is shared with company 333.

We have published all the data referring the document "Infor_LN_Integration_Guide_for_Infor_LN_Analytics_Foundation".

But when we see the Sales Overview screen from LN Analytics Foundation, we see "Customer reference missing", "Customer reference invalid" etc in report "Top 10 Customers".

We see "Item reference missing" in report "Top 10 Items",
"Employee reference missing" in report "Top 10 Sales Representative"

Please refer the attached screenshot.

Please tell me if someone can have an idea about this?

Thank You,

[kpramod.v]

Hi vip1982,

Reference missing is nothing but if you don't mention any customer,employee and item in the sales order then those orders will come under respective customer reference missing, item reference missing and employee reference missing.

Regards
Rajini.P

[ARijke]

The invalid reference means that the underlying order/invoice has a customer code but the master data is not known at the BI side. (re)Publishing the missing one or just all customers should resolve this issue.
The reference missing means that the underlying order/invoice does not have a customer or item code attached to it. This is not wrong it is just a fact. Sometimes this is just how LN works in certain cases. Sometimes you could resolve this in LN by maintaining more data, like give each sales order a sales representative.
Adriaan