Level 1 Model Builder 12.4.6 Filtering Help

Hi,

Level 1 Model Building 12.4.6

In the unfiltered view for EMP02 Employee Expenses I get the year FY total. But when I added the filter "Forecast Months Only" the FY year totals disappear. I would imagine that is how it should be. Since the filter is "Forecast Months Only."

However, according to the course requirements we are supposed to match the screenshot they have pasted which shows year totals.

What am I doing wrong?

Appreciate all help.

Thanks

Jacob

Filter_Details_118284.jpg

Filtered_for_Forecast_Months_118284.jpg

No_Filter_View_118284.jpg

Screenshot_per_Model_Builder_Course_118284.jpg

Accepted answers

andre.lie

Hi @Jacob3 , the Applies To of your EMP02 module is the full E2 Employees# list. Hence, you cannot see the subset in the Pivot. Pivot will not show the subset even though the list has a subset if the subset is not used as part of the module lists. Please double check the instructions for creating EMP02 module activity whether the module should use full list or subset. If so, go to the Blueprint and change the E2 Employees# in the Applies To to the E2 Employees#.Active? subset.

Andre

All comments

Jacob3

Hi,

In the pivot table I could not find E2 Employees#: Active?. I only have E2 Employees#

Looks like I messed up somewhere.

Please see attached screenshot.

Thanks

Jacob

E2_Employees_-_Active_118285.jpg

andre.lie

Hi @Jacob3 ,

I do not think there is anything wrong with your filtered view. The screenshot in the course material might be incorrect.

E2 Employees#: Active? is a subset. You might have missed the activity that requires you to load an employee file to create and update that subset.

Regards,

Andre

Jacob3

Thanks Andre. I checked the model. The subset was created. I am wondering whether the mistake in one of the areas I have pointed out in the screenshot attached.

Jacob

E2_Employees-_Active_Subset_118380.jpg

Modules_118380.jpg

andre.lie

Andre

Jacob3

Thanks you @andre.lie . I saw this during the modeling time but did not understand what the requirement was. In my opinion there seems to be a bit of ambiguity in the course work guidance in this situation. Please see attached screen shot.

They ask to create a Dimension - E2 Employees# list, Active? list subset. Instead if they had said create Dimension - E2 Employees#: Active? list it would be crystal clear.

Appreciate your help.

Jacob

Dimensions_Ambiguity_118424.jpg

Jacob3

@andre.lie I forgot to mention I did make the change as you suggested and this fixed the issue I was facing in the pivot view. I could see E2 Employee#: Active? after the change

Quick Links

Can you help?

Unanswered questions

OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385