About hyudolee

hyudolee

Hi I want to use Timesum function. In this page, we can use Timesum function with end date to start date. https://community.anaplan.com/t5/Idea-Exchange/Dates-in-Timesum/idi-p/89565 But in Anapedia page, it is not suggested to use Date. https://help.anaplan.com/13d8b551-4e13-413b-a39f-f25579d21e38-TIMESUM Is there some risk to using Timesum function with Date?

hyudolee

Hi, @AntonMineev . Thanks for replay! I will ask to support team.

hyudolee

Hi, I want to change user Role. I want to change Users Role from "Visiting" to "Internal". But I can't found how to do it. There is a way to add new users to Visiting role. I have to add it again? And there is notion when adding users. https://help.anaplan.com/3589348b-48de-49e4-9f6c-595f273efb4b-Create-a-new-internal-user

hyudolee

@KirillKuznetsov I add the Location-Product dimension but I couldn't. But I could filter it when I set the Product as Rows. What is this difference?

hyudolee

Hi, @KirillKuznetsov ! I tried your suggestion, but I couldn't. Module UX Filter The Filter context doesn't selected automatically, I have to chose any one.

hyudolee

Hi, I have a question about filter function. I have two tables. First one shows amount by Location-Product List. The Second shows amount by Product List. Location-Product List has Product List as Properties. I want to display these tables in one UX Dashboard. Then I want to filter the second table(Product) by First Table(Location-Product). This means, When I watch the amount of "X-A" Location-Product, I want to watch the amount of "A". Do you have any idea?

hyudolee · ‎12-21-2021

Hi, @SathyaM . Thanks for replay! I will use timesum function.

hyudolee · ‎12-21-2021

Hi, I use week General as Time setting. I want to get Last day in all time. Module A Time 2021/1/1 2021/1/2 2021/1/3 2021/1/4 2021/1/5 2021/1/6 2021/1/7 Num 1 1 1 1 1 1 1 Offset(Num,1,0) 1 1 1 1 1 1 0 Last day 2021/1/7 I can get last day in Module A. But I couldn't get in Module B( has no time, has Product List) Module B Product Last day A 2021/1/7 B 2021/1/7 C 2021/1/7 Do you have any idea?

hyudolee · ‎12-20-2021

Hi, @SathyaM . Thanks for replay! You mean we cannot aggregate amount unless we set Top level of items? I can aggregate it Country to Region(Property), if I use Formula like [SUM:Region]. But I can not do before case. I think it's strange. Country Region(Property) amount a X 100 b X 200 c Y 10 d Y 20 Region amount X 300 Y 30

hyudolee · ‎12-19-2021

I want to aggregate the order From Table A to B. Table A Region Product amount a x 100 y 10 b x 200 y 20 Table B Region aggregate x 300 y 30 I input the formula as below. Aggregate = Amount [SUM:Region] But I could not calculate it. If I have RegionALL as Region's top level of item, I could calculate it. We should use Top level of item instead of SUM Function?

hyudolee · ‎12-17-2021

Hi, I want to use aggregate function. I want to aggregate "Date" Lineitem from Order A&B to Aggregation Module. Date Lineitem has Date format. I use " OrderA.Date[Max:Product]" as Formula. And I can also use "Fristnonblank" and so on because Date Lineitem is common in module. Which Formula is good at performance? Each Order has Product, But Product will not duplicate. And Order A and Order B has own date. It depends on Own module.

hyudolee · ‎12-16-2021

I want to use Subsidiary view. In Subsidiary view, we can watch only 1 Lineitem not several Lineitems. I want Enduser to input the data in these Lineitems in one Dashboard. Should I have to make a another module?

hyudolee · ‎12-14-2021

OK, I understand. This means we should not import Data from List to List? We should import Data from Module to List, right?

hyudolee · ‎12-14-2021

I tried this. When I use defalut view in import setting, the message has appeared. But When I use saved view, I can import correctly. In this setting, Module means original view, does not means default view?

hyudolee · ‎12-13-2021

Hi, I want to import List from module. I have this type of List(▲test) , has top level of item. I want to import from this module. But when I tried this, I received error message. This message says that List_All has failed. I tried restrict the level of items and hide top level of item, But I cannot solve it. Do you have any idea?

hyudolee · ‎12-13-2021

Hi, I tried run delete action in new UX. But there are no message, so I can't count how many items I deleted. I saw it in classic Dashboard.

hyudolee · ‎12-13-2021

Hi, @rob_marshall and @Misbah. Thanks for replay! I understand that Action runs in order. How about Process Action? Action in Process will never run across?

hyudolee · ‎12-10-2021

Hi, I want to check the action concurrency. If several users run the action, Action which first user run will run? The second user's will not run?

hyudolee · ‎12-02-2021

Hi, I want to import write access to Lists. I have this type of table. Users Customer a xxx1,xxx2 b xxx2,xxx3 But the List item is shown by #1,#2 in User setting. How can I import to List? And I want to set the write access to combination List. Now if I set this write access. Users Customer Product a xxx1,xxx2 yyy1 b xxx2 yyy2,yyy3 I want to set write access to combination list automaticaly. Users Customer-Product a xxx1-yyy1,xxx2-yyy1 b xxx2-yyy2,xxx2-yyy3 Do you have any idea?

