PlanIQ - failure to add Attributes in Forecast Model

Hi Community,

When in PlanIQ I run a Data Collection that contains historical data and attributes, the Data Collection fails. I receive an error message saying that attributes don't include all items in historical data (screenshot attached), which is not true, because I use exactly the same list of items in both historicals and attributes. What could be the reason for that issue?

planiq_error_message_119016.PNG

Historicals&Attributes_Export_Views_119016.png

Tags

Importing and Exporting Data

PlanIQ

Data Integration

Accepted answers

All comments

Are all the attributes text formatted?

Also 0's in historical data - you may want to remove outliers if they are not actual zeros

Yes, all attributes are text-formatted.

The zeroes in historical data are true zeroes, indicating that zero items was sold on a given day .

Thanks,

Maciej

And in your export action have you enabled "Row label headers"?

Yes, I did. I use code as an identifier (same as in the export of historical data).

attributes_export_119021.PNG

Could you please share the Data Collection Window for Historical data as well as Attributes data?

Hope export is in .csv format

Hope there is nothing in related data.

Attached are screenshots of Properties of the Data Collection. Is that what you ask for?

There is no Related Data in this collection.

historical_data_collection_119023.PNG

attributes_data_collection_119023.PNG

As far as I know there should be start date & end date ranges here

Well, when I include historical data only, a Data Collection is succesful, and the time/date range is there.

But when I include also Attributes, data collection fails and there is no time/date range information.

Regards,

Maciej

I think that is the problem. Your timescale is not identified by PLANIQ.

Also make sure that the number of line items in Attributes module do not go more than 10

Misbah

My timescale of historical data is correctly identified when no attributes are included in the data collection... The problem occurs when Attributes are added (and the attributes do not have timescale, so i don't see where my timescale is incorrrect).

What an akward issue. Thank you for your help anyway.

Yes, with the limited amount of resources and training materials available I feel you may have to recreate the Data collection once again.

We know where the error is , it's just that we don't know where to look for in order to rectify it. I would highly recommend keeping the attributes <=5, although it can go up to 10.

Hope that helps

Misbah

I took a look through everything you've posted and don't have an immediate solution at the top of my head.

Have you submitted a support request via clicking the "..." next to the data collection and clicking "Email Support"?

Tim

Hi @timothybrennan ,

Thank you for your response. Yes, I submitted a support request a few days ago, but the problem was not resolved, so I still seek for help.

Do you have any examples or experience with any set of attributes that were succesfully added to data collection? Maybe such a blueprint could serve as an inspiration. I made numerous attempts to set up the attributes, but it always ends with a collection failure.

Kind Regards,

Maciej

Hi,

I'm getting the same error message, but both lists are the exact same. Would also like to know what could cause this.

Thanks!

I messed around with my data collection, and I finally made it work.

The change that made this error go away was adding a letter to the codes of my Item Unique Identifier list, which only contained numbers previously. For example, I changed my codes from being 6010125204 to A6010125204.

Is it possible that the error came from the fact that PlanIQ would read my item ID as 6.01E+09 instead of 6010125204 because of the .csv export? Adding a letter forced the .csv file to display the whole string.

@timothybrennan Let me know what you think.

Quick Links

Can you help?

Unanswered questions

Add list members to a selective access list
Hi, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all list…
Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?