- Community
- :
- About usha.cherukuri
Ask the Community
-
Ask a QuestionGet answers to platform specific questions from Anaplanners everywhere.
-
Suggest an IdeaShare ideas for platform improvements, training, the Community, and more.
-
Get Training HelpComplete your training with support from the experts.
-
Contribute ContentWorkshop content, submit for approval, and contribute best practices to the Community.
-
Connect with CommunityShare feedback, ask questions, and get support from the Community.
About usha.cherukuri
since
05-29-2019
Tuesday
usha.cherukuri
Contributor
26
Posts
2
Kudos
1
Solution
12-04-2019
03:15 AM
Hi Vignesh, Thanks for you quick response. but only one Q I have here , If we have 5-6 module for data load. then i end up in making 5-6 staging tables for each module right? Thanks Usha
... View more
12-04-2019
03:14 AM
Hi Kavin, sorry but I didn't actually got this, say I have loaded the data in as a text line item and convert that to number format in second line item. still I may require the firstoccurance filter view to ignore the duplicate line right? as suggested by @vignesh above. Thanks , Usha
... View more
12-04-2019
01:08 AM
Hi All, I was trying to load data into a module, but my data file has duplicate rows. when I load the file, I was expecting the duplicate rows to be ignored or flagged as duplicate record value but it getting added in the member value. Example: Dimension Line item(amount) row1 ABC 10 row2 DEF 20 row3 ABC 30 row4 DEF 40 When I load the above file, my values for ABC becomes 40(10+30) and DEF becomes 60(20+40) Is this is the way anaplan will load a data file or is there any way I can eliminate the duplicate rows. Regards, Usha
... View more
Labels:
11-26-2019
12:34 AM
Hi , I have a line item Amount in Module A, and Line item Final Amount in Module B. both modules uses different List but the member in module B is a line item value in module A(text field). I want to Sum all the amount in module B based on the line item value match in module A. Regards, Usha
... View more
Labels:
11-25-2019
03:59 AM
Hi David, This is working good for Child Level, but Parent Level for 'AccountL1' is 'AccountL0' which is not a number list, for that the value is showing zero. Is there any way how we can get the parent level also populated here? Thanks Usha
... View more
11-25-2019
03:43 AM
Hi David, Thanks this now works for child node in AccountL1 dimension perfectly. Regards Usha
... View more
11-25-2019
03:08 AM
Hi Kavin, Yes even I thought so, but still no result:( It takes the formula in but result is 0 every time, though I have special characters in member name. Thanks Usha
... View more
11-25-2019
02:54 AM
Hi Mishab, Thanks for your rsponse, but the first formula for test FIND("-", NAME(ITEM('Account L1')), 0) doesn't give any result and its a numbered list dimension. the formula worked but doesnt give any value here. Regards Usha
... View more
11-25-2019
02:03 AM
Hi Team, Just looking for formula to trim my node name till a special character "-". 'AccountL1- 234' I want to get only AccountL1. Regards, Usha
... View more
Labels:
11-08-2019
03:03 AM
Hi @Kavin, Thanks a lot, Made my day 🙂 Regards, Usha
... View more
11-08-2019
02:42 AM
Hi, I have a module A with List A, and Module B with List B. Both the Lists are almost similar. But they are 2 different List. I have line Item PARENT_NODE in both Modules. I have new Line Item compare_Parent, were I need to compare and the result as "similar" or "different". In ModuleB I have written below formula but its not working IF PARENT_NODE = ModuleA.PARENT_NODE then "Similar" else "Different" Please let me know on this Thanks & Regards, Asha
... View more
Labels:
11-05-2019
03:13 AM
hello Nathan Rudman, Yes , I completely agree with you.
... View more
11-05-2019
12:58 AM
Hi, We have a module , need to clear data from the module based on Period selection but one more than period should be selected at one go. One possible option is to copy zero value from a second module and select the period to clear while run time but this allows us to clear only one period in one run, so if I want to clear specific 6 month data, do I have to execute this action 6 times? say for example, I have a check box line item where user selects only the periods which he wants to clear data and execute the action and Anaplan clears only those periods data. Regards, Usha
... View more
Labels:
08-14-2019
07:02 AM
Hi Kavin, Thank you for the response given. Thanks Usha
... View more
08-14-2019
03:02 AM
Hi, How to add time period selection option in process while importing file. Attached the screen shot for the reference. Thanks Usha
... View more
Labels:
07-26-2019
06:10 AM
Hi @Niranth , Attached the document with detailed screen shots for your reference. Kindly check on it and suggest on the same. Thanks Usha
... View more
07-26-2019
04:28 AM
Hi, To display a Text message in the dash board (Separate Grid not part of the line item) based on the Variance (If it is 0 to display message like " No Difference", If it is 1 " Need to take corrective action" ) Kindly Suggest on the same. Thanks Usha
... View more
Labels:
07-25-2019
05:50 AM
2 Kudos
Hi Anirudh, Thanks for your prompt Response 🙂 we added the conditional formatting Rule for all the Line items in module based on the same condition (i.e Boolean check). Now entire row is highlighted with color (based on the Boolean check). Thanks Usha
... View more
07-25-2019
02:46 AM
Hi Anirudh, Thanks for the quick response, Based on the condition particular cell get highlighted, But here the requirement will be we want to highlight the the entire row based True or False. Thanks Usha
... View more
07-25-2019
02:27 AM
Hi, Could you please suggest the solution on below. We have a requirement to highlight the entire row with color in module based on the Boolean check (i.e if it is True then highlight with color. Thanks Usha
... View more
Labels:
07-17-2019
06:21 AM
HI @Manuela_Apostol , Tried the same and its working fine now Thanks for the Reply:) Thanks Usha
... View more
07-17-2019
06:19 AM
HI Anirudh, Tried the same and its working fine now Thanks for the Reply:) Thanks Usha
... View more
07-12-2019
03:23 AM
Hi, Could you please suggest, How to hide Modules and its views on contents section (without using Contents- Role module/user access options). Attached the screen shot of the same. Thanks Usha
... View more
Labels:
07-11-2019
05:02 AM
Hi @kavinkumar, Tried with suggested solution provided, and it worked as expected. Thank you for timely response. Thanks, Usha
... View more
07-09-2019
05:46 AM
Hi, We have the dashboard consists of 3 columns A,B and variance Now I want to highlight the third column with same color irrespective + and - ve values (tried with conditional formatting, same color option is not available to highlight +ve and -ve values in same color- Red color). Please suggest. Thanks Usha
... View more
Labels:
My Accepted Solutions
| Subject | Views | Posted |
|---|---|---|
| 694 | 07-25-2019 05:50 AM |
Activity Feed for usha.cherukuri
- Posted Re: Data load for duplicate rows on Anaplan Platform. 12-04-2019 03:56 AM
- Kudoed Re: Data load for duplicate rows for VIGNESH.M. 12-04-2019 03:55 AM
- Posted Re: Data load for duplicate rows on Anaplan Platform. 12-04-2019 03:15 AM
- Posted Re: Data load for duplicate rows on Anaplan Platform. 12-04-2019 03:14 AM
- Kudoed Re: Data load for duplicate rows for VIGNESH.M. 12-04-2019 03:10 AM
- Posted Data load for duplicate rows on Anaplan Platform. 12-04-2019 01:08 AM
- Posted Text value match in module and List on Anaplan Platform. 11-26-2019 12:34 AM
- Kudoed Re: Trim a node name till special character "-" for DavidSmith. 11-26-2019 12:11 AM
- Posted Re: Trim a node name till special character "-" on Anaplan Platform. 11-25-2019 03:59 AM
- Posted Re: Trim a node name till special character "-" on Anaplan Platform. 11-25-2019 03:43 AM
- Kudoed Re: Trim a node name till special character "-" for DavidSmith. 11-25-2019 03:37 AM
- Posted Re: Trim a node name till special character "-" on Anaplan Platform. 11-25-2019 03:08 AM
- Posted Re: Trim a node name till special character "-" on Anaplan Platform. 11-25-2019 02:54 AM
- Posted Trim a node name till special character "-" on Anaplan Platform. 11-25-2019 02:03 AM
- Posted Re: How to comapre Data from different Module and has Different Diemension on Anaplan Platform. 11-08-2019 03:03 AM
- Kudoed Re: How to comapre Data from different Module and has Different Diemension for kavinkumar. 11-08-2019 03:02 AM
- Posted How to comapre Data from different Module and has Different Diemension on Anaplan Platform. 11-08-2019 02:42 AM
- Posted Re: Clear the data for more than one period in one action button. on Anaplan Platform. 11-05-2019 03:13 AM
- Kudoed Re: Clear the data for more than one period in one action button. for nathan_rudman. 11-05-2019 03:13 AM
- Kudoed Re: Clear the data for more than one period in one action button. for Misbah. 11-05-2019 03:12 AM
My Top Kudoed Posts
| Subject | Kudos | Views |
|---|---|---|
| 2 | 694 |
My kudoed posts
| Subject | Kudos | Posted |
|---|---|---|
| 2 | 07-25-2019 05:50 AM |
My kudoed posts
| Subject | Kudos | Posted |
|---|---|---|
| 2 | 07-25-2019 05:50 AM |
Posts I kudoed
| Subject | Kudos | Author | Latest Post |
|---|---|---|---|
| 1 | |||
| 1 | |||
| 1 | |||
| 2 | |||
| 1 |