About riyazpasha

riyazpasha · ‎06-03-2022

@rob_marshall Ah I got your point. Multiple user would be using and it should be user list driven. Thanks for reminding the best practice of Anaplan. Appreciate it. Regards, Riyaz Pasha

riyazpasha · ‎06-03-2022

Hi @Alexandru.Rosca , Thanks for the Idea. I have used the same solution with some changes. In the filter module I made it as dimension less and using only 2 line items Fund(List Formatted) Index(List Formatted) . In the Input module I have created the 2 filter line items Fund Filter and Index Filter? In this way I can have the similar view which I was expecting initially Thanks everyone @ryan_kohn @M.Kierepka Regards, Riyaz Pasha

riyazpasha · ‎06-03-2022

Thanks @M.Kierepka for the prompt response. I am working on the additional development on it previously its was just the Fund with only one index mapped to Fund. Now we have multiple index mapped to single fund so I have crated a new list called index. Thanks @ryan_kohn But we are using classic dashboard. The Fund and the Index both are separate list

riyazpasha · ‎06-02-2022

Hi, I have requirement were the user will select the Fund from page selector and the Index page selector should show only those index which belong to the particular fund in the index page selector for Ex: US fund has OD and MI mapping when the user select the US fund the user should only see OD and MI in the page selector not all the indexes I have created a filter module with Fund and Index dimensions but I can't apply this filter in target module as both are page selector and I need that in the same view(Fund and Index on the Page selector) I have attached the modules for the reference. Regards, Riyaz Pasha

riyazpasha · ‎05-18-2022

Hi @M.Kierepka I got the idea I need to pick up the the max date for the particular transaction type. I have added some additional checks. Yep it worked. Still lot to learn. Thanks @M.Kierepka. Keep in touch Regards, Riyaz Pasha

riyazpasha · ‎05-17-2022

Hi, I have a requirement to pull the dates in the module, the source and the target has different dimensions. Target module Source module I want the dates basis on the revolver in the target since I can't use sum function on the dates to pull it any workaround for this use case.

riyazpasha · ‎05-09-2022

Thanks for the clarification @anand.shekhawat and @Nagaraju

riyazpasha · ‎05-09-2022

Hi, Just want some clarity on the order list action in Anaplan. If I include order list action in any of the process which is being used by the end users will that action works for end users? I heard that the order list action only works for the admin. Can somebody clarify on the same Attached screenshot for reference.

riyazpasha · ‎04-26-2022

Hi @anikdas , I will go with the second option as it would not give performance issues in future. Thanks for your help

riyazpasha · ‎04-22-2022

Hi @mburdak I followed your solution and built the same logic using RANK function but when I want to lookup the Ending balance with previous ATD date, I'm getting circular reference error. I have attached the screenshot.

riyazpasha · ‎04-21-2022

Hi, I have requirement where I need to identify the first value of Borrowing line item and that value would flow into initial commitment. So I have used ISFIRSTOCCURENCE with a logic IF Borrowing <> 0 THEN ISFIRSTOCCURRENCE(Borrowing, Revolver Facility) ELSE FALSE but this will giving me two occurrence. what I need is the first value of Borrowing into the initial commitment for ex: 3/2/2022 value of Borrowing(700) into initial commitment only that value The list which I have used is custom dates list which I have created.

riyazpasha · ‎04-21-2022

Hi @mburdak , But in my case its the dates, the logic that you have applied for the weeks is sequential but for dates any idea how to use your logic as there no pattern in dates its on adhoc basis.

riyazpasha · ‎04-21-2022

Hi @mburdak , Can you please send a screenshot of Dynamic weeks. I think its list and you are using lookup for list property. If you can send me the screenshot of like how you have configured previous week that would help. Thanks

riyazpasha · ‎04-20-2022

Hi, I have a use case where I'm using the custom time dimension list in which there is a line item called Beginning balance which is the previous value of the Ending Balance. So I'm stuck as there is not native time dimension being used in the module so I can't use previous function of Anaplan. Any work around is possible? I have attached screenshot for reference

riyazpasha · ‎12-27-2021

Hi @nehanayal , Please go through the below training for the conversion and procuring of the CA certificates. https://community.anaplan.com/t5/Common-Support-Questions/Interactive-CA-Certificate-Guide/ta-p/58492 Interactive CA Certificate Guide - Anaplan Community Regards, Riyaz Pasha

riyazpasha · ‎11-11-2021

Hi @Badiop1 @TamparaDora @HarunT , Please could you check if you have created a saved view in the Data Hub model. Check the screenshot for the reference . Check the mapping for Supply chain model by navigating to source models - Check screenshot for reference Check the mappings while creating an import from the Data hub model - reference screenshot Regards, Riyaz Pasha

riyazpasha · ‎11-01-2021

Hi @Vaitesh , Even though you don't have access to all the models you need to get the right current size as you have the admin access. Its nothing to do with the authentication. As I need the Model size along with the workspace size, so I use the selenium based solution. Transactions API is the new update from the Anaplan previously it wasn't there. Calculation - size allowance/power(1024,3) - I can see that your calculation is right I suggest get the access to the models along with admin access and then try. But ideally with the above access you need to get the right size. Regards, Riyaz Pasha

