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

How do i build a ragged hierarchy?
I have my dataset attached below
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?