Import takes time with filter view

CommunityMember125605

Hi, I want to know filter function.

I run Import Action from saved view which filtered by Lineitem.

But It takes long time.

 

The point was module pivot.

View A and B was filtered by same Lineitem.

But it takes shorter set source module as ViewB than ViewA.

 

View A

Product	Location	Time	Amount
A	X	1/1	1
A	X	1/2	2
A	X	・・・	3
B	X	1/1	4
B	X	1/2	5
B	X	・・・	6

 

View B

Product	Location	1/1	1/2	・・・
A	X	1	2	3
B	X	4	5	6

 

 

Is it true?

rob_marshall

@CommunityMember125605 

 

 

In View A, I highly suggest you reading this article which explains why having Time as a line item is less perforant than having the data dimensionalized by Time.

 

https://community.anaplan.com/t5/Best-Practices/Data-hubs-purpose-and-peak-performance/ta-p/48866

 

We had one client who had Time as part of the code in a list, which is essentially what you are doing, and the list was 130M members.  Once they took time out and dimensionalized it in a module, the list was only 6M members, which also brought the overall size of the model way down.

 

Rob