riyazpasha · ‎10-29-2021

HI @Vaitesh , Yes Iam also facing that issue because of which we have switched to the selenium based scraping the workspace size and Model size. As Transaction API doesn't provide the model size so its better to switch to selenium based as you can get the size directly in the required format also the current size is in different format so I use the selenium to scrap the data for 22 workspaces which has almost 200 models. Let me know if you require any help on this. Regards, Riyaz Pasha

riyazpasha · ‎10-19-2021

Hi @DivyaAugustine, Please go through the below training for the conversion and procuring of the CA certificates. Interactive CA Certificate Guide - Anaplan Community Let me know if you need any help on the same. Regards, Riyaz Pasha

riyazpasha · ‎08-18-2021

Hi @sophiedyason , Create two line items which are I guess input and in the final value line item write the below formula. Base - Base Input - (OFFSET(Base, 1, 0) - OFFSET(Base Input, 1, 0)) Thanks, Riyaz

riyazpasha · ‎08-18-2021

Hi @AnnaM , I would like to know if this works for the below scenario. Test Model - Worksapce 1 Prod Model - Workspace 2 If there is a process which pulls the data from the test model into Prod model( As both the models are in the different workspace will this work?) Thanks, Riyaz Pasha

riyazpasha · ‎07-28-2021

Hi @Akshay07 , Can I look into your scripts.

riyazpasha · ‎07-20-2021

Hi @Akshay07 , My issue is some what similar. I'm trying to scrap the model size across the workspace and it use to work but suddenly I'm getting the internal error 500. There are lot of reason for internal 500 error below I have listed it. Internal 500 error reasons: Browser Cache. Incorrect database login credentials. Corrupted database. Corrupted files Issues with your database server. Corrupted .htaccess file and PHP memory limit. Issues with third-party plugins and themes. PHP timing out or fatal PHP errors with third-party plugins. Wrong file and folder permissions. Exhausted PHP memory limit on your server Corrupted or broken .htaccess file. Errors in CGI and Perl script. In your case looks like the file is getting uploaded to the Anaplan server but when you are running the action it throws 500 error. Could you please let me know what is the status code for file upload and actions status code? I have raised the ticket with Support team and they are trying to schedule a call to understand the issue. If I hear anything from them I keep you posted. Thanks

riyazpasha · ‎06-29-2021

Hi, I have a source model in which the model versions(default versions) product list and time as a dimensions. There is an version selection module where the user can select the base and target version for dynamic variance calculation. The target module has Product and time dimension. I need the value of the External Base looking up the versions in the version selection module. But I'm unable to as source has default versions and version selection module has line items as list formatted(Version list) which results in format mismatch error. Need help to get the variance in dynamic way as per the above requirement. I have attached the screenshots. Thanks

riyazpasha · ‎06-22-2021

Hi @Santosh , If you are looking for the File ID to automate or you have any process in which you are loading a file then below URL will help you to retrieve the file id's. https://us1a.app.anaplan.com/2/0/workspaces/{WorkspaceID}/models/{ModelID}/files just replace workspace id and Model ID

riyazpasha · ‎06-17-2021

Hi @NehaSharma , I hope I have understood your question in a right perspective Yes, you can run multiple actions that to selective actions using the Anaplan API. You need to define the action id in the script to run the actions. Below is the end point that will help you to get the list of other actions https://api.anaplan.com/2/0/workspaces/{workspaceID}/models/{modelID}/actions

riyazpasha · ‎06-17-2021

Hi @rahulnair , Your request is being tunnelled to the proxy server which means you have to provide the proxy authentication. Get the proxies via below code import urllib.request proxies = urllib.request.getproxies() print(proxies) And provide the proxy in the request call as shown below http': 'http://domain%5Cusername:password@ProxyIP:portnumber' if your password has special characters you to percent encode your password otherwise it will tunnel the request. Also check if your get request has verify=True requests.get( 'https://google.com' , verify= False )

riyazpasha · ‎05-04-2021

Hi @Deepu, You are right the error is because of the period mapping. Whenever you are running the process through the scripts you have to map the time or the period other wise the dimension does not matches and the script fails. The files will get uploaded but the actions or the process will not run de to the mapping. I don't know how you will do the mapping in the Java code but in python - {'localeName': 'en_US', 'mappingParameters': [{'entityType': 'D4_Day.S ADI', 'entityName': '2021_05_04'}]} you need to map. entity type is the date subset and entity name is the today's data because Iam uploading for today. Thanks, Riyaz Pasha

riyazpasha · ‎04-30-2021

Hi @fabien.junod , Thanks for the reply. But what Iam trying to look is if I filter for non blank then the key should in a sequence manner. In the screenshot that I see 1,4,8,13 is a key(List) I want this to be in a sequence even if I filter for non blank. Thanks

riyazpasha · ‎04-29-2021

Hi @NikolayStarostin, Iam using these end points from past one year and I didn't find an end point which gives the model activity(last time the model was opened). You will get the last Anaplan login activity. But Iam not sure Iam the model history. Thank you.