About fxlepoutre

Hello,  Exactly the same issue here.  From a blank GSheet, performance is acceptable (but really not good). From an existing GSheet with several existing tabs, performance is desastrous, up to the point where update is not possible because it times out. This happens whatever the model, module, view, cell count, etc... I have tried for more than one year now, and have made videos to explain the issue to Anaplan support, without any resolution yet. I hope this extension will improve so that we can put it in the hands of end users. Not yet possible with these performance issues. Thanks for raising the topic yet! Good day!  ... View more

Hello,   Another idea similar to this one: https://community.anaplan.com/t5/Idea-Exchange/Additional-week-formats/idi-p/34347   Also, we saw that there is the option to change the "Week Format" option in the Time settings to "Week Commencing" instead of "Numbered" (see https://community.anaplan.com/t5/Best-Practices/Untangling-Anaplan-Time-Mapping-in-Imports/ta-p/81611). This would still not allow to have Gregorian week numbers displayed in the interface, but would at least allow to have a little better understanding on which week we are in.   A cool implementation of the feature reported here would be to have the choice, in the "Week Format" option, to choose : - "Numbered" (current) - "Week Commencing" (current) - "Week Ending" (current) - "Numbered as of ISO-8601" (that would display "Week 5 FY23" for today's week)   Thanks, FX ... View more

Hi @matKa  Unfortunately not. From my understanding, Postman's javascript function "CryptoJS.HmacSHA512()" is not generating a signature as required by Anaplan of the random string. Our developers managed to do the integration in Java on their environment without the Postman example finally, but based on the Python and C# examples posted previously on the thread. If you manage to do the signature within the pre-req scripts of Postman, I'd be glad if you can share your code. Have a good day, ... View more

Hello Agreed, this would be useful ! Especially, if this default value could be depending on another line item, that would be great! Thanks ... View more

Hi @Jason_C and/or @christophe_keom  I'm sorry I don't get it. I really think I am not very far, but it still continues to fail.  😟 I now have a header looking like this: " Authorization: CACertificate LS0..... ", so it seems OK. But still a 401  FAILURE_BAD_CREDENTIAL. The full code I have in the pre-req script is the following:   function randomString(length, chars) { var result = ''; for (var i = length; i > 0; --i) result += chars[Math.floor(Math.random() * chars.length)]; return result; } var anaplan_privatekey = "-----BEGIN PRIVATE KEY-----\ MIIEvQIBADANBgkqhkiG9w0BAQEFAASCBKcwggSjAgEAAoIBAQDg/EygC4681MTB\ MToJXByMoFHhyPZNSTLtl7xRLjVNJ7N31JQLtf8Anv5e1hRcjDy4mQcPgxvhWvVa\ ..... Vcfg8G3Jbel2sz6HGjR9SohMFx038K5C2F43L5hRW0MF4dxwGYeWs3Ic0Z7CC9IR\ tgkrHJ+SKp/EFH2PhBx1xjE=\ -----END PRIVATE KEY-----" var anaplan_certificate = "-----BEGIN CERTIFICATE-----\ MIIFHzCCBAegAwIBAgIQBghdO0SjwpaGWIjw5OftnTANBgkqhkiG9w0BAQ0FADBl\ MQswCQYDVQQGEwJVUzEVMBMGA1UEChMMRGlnaUNlcnQgSW5jMRkwFwYDVQQLExB3\ ... TxAKO5P+pU1Hc8vVW2jtMY4ajNn4C2L6vUfQ0rfMW3jSrBWXlG3GJWYiYJ1BkNxJ\ tDCDJO1yEWmQjqsbcj2zY09pew==\ -----END CERTIFICATE-----" var privatekey = anaplan_privatekey.replace(/(?:\r\n|\r|\n)/g, "").replace("-----BEGIN PRIVATE KEY-----", "").replace("-----END PRIVATE KEY-----", "") var randomString = randomString(150, '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ'); var signedString = CryptoJS.HmacSHA512(randomString, privatekey); // var certificate = anaplan_certificate.replace(/(?:\r\n|\r|\n)/g, "").replace("-----BEGIN CERTIFICATE-----", "").replace("-----END CERTIFICATE-----", "") var certificate = anaplan_certificate; var randomStringBase64 = btoa(randomString); var signedStringBase64 = btoa(signedString); var certificateBase64 = btoa(certificate); console.log("privatekey: " + privatekey); console.log("randomString: " + randomString); console.log("randomStringBase64: " + randomString); console.log("signedString: " + signedString); console.log("signedStringBase64: " + signedStringBase64); console.log("certificate: " + certificate); console.log("certificateBase64: " + certificateBase64); pm.environment.set("anaplan_encodedString", randomStringBase64); pm.environment.set("anaplan_signedString", signedStringBase64); pm.environment.set("anaplan_certificate_base64", certificateBase64);   I feel like the  CryptoJS .HmacSHA512() function is not behaving like Anaplan expects. For reference, the body of the request does not change: { "encodedData": {{anaplan_encodedString}}, "encodedSignedData": {{anaplan_signedString}} } Any other ideas? Thanks a lot, FX ... View more