hyudolee · ‎12-01-2021

I have Order module(Region, Order) Order(1,2...) comes from each Region. Order has Item and Amount. I want to aggregate item-amount by dynamic Region like this table. If Users chose the Europe, Item-Amount Table is aggregated by Europe. I tried SUM and LOOKUP but I couldn't. The point is I don't need Region List in Item-Amount table because it consumes memories. And I don't want to use List Subset function because dynamic region setting has another dimension. ( I omitted the instructions to explain briefly)

hyudolee · ‎11-25-2021

1. How many groups can there be in total? Does Nov 7th start back at 1 again? >> 31Groups( = month) I will use this group as dynamic cycle. It will change by time cycle( month, week) 2. When you aggregate your Order (Sum) line item..are you looking at the entire timescale or just one week or just one month? What is the basis of that aggregation? >> 1months. 　I think we can use day List instead of Time(Day), and save memories.

hyudolee · ‎11-24-2021

Hi, @sourjyar . Thanks for replay. I understand your solution. But in this situation, Group determined by Time. (Like weekday) If I want to aggregate Order by Group, I have to make a module(Time & Weekday List). We cannot aggregate Time to Group in Anaplan. It will consume much memories. 1-Nov 2-Nov 3-Nov 4-Nov 5-Nov 6-Nov ・・・ Group 1 2 3 1 2 3 Order 100 200 300 400 500 600 Odrer(Sum) 500 700 900 500 700 900

hyudolee · ‎11-24-2021

Hi I want to sum Orders with Group Number. The point is Group Lineitem is not formatted List, is Number Formatted. 1-Nov 2-Nov 3-Nov 4-Nov 5-Nov 6-Nov ・・・ Group 1 2 3 1 2 3 Order 100 200 300 400 500 600 Odrer(Sum) 500 700 900 500 700 900 I tried Rankcumulate or Sum Functions, But I can't Solve this.

hyudolee · ‎11-18-2021

Hi, I want to use List Subset. We can import Boolean item to List Subset. But we can not input the formula in List Subset and can not make a refference in module. How can I manage it in module and List? And Can we filter original List by List Subset?

hyudolee · ‎11-08-2021

Hi, @ankit_cheeni. I made a module as you told. But Write Access does not work. I think this Write Access Lineitem has Fake Users as Applies to.

hyudolee · ‎11-08-2021

Hi, @Ingilavicus. >>In blueprint view under User List property select "Show All Users Off". I understand this. We cannot avoid the concurrently issues? @ankit_cheeni says we can avoid this issues by identifying the user who is running action.

hyudolee · ‎11-03-2021

Why does Write Access Lineitem exists? If Write access Lineitem has Fake Users as Applies to, I can not restrtict the Write access. I think this Lineitem should have Users List. Then I can restrict the access. Are you going to do this?

hyudolee · ‎11-02-2021

I could avoid this problem by making a filtering Lineitem. Before Importing to List, end users will set own Users Item and filter the original module. Another solution is making a temporary module. - Module A ⇒ Module temp ⇒ List A I can select the Users when importing between modules. How do you avoid this?

hyudolee · ‎11-02-2021

Hi, I want build a system several End Users can make the master data at the same time. The point is EndUsers do it at the same time. So I made a module which has Users as Applies To. And EndUsers have to import this module to List. But I could not filter by Users. So data which another User made was imported at the same time. How can I avoid this problem?

hyudolee · ‎10-21-2021

Hi, I want to import csv file which has Shift-JIS encoding which is Unique code in Japan. I have a problem the text has "(株)", "No.". <Data source> No. <Anaplan> �� I think this text is windows's environment-dependent character. So I changed the import setting from Shift-JIS to windows-31, and I could solve it. Does anybody faced this problem? I'm afraid that I will face another problem because of this change. Of course, if I use UTF-8, I can solve it. But the customer's excel was old, so I have to chose this encoding.

About hyudolee

PlanIQ

Timesum with Date

Re: Internal and visiting Users

Internal and visiting Users

Re: Filter by Property

Re: Filter by Property

Filter by Property

Re: Get Last data in all time

Get Last data in all time

Re: SUM Function and List ALL

SUM Function and List ALL

Which aggregate function is good at performance

About subsidiary view

Re: List import error : Top level of item

Re: List import error : Top level of item

List import error : Top level of item

Delete message in new UX

Re: Run Action Concurrency

Run Action Concurrency

Import write access to List

How to use SUM and LOOKUP dynamically

Re: SUM with Group Number

Re: SUM with Group Number

SUM with Group Number

Manage List Subset in Module

Re: Filtering by Users when Imporing

Re: Filtering by Users when Imporing

Re: Filtering by Users when Imporing

Re: Filtering by Users when Imporing

Filtering by Users when Imporing

How to avoid garbled characters when importing

Which aggregate function is good at performance

Which aggregate function is good at performance

Which aggregate function is good at performance

November 2020 Releases and December Sneak Peek

Upcoming Maintenance: August 22 2020