Activity: Import Data into FP&A Model LVL2 Conclusion

JosAngel94 · 2023-03-08T16:26:56+00:00

There was an error rendering this rich post.

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

AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…
Using time for something not time related - special characters :)$
We had a recent challenge with the need to "clean" invoice data descriptions from special characters. This was done previously in SQL with the a long convoluted formula "REPLACE(REPLACE(REPLACE('Ana&plan', '&', '') that would have to edited by a developer in case any new special characters came through. Using the replace…