Hello @christophe_keom    Thanks for the hint. I juste tested your suggestion..   1. Changed my authorization header to be the following:   Authorization:CACertificate {{anaplan_certificate_base64}}    2. Added a line to the Pre-Req script:   pm.environment.set("anaplan_certificate_base64", btoa(pm.environment.get("anaplan_certificate")));     This transforms correctly my certificate value  " MIIFHzCCBAegAwIBA.............EWmQjqsbcj2zY09pew== " to "TUlJRkh6Q0NCQWVnQ........21RanFzYmNqMnpZMDlwZXc9PQ==" which corresponds to the Base64 text value of the certificate.   But still, the test gives me 401 reply, with a  "FAILURE_BAD_CREDENTIAL"  message. 😞 Any other idea?   Thanks, FX ... View more

More than a notes functionality, it should be a discussion, similar to Google Sheets: - can be opened by any user.  - users can be tagged so they get notified.  - comments/replies can be added to the initial cell comment. - cell with discussion can be identified clearly (compared to cell without discussion )  - all module's discussions can accessible from one feed, with read/unread status, with reference to related cell.   This would ease a lot collaboration on data that is planned in Anaplan, and avoid lots of emails with screenshots and back and forths to Anaplan model.  ... View more

Hello @Jason_C  and @anirudh  By any chance do you have any clue on what I should do so the Postman script to login with certificate that I posted just before would work? I suspect CryptoJS.HmacSHA512 to give me a wrong value, but I'm really not sure. Thanks a lot, FX ... View more

Hello,   Based on your code samples, I tried to create a Postman pre-request script that allows me to generate the authentication header. However, Anaplan keeps sending me back a 401 ( FAILURE_BAD_CREDENTIAL ).   Here is my request:   POST /token/authenticate HTTP/1.1 Host: auth.anaplan.com Authorization: CACertificate {{anaplan_certificate}} Content-Type: application/json { "encodedData": {{anaplan_encodedString}}, "encodedSignedData": {{anaplan_signedString}} }   And here is my pre-request script:   function randomString(length, chars) { var result = ''; for (var i = length; i > 0; --i) result += chars[Math.floor(Math.random() * chars.length)]; return result; } var randomString = randomString(150, '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ'); var signedString = CryptoJS.HmacSHA512(randomString, pm.environment.get("anaplan_secretkey")); pm.environment.set("anaplan_encodedString", btoa(randomString)); pm.environment.set("anaplan_signedString", btoa(signedString));     The Postman environment variable "anaplan_certificate" contains the content of my certificate file, without "-----BEGIN CERTIFICATE-----" and "-----END CERTIFICATE-----" and where I removed all CR and LF characters. It's basically just a very long string looking like "MIIFHzCCBAegAwIBA.............EWmQjqsbcj2zY09pew==". The Postman environment variable "anaplan_secretkey" contains the content of my certificate file, without "-----BEGIN PRIVATE KEY-----" and "-----END PRIVATE KEY-----" and where I removed all CR and LF characters. It's basically just a very long string looking like "MIIEvQIBADANBgk.............RtgkrHJ+SKp/EFH2PhBx1xjE=".   The certificate is correctly imported on my Anaplan administration console too.       Any idea on what I am doing wrong?   Thanks for your help, FX ... View more

Hello Jason,   I'm just starting with certificates, and am a bit struggling there. I already collected my certificate from my CA and imported it in Anaplan Administration.   So I have the following files: - userAnaplan .cnf:  the config file that helped me generate my private Key file and my CSR - userAnaplan.csr: the CSR generated from the CNF file - userAnaplan.key: the private key file generated from the CNF file - userAnaplan.p7b: the certificate issued by my CA based on the CSR - userAnaplan.pem: the certificate extracted from the P7B file   And now I want to do a first login to Anaplan API, using the  auth.anaplan.com/token/authenticate URI. I already managed to get a token using a username and password, but struggle with the certificate.   I downloaded your Postman sample, but could you detail a little more please how do you generate the data for the different fields: -  {{ca cert value}} -  encodedData -  encodedSignedData Which command lines or tools do you use to generate the base64 versions of the data using the files above?   Thanks a lot, FX ... View more