Look for similar Item

rlgarcia06

Good day!

May I ask for any ideas how can I execute a search for similar items from a list. I have a list of stores with several properties such as type, target market, population of location etc. and if I add a new store, I want to assocoate the new store to an existing store with the similar or nearly the same properties. Any ideas how can i do this?

 

Thank you!

Renier

akhil.kohli

Hi Renier,

 

My thought is that you can filter out the like stores based on the property selections (Again you can mix and match the logic And/Or here.

Below is a screenshot that illustrates this. I select a Target Market and a location. This is a module without dimensions and only list formatted line items.

I have a module with store as a dimension (And Target Market and Location are properties. Best practice says store properties/attributes in a module instead of a list.)

I filter out the stores based on the selections I have made in the previous module.

So based on the properties, a particular list gets selected. You can expand this to any number of selections accordingly.

Let me know if this solves.

 

Thanks 

AK

 

Thanks !

dkolka

Hi,

 

Depending on the nature of your search there are few ways to go about it.  If a user is trying to do a search and see all possible occurrences you could use a search feature and filter on the results using the find function. Here we have a simple example with family members and properties concatenated into a unique code.  The user performs a search and the underlying records are flagged if they contain the search string. In this case a search for John results in relative match.

 

There are 2 modules, 1 unique code and search field line item:

 

 

 

 

 

 

Regards,

 

Dave

LipChean_Soh

Hi,

 

Assuming you follow the DISCO methodology of System, and you have 'Store Properties' module with Store along the row, and all the required properties along the columns.

 

You can use the Quick Filter as explained below:

https://help.anaplan.com/anapedia/Content/Modeling/Working_with_Data/quick-filter.htm

 

Thanks,

LipChean

Sheethal

If your question is how to quickly create a new store, based on existing stores, then you can short list the existing stores based on other members suggestions & then you can use the "Copy Branch" action to create a new store which will have same property as the pre-selected store. This will work only if your Store List is a numbered list.

You can read more about the Copy function here: https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Actions/Other_Actions/Copy_Branch.html

rlgarcia06

Thanks for sharing your idea.
what if i have the following stores
Store 1: Type A : Location A ; No. of Competitors: 0 ; Monthly Sales
Store 2: Type B ; Location B ; No. of Competitors: 3 ; Monthly Sales
Store 3: Type A ; Location C ; No. of Competitors: 3 ; Monthly Sales

then i plan to open a new store with Type A, Location A and No. of Competitors: 1,
with this, I want Anaplan to provide me the store with similar or nearly the same properties, so that I can get the monthly sales of that store.
Any ideas how?

rlgarcia06

Thanks for sharing your idea. what if i have the following stores Store 1: Type A : Location A ; No. of Competitors: 0 ; Monthly Sales Store 2: Type B ; Location B ; No. of Competitors: 3 ; Monthly Sales Store 3: Type A ; Location C ; No. of Competitors: 3 ; Monthly Sales then i plan to open a new store with Type A, Location A and No. of Competitors: 1, with this, I want Anaplan to provide me the store with similar or nearly the same properties, so that I can get the monthly sales of that store. Any ideas how?

rlgarcia06

Thanks for sharing your idea.
what if i have the following stores
Store 1: Type A : Location A ; No. of Competitors: 0 ; Monthly Sales
Store 2: Type B ; Location B ; No. of Competitors: 3 ; Monthly Sales
Store 3: Type A ; Location C ; No. of Competitors: 3 ; Monthly Sales

then i plan to open a new store with Type A, Location A and No. of Competitors: 1,
with this, I want Anaplan to provide me the store with similar or nearly the same properties, so that I can get the monthly sales of that store.
Any ideas how?

Sheethal

You can use Copy Branch option to copy Store 1 as a new store & edit the No. of competitors for the new store created. This will reduce the time involved in creating new list item especially when there are lots of properties associated with the list member.

LipChean_Soh

Hi,

 

I'll expand further on my previous 'Quick Filter' comment.

 

Create a module 'Store Properties' with 'Store' as list, and 2 line items of 'Store Type' and 'Location'.

Note that the 'Store Type' and 'Location' are also of 'Store Type' list format, and 'Location' list format.

Create a module 'Store Sales' with 'Store' as list, and any monthly value line items that you want to analyse. I have created 3, i.e. Sales, Foot Traffic, Rent for illustration purpose.

Create a dashboard combining the 2 modules above.

To do what you want, you can first do a quick filter.

Note that the 'Quick Filter' only shows what's available in the current column, i.e Type C is not an available option in the Quick Filter, though it's a member in the 'Store Type' list i created.

After doing a quick filter, you can click on either Store 1 or Store 3 to analyse their monthly values. Do turn on 'Synchronize Paging' for the 'Store Sales' module.

 

Thanks,

LipChean