About Panji

Panji

Hi wolfgang, why get the circular reference because calculation in your model using same item, in model B to get data Item B2, you take data form model A, and in model A to get data after you take data from model B, it will be circular. the solution is you need to break model A and model B using subset, and you need create model C to combine beetween model A and model B Regards, Panji

Panji

Hi @Deepu, in the import source, are u using 1 of type column separator or more than 1?, regards, panji

Panji

HI @Misbah, @ben_speight, @rob_marshall, @Sheethal Thankyou for respond and answer, i found the issue because i use more than 1 separator and i try to use only 1 separator and it works Regards, Panji

Panji

Hi anaplanner, I have problem with import file using anaplan connect, when i import file with large rows 1 milion or more i have notice out of bonds, but if i import rows less than 1 milion is succesfull. my question is is there a limit to the number of rows that can be imported? Regards, Panji

Panji · ‎10-14-2020

Hi team, I have problem about restore data in production model, first i sync form dev to prod but after sync i want to restored data before i sync and i have pop up like this How to fix it? regards, Panji

Panji · ‎09-17-2020

Hi @Santosh, You mean you want to download file from module in anaplan? If yes, you need to create export action in that module Click -> data -> export and you can change format file type, and you need give checklist in save export definition Regards, Panji

Panji · ‎09-17-2020

Hi @hyudolee Q1: You need to have workspace, and you can visit https://community.anaplan.com/t5/App-Hub/ct-p/APPHUB and search categories and app what you want, ex i want to download app cash flow and after click download, app will be automatically add in your workspace If you want Add app in new ux you need to have access as Page Builder Role - Page Builder Role has the ability to add new apps. Only tenant administrators can assign the page builder role to users listed in the Access Control > Assignments screen of the Administration console . To assign the page builder role: Log in to Anaplan. Select Administration from the Application menu. Click Access Control > Assignments. Select the user. Select the Page Builder checkbox. Click Save Page builders can: create, edit, duplicate and delete apps that represent business processes; set up data views from Anaplan models; configure boards and worksheets ; use cards to build interactive pages with graphics; and populate the card template library Regard, Panji

Panji · ‎09-16-2020

Hi jedge@dsi.com, You want to compare the latest data( SKU B) with the currently data (SKU A and SKU B)? or can you share the screenshot excel file Regards, Panji

Panji · ‎09-16-2020

Hi @Sravan_Kumar, The sync will not lose if you not change the structure data in dev model. Regards, Panji

Panji · ‎08-26-2020

Thankyou @filip.sypniewski

Panji · ‎08-26-2020

Hi @filip.sypniewski , Thank you for the response, could you please give me a review of the pre-sales certification you have taken Regards, Panji

Panji · ‎08-25-2020

Hi, Where i can found information about anaplna pre-sales certification? Regards, Panji

Panji · ‎07-12-2020

