关于社区成员11277

社区Member111277

嗨，M.Kierepka-感谢您指出的。我已经进行了必要的更改，但问题仍然存在。更多建议。谢谢

社区Member111277

Hi Team, I'm trying to add new items to model list without using the IMPORT function. Facing this error - Can someone highlight where I have gone wrong with the scripts Thanks AB

社区Member111277

@M.Kierepka It works if you deactivate jdbc.params

社区Member111277

Hi M.Kierepka, Thanks for your suggestions. As I have 9 columns in my source file, could you please let me know how to update the values for jdbc.params - I tried updating the below options, but its not working jdbc.params= Employees, Code, Dept Code, Country Code, Start Date, Leave Date, Current Salary, Commission %, Active? jdbc.query=SELECT Employees.Employees, Employees.Code, Employees.[Dept Code], Employees.[Country Code], Employees.[Start Date],Employees.[Leave Date], Employees.[Current Salary], Employees.[Commission %], Employees.[Active?] FROM Employees; Thanks AB

社区Member111277

Hi Model Builders, I need your advise on this below error I tried to follow the steps mentioned in this document to build a JDBC connector using Anaplan Connect - https://anaplanenablement.s3.amazonaws.com/Academy/Platform/SA/SA_01/L08/WEB/index.html#/lessons/L_kD_rXFRzmz2kf0p4KDbsKlt3RLWk0z It seems that the JDBC connection is established but may be something is wrong with the JDBC query Can anyone suggest what can be the issue Thanks AB

社区Member111277

嗨，Alexpavel-最后一个问题，我还可以将Anaplan Connect用于交易API吗？

社区Member111277

Alexpavel-我可以使用Anaplan Connect作为其基于Java脚本

社区Member111277

嗨M.Kierepka automati周围你能告诉我更多on tool which can be used to run these APIs? Correct me, if I wrong, but I think POSTMAN is generally used for testing purpose, hence what should be the normal approach to run these requests? In case, of any tool, what automation tool do you suggest which can used to run these APIs automatically. Thanks AB

社区Member111277

嗨，团队，我对使用批量API的导入和上传功能有一些疑问。为了使导入功能工作 - 文件应在Anaplan中存在。但是，如果我想导入新的文件，那么我需要根据我的理解首先上传文件。现在，为了上传文件，Anaplan说必须首先使用Anaplan UI上传该文件。我无法理解此部分-A。如果我必须使用Anaplan UI上传文件，那么我将能够执行其他功能，例如使用UI等其他功能，那么该批量API的需求是什么？B. Anaplan文档还使用API讨论了该文件的后续上传 - 如果我想用不同的数据上传同一文件该怎么办。API将如何工作？是否有任何概念可以从本地计算机手动上传文件或使用Bulk API（Depl。AnaplanConnect）进行流式传输。谁能向我解释任何场景/过程。目前，我正在使用Postman来测试所有这些请求。 Do I need to use any other tool to test files upload/download? Best, AB

社区Member111277

Yea, it worked for me a well. Thanks One quick question - why doesn't it works with models/{modelId}/modules/{moduleId}/lineItems/{lineItems}/dimensions but works with /models/{modelId}/lineItems/{lineItemID}/dimensions

社区Member111277

Hi, Can anyone provide the request code for Retrieve dimensions IDs for a line item? I tried to create & test the below code but its not working curl -X GET 'https://api.anaplan.com/2/0/models/{modelId}/modules/{moduleId}/lineItems/{lineItems}/dimensions' \ -H 'Authorization: AnaplanAuthToken {anaplan_auth_token}' \ -H 'Accept: application/json'

社区Member111277

是的，值得庆幸的是，我们做到了 - 每次对产品模型进行任何更改之前，每次副本。能够使用复制的模型并将其与开发模型同步..必须为Excel Addin＆Nux执行单独的映射，但应该有一个选择 - 恢复原始模型或至少Anaplan团队可以做出后端需要进行一些必需的更改 - 例如每6-12小时自动每6-12小时进行一次副本，这也可以自动删除。因此，将来，如果有任何问题，Anaplan团队可以从后端恢复模型。另外，我发现您无法删除未使用的修订标签。应该有一个选项删除当前缺少的未使用标签

社区Member111277 · ‎03-01-2022

Hi Team, I require some urgent advise ALM Sync issue. My team has accidently changed structure at the target model directly using standard mode & now my source model is not getting sync with my target model. We tried to revert back to existing ID using History setting however, even though changes reverted back to earlier setting but cannot perform sync with source model. Please advise Thanks BB

社区Member111277 · ‎01-19-2022

@KirillKuznetsov Actually, I received some feedback from the Academy team stating DCA hasn't been setup in the model, & I will have to apply DCA setting for User filter. I'm not able to figure out the requirement & where will I find the required details. Any help is appreciated

社区Member111277 · ‎01-19-2022

嗨，有人对3级型号构建中的DCA需求有任何了解。我找不到DCA的任何用户故事？谢谢BB

社区Member111277 · ‎01-19-2022

嗨，谁能在3级型号构建中确认DCA配置的用户故事？是用户故事1.12吗？另外，谁能确认如何测试？我的意思是，我如何确认是否正确创建了DCA模块，因为没有任何屏幕截图。谢谢BB

社区Member111277 · ‎01-18-2022

