Subsidiary views

Highlighted

Subsidiary views

Hi,

 

Can anyone advise me how subsidiary views works?

 

I have 2 modules & both of them have different dimensions

Module 1 - Has a composite list as a dimension (Account>Product)

Module 2 - Standard list as a dimension (Account)* has country details

 

I want to pull Country details from module 2 to module 1, but I'm unable to do so because of different dimensions. Can subsidiary views works in this case?

Module 1

CommunityMember111277_0-1597391358440.png

Module 2

CommunityMember111277_1-1597391391614.png

 

Thanks

AB

 

 

2 REPLIES 2
Highlighted
Master Anaplanner/Community Boss

Re: Subsidiary views

@CommunityMember111277 

 

Subsidiary views are where one or all of the dimensions do not match with the default dimension of your module. 

 

In your case it is not subsidiary view that will help but understanding the usage of LOOKUP functionality.

since Account>Product, Account is the top level and is defined at Country level you can easily pull the Country Value from Module 2 to Module 1 which is dimensioned by Accounts

 

Step 1: Just create one line item in Module 1

Formula = Parent(item('Account>Products'))

Step 2: Write a formula in Country Line item

Formula = Module 2.Country[LOOKUP: Line item 1]

 

Hope that helps

Misbah

 

 

Highlighted

Re: Subsidiary views

Thanks! It worked..