Activity: Import Data into FP&A Model LVL2 Conclusion

I am trying to import the information from the INV05 Module but get items failing.

This is my save view, how do i make for the G3 location list only show me the lowest level of information without the country and region?

Thanks in advance

Accepted answers

You need to right click on “New York” and from the resulting dropdown you need to select

“Select Levels to Show”
From there uncheck all the parent levels and show only bottom level. Then re-save the view

Hope, this resolves your issue.

Happy to see that your earlier issue is resolved.

For this new view, you'll have to do the below steps:

Right click on New York and select lowest level in “Select level to show”
Right click on Nutzo Bar_EN and select lowest level in “Select level to show”
For time filter, you need to create a system module with time dimension and insert a boolean line item called “Months?” . Apply formula = TRUE in that line item
Then in your view, click on filter from the top, and select this line item from the sys module.

Hope, above steps helps

You need to right click on “New York” and from the resulting dropdown you need to select

“Select Levels to Show”
From there uncheck all the parent levels and show only bottom level. Then re-save the view

Hope, this resolves your issue.

TY that helped

Now on the module DEM04 I have the following.

Tried to do the same steps as for the commets before but it doesn´t give me the option to only show the lower level

Happy to see that your earlier issue is resolved.

For this new view, you'll have to do the below steps:

Right click on New York and select lowest level in “Select level to show”
Right click on Nutzo Bar_EN and select lowest level in “Select level to show”
For time filter, you need to create a system module with time dimension and insert a boolean line item called “Months?” . Apply formula = TRUE in that line item
Then in your view, click on filter from the top, and select this line item from the sys module.

Hope, above steps helps

Poll: Should I have a single model or two separate models?
Hi Anaplanners, I am hoping to collect some feedbacks from you on an ongoing discussion I've been having with my stakeholders. My organization currently have 1 TQP model, which is focused on keep the model small and agile, and quick enough for about 200 managers to use to plan out their territories within a 5 weeks…
Need Help: Import Updates Only Specific Combinations Without Erasing Others
Hi Anaplan Community, I'm facing an issue while importing data (text details) into a module that has two dimensions: "Unique Line ID" and "Organization x Site". The source file is based on a numbered list. It includes text-formatted columns (line items) that contain the names of the "Unique Line ID" and "Organization x…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…