Add a Dimension in Forecasting PlanIQ

Hi,

I want to use PlanIQ to forecast the demand of different products over time. I've managed to do so on PlanIQ, but now I would like to be able to forecast the demand of different products, over different countries.

Every product exists in every country, and I would like to predict the demand. Therefore what I wanted to do was to add a dimension "Country" in the modules Historical Data, Related Data, and also in the Results Data. I tried it but then when I ran the PlanIQ Forecast Action, an error told me "P1: 0 Cell", I guess it is because PlanIQ doesn't support when modules have another dimension apart from the useful original ones...

Would you see another option/solution to it? Thanks !!

Accepted answers

All comments

StevenBeerthuizen

Hi Vanessa,

As far as I know from when I was able to play around with PlanIQ you indeed cannot add a dimension to your set. So to solve this you would need to make a flat list with all the combinations and use that. But again, it's been a while since I used PlanIQ.

Kind regards,

Steven

Legend001

Hello , vanessahan

When using PlanIQ to forecast the demand of different products over time, it is important to consider the supported dimensions within the modules. If you encounter an error like "P1: 0 Cell" when adding an additional dimension such as "Country," it indicates that PlanIQ may not support multiple dimensions in those particular modules. In such cases, here are a couple of alternative options/solutions you can explore: Aggregating Data: Instead of adding the "Country" dimension to the modules directly, you can aggregate the demand data by country beforehand. This means you would calculate the total demand for each product in each country and then provide the aggregated data to PlanIQ without the "Country" dimension. This way, you can still capture the demand variations across countries but within a single dimension. Separate Forecasts: Another approach is to create separate forecasts for each country. You can run PlanIQ forecasts separately for each country, using the historical data and related data specific to that country. This way, you can generate country-specific demand forecasts and analyze them individually. Both approaches have their pros and cons, so it's important to consider your specific requirements and constraints when deciding which option to pursue. You may also want to consult with the PlanIQ documentation or support team to confirm the supported dimensions and explore any potential workarounds specific to your use case. I hope this provides you with some alternative options to forecast the demand of different products over different countries using PlanIQ. If you have any further questions or need additional assistance, please feel free to ask. My CC Pay Log in

Best regards, [ Legend ]

andrew12

You can make different forecasting models for every country if you want to keep the level of granularity you want. Create distinct models in PlanIQ for every nation and product combination. With this method, you may adjust the forecasting settings and parameters based on the unique traits and demand trends of each nation.

Forrinfort

you need to first prepare your Anaplan model, then configure PlanIQ, and finally, run the forecast and embed the results.

Summit County Auditors

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…
Exports with anaplan using informatica connector
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…