Anyone can pursue Anaplan, you don't need to have certain education qualification. Important thing is to know how well you are with formulas, coding etc. (lets say excel formula for example). Apart from few standard prebuilt features, you have to start everything from scratch. Hence, its important how well you familiar with coding, your interest to learn coding etc.

社区Member111277 · ‎01-18-2022

并非所有应用程序都可以下载，尤其是由Anaplan合作伙伴创建的应用程序。您必须检查该应用程序是由Anaplan还是Anaplan的合作伙伴推广的。如果是以后的，那么您可能必须询问各自的合作伙伴以访问下载该应用程序。他们将询问您的要求等。在授予对应用程序访问之前。

社区Member111277 · ‎01-17-2022

Hi, Can anyone explain the difference between Cloudworks & Onecloud & when to use what? I gathered that Onecloud has both cloud & on-premise options as compared to Cloudworks, however I'm not sure which is more effective - features wise, cost etc. Also, in terms of Data Integration with ERP tools (cloud/on-premise) - how does it compare with Anaplan's other Integration tools like Mulesoft, Informatice etc. How is it different? Anaplan has many Data Integration options, however I'm not sure how one can identify & choose the best option. I know its something to do with business requirement, however I just wanted to know the basic differences in between them. Would be great if someone can highlight these points, differences etc. Or, at least guide me to article where all these questions have been already answered. Thanks BB

社区Member111277 · ‎01-12-2022

Hi All, Just wanted to clear some doubts on usage of SUM & LOOKUP at the same time for same line item If I use SUM & LOOKUP both at the same time for the same line item, its giving me correct details as expected However, if, don't want to use SUM & LOOKUP at the same time, then what can be the options - I tried with subsidiary views & it worked as well If I want to break this equation into SUM & LOOKUP separately, its not working. I tried creating an intermediary module with same dimension, however its still showing as error Any idea where have I gone wrong Thanks BB

社区Member111277 · ‎06-25-2021

Hi All, Need some advise with Excel Add-in I installed Excel Add-in & after successfully login - I'm not able to create new connection. Please see the screenshot below Note - I trying this activity for the first time Add-in Option Let me know if I have done something incorrectly. Thanks

社区Member111277 · 01-05-2021

谢谢..将检查它。

社区Member111277 · 01-05-2021

Can anyone tell me why am I not able to see "Manage my app" icon? I saw saw that initially, when I entered the page for the first time then after clicking the "Continue" button - I no longer see it now Please advise "

社区Member111277 · ‎08-20-2020

Hi, Can anyone please explain why the below formula is not pulling any data? I wanted to fetch the details into LoS from SYS13 using LoS(numbers) as driver LoS >> Line Item List(Length of service) I tried converting the LoS(Numbers) into Text & tried vlookup again but it didn't fetch any details Thanks

社区Member111277 · ‎08-14-2020

在这件事上 - 如果我们有多个订单项，那么清除并撤消它们可能需要时间。另外，如果我们有多个模块要清除，则可能需要更多的时间进行复发 - 同样，一次仅限于1个模块。如果您需要清除多个模块，则必须创建多个虚拟模块，而没有数据会增加时间和精力。我正在寻找一种可以通过一个命令/脚本/公式等从多个模块中删除数据的方式。

社区Member111277 · ‎08-14-2020

Hi, Is there a way to clean all data from different modules at one go? Is there a script or command which needs to be followed? Thanks AB

社区Member111277 · ‎08-14-2020

谢谢！有效..

社区Member111277 · ‎08-14-2020

Hi, Can anyone advise me how subsidiary views works? I have 2 modules & both of them have different dimensions Module 1 - Has a composite list as a dimension (Account>Product) Module 2 - Standard list as a dimension (Account)* has country details I want to pull Country details from module 2 to module 1, but I'm unable to do so because of different dimensions. Can subsidiary views works in this case? Module 1 Module 2 Thanks AB

社区Member111277 · ‎08-13-2020

Hi Jared, I have taken the 30 as a quarterly base to calculate the monthly figures. If 120 is my total commission then quarterly it comes around 30 (120/4). Then calculate the monthly figures based on the quarterly base - Jan - 31/91 x 30 > 10.22 Feb - 29/91 x 30 > 9.56 Mar - 31/91 x 30 > 10.22 Apr - 30/91 x 30 > 9.89 May - 31/91 x 30 > 10.22 Jun - 30/91 x 30 > 9.89 Jul - 31/92 x 30 > 10.11 Aug - 31/92 x 30 > 10.11 Sep - 30/92 x 30 > 9.78 Oct - 31/92 x 30 > 10.11 Nov - 29/92 x 30 > 9.78 Dec - 31/92 x 30 > 10.11 Total > 366 days > 120 My monthly figures might vary from quarters to quarters but my quarterly figures are fixed I suppose. Is my assessment wrong? Thanks AB

社区Member111277 · 08-12-2020

嗨，贾里德，您能帮我了解季度分配意味着什么？例如 - 可以说我的目标为1200一年。佣金-10％，因此，全年的佣金将为120（1200个占10％），每个季度都需要均匀分布，但根据天数的不同。Q1-30，Q2-30，Q3-30＆Q4- 30- Q1 - 1月（31天），2月（29天）3月（31天）1月-91/91 x 30 Feb -29/91 x 30 30 Mar--31/91 x 30我的理解是正确的还是我错过了什么？谢谢AB