Why Subsidery view is not getting applied as filter

Parul369257 · 2023-11-20T06:51:52+00:00

There was an error rendering this rich post.

Hi,

I created a lineitem to use as a filter where it will be true for a particular Business unit. But when we are viewing the lineitem in normal view the boolean is there but not in the subsidery view. Also after applying the filter is UX page it's not working.

What could be the reason and how we can fix this?

Accepted answers

All comments

Vamsi_Kaki

Hello @Parul369257 , As per my understanding the following are my responses to your questions

Q1. When we are viewing the line item in normal view the Boolean is there but not in the subsidiary view. Why?

Because, you are fetching data from your system module (SYS07 Business Unit Details) but not comparing with existing list items. So, please update your formula. Another possibility is dimension mismatch between source and target (here it is subsidiary view)

Q2. After applying the filter on UX page, it's not working. Why?

May be due to following reasons:

Filter applied on saved view but not saved
Published saved view and Filter applied saved view might be different
Please check the dimension which you want to filter (whether it is <List> or Time)

Try to create a filter module with the above filter line item. Apply on the target saved view.

Hope this works.

Thanks,

Vamsi

TimWard70

Is the Business Unit one of the dimensions (applies to) in the main module as well as the subsidiary view? If not then you'll need to

a. Think about the dimensionality of the subsidiary view - you may not need to change it from the default for the module, or it may be just BU or something else

and

b. use 'SYS07 Business Unit Details'.'DA-Desk'[lookup: formula based on the Business Unit selected (wherever that is)] to pull in the boolean you want

alexpavel

@Parul369257 : What is the exact dimensionality of the module and what is the dimensionality of the line-item? You need to compare them.

Subsidiary views are quite tricky and you always need to pay attention at the dimensionality of the line-item and the dimensionality of the module.

The line-item appears as "blank" (not visible) in the "normal view" is because the dimensionality of the line-item with subsidiary view contains an additional list(s) that are not part of the module dimensionality.

I always apply this principle for subsidiary views: create a line-item with a different dimensionality than the module only if the line-item contains part of the dimensionality of the module… if the line needs to contain an additional list, I normally create the line-item in a new module.

Example: dimensionality module MB01: Lis1, List2, Version

Line-Item OK for subsidiary if the dimensionality of line-item contains List1 or List2 or Version or any combination of these lists.

If the line-item needs to have a List3 in the dimensionality, the line-item subsidiary will become not visible in the module and it will not be able to be used as a filter in the module MB01.

The only exception when the filter would work on a subsidiary view is if the List3 it contains the "Users" and the filter is applied on "Current User" (at least what I know).

In your case, it seems that the dimensionality of the line-item that you want to use as a filter contains a List3 that is not part of the dimensionality of your module. In order to solve it, is needed to understand why do you need the additional list and how that list needs to interact with your current module.

Also, it is not possible to use as a filter a line-item that is setup on a "Subset". you need an additional line-item that is formatted with the full list with a formula referencing the boolean of the subset.

Hope it helps

Alex

CommunityMember131816

Hi alexpavel,

So if need such a List3 as filter for module MB01 and List3 does not contain the "User", so what is the possible solution? I build a new module with List 1 and List3 and a line item as filter, but it does not work.

Thanks!

TimWard70

If you want to use the output from the module with Lists 1 & 3 as a filter in MB01 which only contains List 1 you will need to check the Summary Type of the filter line item to make sure that Anaplan knows how to summarise List 3 and make sure that List 3 has a top level item.

For example - say the line item is Boolean Formatted it could be summarised as follows. Note the filter in MB01 containing List 1 would only pick up the value in the Top Level Item for List 3

No Summary Type

List 1⬇️ List 3➡️	Option 1	Option 2	Option 3	Top Level
Item A	X
Item B	X	X	X

Any Summary Type

List 1⬇️ List 3➡️	Option 1	Option 2	Option 3	Top Level
Item A	X			X
Item B	X	X	X	X

All Summary Type

List 1⬇️ List 3➡️	Option 1	Option 2	Option 3	Top Level
Item A	X
Item B	X	X	X	X

Quick Links

Can you help?

Unanswered questions

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…
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.…