Hi team, I have problem with anaplan connect 1.4, sometimes i get error 2020-07-13 09:21:25 INFO 88 |-- Initializing Service... 2020-07-13 09:21:25 INFO 88 |-- Authenticating via Basic... 2020-07-13 09:21:47 INFO 88 |-- Retrying API request: Attempt (1) 2020-07-13 09:21:50 INFO 88 |-- Retrying API request: Attempt (2) 2020-07-13 09:21:54 INFO 88 |-- Retrying API request: Attempt (3) 2020-07-13 09:22:11 ERROR 88 |-- Server files not found: Server-Files not found for Model-ID=AE3A34E7D5AA49C1B94D37092885E250 (Retryable: api.anaplan.com: Temporary failure in name resolution executing GET https://api.anaplan.com/2/0/workspaces/8a81b00e6d9da7a4016e361dd8ea0319/models/AE3A34E7D5AA49C1B94D37092885E250/files?offset=0 (Unknown host: api.anaplan.com: Temporary failure in name resolution)) OR 2020-07-13 09:49:25 INFO 44 |-- Initializing Service... 2020-07-13 09:49:25 INFO 44 |-- Authenticating via Basic... 2020-07-13 09:49:35 INFO 44 |-- Retrying API request: Attempt (1) 2020-07-13 09:49:38 INFO 44 |-- Retrying API request: Attempt (2) 2020-07-13 09:49:43 INFO 44 |-- Retrying API request: Attempt (3) 2020-07-13 09:50:00 ERROR 44 |-- Anaplan API: Basic Authentication failed! (Retryable: auth.anaplan.com: Temporary failure in name resolution executing POST https://auth.anaplan.com/token/authenticate (Unknown host: auth.anaplan.com: Temporary failure in name resolution)) how to fixed this error? thanks

Panji · ‎06-30-2020

Hi team, I have problem about mapping between entity, entiy(holding) and group. exp: entity H have transaction with entity G, but they in a different group (H in group 3, and G in group 2), we can elimination if H and G in a same group, but group 3 and group 2 in the same group 1, so how to create auto mapping using formula based on my case? for detail i attached file Thanks

Panji · ‎06-21-2020

Hi, you need add lookup funtion in your formula and refer to division L3.division HFM regard, panji

Panji · ‎06-21-2020

Hi, in module inventory ending report(3 dimension) and KPI DOI(2 dimension) you have different dimension, if you want get data form different dimension you need to mapping, example ( division HFM to division L3). Thanks, Panji

Panji · ‎06-19-2020

Yes, like @anikdas say the formula should fine, but if you see in FY19 the result will not show because the problem is your summary setting in none, so you need to check your summary setting and change none to formula.

Panji · ‎06-18-2020

Hi @Rajasekhar, can you give me screenshot module months and blue print module months, because i need to know what dimension and line item you used.

Panji · ‎06-18-2020

Hi @Rajasekhar do you have code on Qtrs List?, Because finditem will search item Qtrs list based on code Regards, Panji

Panji · ‎06-18-2020

so you meant if we want to know data balance or not, we need to see in another module(new module we created before) ?

Panji · ‎06-18-2020

in this model im only use 1 dimension(list Balance sheet with parent Entity) and using line item trading partner, Account Thanks

Panji · ‎06-18-2020

Hi @nathan_rudman Thankyou for respon, can you give me view(detail) about your suggestion Regard, Panji

Panji · ‎06-16-2020

Hi, I have line item (status interco) where if amount blue and red not same it will be give text "Unbalance" but i dont know how to compare every item Any ideas are appreciated. Thanks,

Panji · ‎05-29-2020

Hi @takushimozuru I think you need to 1. create new list(Module C) 2. Create Saved View in Module A and Module B 3. Import data module A and Module B using saved view to new list properties and in module C use formula from new list properties or 4. Import data module A and Module B using saved view to Module C Regards, Panji

Panji · ‎05-28-2020

Hi, Thankyou @Misbah and @Misbah to answer now i have 2 option to create like my problem

Panji · ‎05-27-2020

Hi Teams, I have data using List L3 but in next month(Feb 20) the structure will be change, but structure and data in previous month(Jan 20) not impact, like a picture bellow can we do that in anapan? Thank, Panji

Panji · ‎05-18-2020

Hi, DCA just make you can view or input data or hide data, but in summary you can view all data, If you want to see data summary based on input DCA, you need to create another line item and using formula like this in line item headcount Jan And Feb using DCA Regards, Panji

Panji · ‎04-22-2020

Hi @sandeep_bk , the reason is i want to make a journal, and the color just a note that data(color) will be import to create journal, and the sort will be order like a picture 2. Thanks, Panji

Panji · ‎04-22-2020

Hi Anaplanner, I'm import data like this, but i want to sort data based on color before im import to another after import the data will be like this can anaplan provide like that? Thanks, Panji

Panji · ‎04-22-2020

Hi, You just need checklist on INV01 setting dashboard, in SYStime not need Check sync time Thanks