- Community
- :
- About fxlepoutre
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 fxlepoutre
since
06-07-2018
4 weeks ago
fxlepoutre
Contributor
Activity Feed for fxlepoutre
- Got a Kudo for Use Gregorian calendar week numbers instead of fiscal week numbers. 06-24-2021 09:47 AM
- Got a Kudo for Use Gregorian calendar week numbers instead of fiscal week numbers. 06-08-2021 06:41 AM
- Got a Kudo for Use Gregorian calendar week numbers instead of fiscal week numbers. 06-08-2021 06:40 AM
- Posted Re: api v2 - POSTMAN examples on Anaplan Platform. 05-10-2021 12:12 PM
- Got a Kudo for Re: api v2 - POSTMAN examples. 04-29-2021 06:12 AM
- Posted Re: Capability to define a Default Value on Idea Exchange. 03-31-2021 07:49 AM
- Kudoed Capability to define a Default Value for jeremy.paulmaz. 03-31-2021 07:32 AM
- Posted Re: api v2 - POSTMAN examples on Anaplan Platform. 03-05-2021 05:25 AM
- Kudoed Google Sheets Add-on: remove connection owner limitation for heron. 02-26-2021 01:26 PM
- Posted Re: api v2 - POSTMAN examples on Anaplan Platform. 02-03-2021 07:59 AM
- Got a Kudo for Use Gregorian calendar week numbers instead of fiscal week numbers. 12-17-2020 03:26 AM
- Kudoed Shared weeks (splited by months) for Kavadera. 12-10-2020 11:13 AM
- Got a Kudo for Use Gregorian calendar week numbers instead of fiscal week numbers. 12-04-2020 04:17 AM
- Got a Kudo for Use Gregorian calendar week numbers instead of fiscal week numbers. 12-04-2020 04:13 AM
- Got a Kudo for Use Gregorian calendar week numbers instead of fiscal week numbers. 11-25-2020 06:28 AM
- Kudoed Auto size columns for AnaplanIdeas. 11-24-2020 08:47 PM
- Kudoed Allow "full access" users to update user list via import process for bdeaton. 11-24-2020 08:46 PM
- Kudoed Suggestion: Copy a Dash board Component to another existing Dashboard for jpause. 11-24-2020 08:45 PM
- Kudoed Refresh directly on Dashboard for AnaplanIdeas. 11-24-2020 08:44 PM
- Kudoed Import Current Period for rachel.bisch. 11-24-2020 08:44 PM
05-10-2021
12:12 PM
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
03-31-2021
07:49 AM
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
03-05-2021
05:25 AM
1 Kudo
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
02-03-2021
07:59 AM
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
11-24-2020
08:32 PM
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
11-24-2020
08:22 PM
7 Kudos
Hello community, Currently Anaplan uses its own week numbering to determine the week number. When fiscal period is different from jan-dec, then week numbers do not match at all with calendar week numbers as defined in ISO 8601. This makes it very confusing for users to adapt to these new week numbers, especially when users need to communicate with other parties (suppliers, customers) that do not rely on the same fiscal calendar. Typical example of confusion is those discussions: "When we discuss about W13, is this in the calendar or is this in your own fiscal calendar?" or "Which date is that week?". Answers to these questions are obvious when everyone uses ISO 8601 calendar that is displayed in Google Calendar, Windows and Microsoft Outlook. Therefore, Anaplan should have the option, in module's time settings, to use ISO week numbers instead of fiscal week numbers as a way to refer to weeks in Anaplan. This would then change the label of all weeks in the Time dimension, and would be used for display, but also for exports and imports. Of course, this would mean that first week of fiscal year might not be week 1, but that's a minor setback for the user, because this is only very internal to the company's finance team. Thanks a lot for your upvotes. FX
... View more
See more ideas labeled with:
10-30-2020
11:08 AM
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
09-22-2020
04:37 AM
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
09-10-2020
11:08 AM
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
09-08-2020
11:08 AM
Hello Nathan, Thanks for your reply. I understand the benefits of such a method indeed. It's much easier afterwards to get the pricing at a specific date, week, month... etc... As @nikolay_denisov states, I really have very few pricing changes (most products will never have), so adding the time dimension creates quite a huge amount of cells, that's the only drawback.
... View more
09-08-2020
05:29 AM
Hello Anaplan community, I'd like to create a model that stores prices for my items, and the evolution of these prices. A few constraints though: Prices can evolve with time, and the applicable price at one date can be different from the applicable price at another date. Products don't change prices at the same time, and changes in prices don't happen so often (perhaps once a year or once every two years). The active price is the latest price input. I'd like to be able to easily gather the current price for one or more products, or their prices at a specific date. I'd also like to keep track of the history of price changes to have a neat view of the price evolution of a product. It must be quite simple to input the prices for many products in bulk. I thought about a few solutions: Create a module where time is a dimension, and products also, with a line item with the product price, but: I find it really heavy to maintain the price for each day/week/month/year (depending on the time granularity) for each product The price may change at a specific date/time, in the middle of the week/month/year Create a numbered list where each item would be the n-th price of the product, and create a module with that list and the list of products and two line items (one with the product price, one with the effective date), but: Getting the current active price, or the price at a specific date seems complicated, as it may be on a different item of the n-th change list. Changing latest prices in bulk seems complicated too. What would be your recommendation on how to handle this? Thanks a lot, FX
... View more
Labels:
05-19-2020
08:50 AM
5 Kudos
Hello @JaredDolich , I finally found another technique that solved my issue, using the "cumulate" formula, and resetting it at every month change. It looks slightly dirty, but it happens to work fine and achieve the desired result of using my daily figures in the most accurate way possible. So here are the line items that I ended with: In a system module at the "Day" level: - mid-month date => using the 15th of the month assures me to always find the proper Gregorian calendar month for that day (should work well whatever your time settings). - start => getting the first calendar day of the Gregorian calendar month - end => getting the last calendar day of the Gregorian calendar month - calendarMonth => Getting the Gregorian calendar month of the date, as a Time Period. In a calculation module, at a Day level also: - netSalesByDay => the input, which are the sales quantities, for every day of the 445 calendar. - monthlySalesOver445Calendar => the monthly total of the 445 calendar sales, for the assigned Gregorian calendar month of each day - cumulatedSalesOverGregorianCalendar => cumulates the daily sales, but resets every time we change calendar month. - monthlySalesOverGregorianCalendar => returns the cumulated sum for the last day of the assigned Gregorian calendar month of each day, which corresponds to the total monthly sales of the Gregorian calendar month. (the orange column of the initial screenshot) - adjustedNetSalesByDay => returns the adjusted daily figure, proportionally distributed according to the monthly sales (the green column in the initial screenshot). Hope it can help someone else. Cheers, FX
... View more
05-15-2020
02:49 AM
Hello Jared, Thank you for your quick answer and for sharing this article in advance. I assume that I need to run this "adjusted sales" calculation in a Month time scaled line item, and then use that figure in my orange column as a MONTHVALUE("adjusted sales") ? Correct me if I am wrong, but your method seems to be going from a month level to another month level, and doesn't seem to take into account the daily values. For instance, if the month ends a Friday, and there are no sales on Saturday and Sunday, there should be nothing moved to the next month. How do you handle that? Thanks, FX
... View more
05-14-2020
04:18 PM
Hello community, I am trying to adjust my daily sales forecast so that the monthly calendar total matches the monthly "weekly-calendar" total, while keeping my seasonality as close to reality as possible. A simple picture will tell more than 100 words. .Spreadsheet here: https://docs.google.com/spreadsheets/d/1rL4AnoCCTUAX9zXmF0tW6wRhvYhddUdm_buRgf_5G9s/edit?usp=sharing I am trying to get the green column 'resultNetSales'. In order to do that, I need the orange column ' sum of daily sales over calendar month ' to compute the sum of all netSalesEuroByDay that have the same calendarMonth as the current day. In Excel, I would simply use the " = SUMIF ( $F$6:$F , F8 , $D$6:$D ) " formula. I would have expected the formula " netSalesEuroByDay [ SUM: calendarMonth ] " to give me that result, but it keeps throwing a horrible error: Any idea on what formula to put in my orange column? Or another way of achieving the result column differently? Thanks a lot, FX
... View more
Labels:
My Accepted Solutions
| Subject | Views | Posted |
|---|---|---|
| 1065 | 05-19-2020 08:50 AM |
My kudoed posts
| Subject | Kudos | Posted |
|---|---|---|
| 1 | 03-05-2021 05:25 AM | |
| 7 | 11-24-2020 08:22 PM | |
| 5 | 05-19-2020 08:50 AM |
My Top Kudoed Posts
My kudoed posts
| Subject | Kudos | Posted |
|---|---|---|
| 1 | 03-05-2021 05:25 AM | |
| 7 | 11-24-2020 08:22 PM | |
| 5 | 05-19-2020 08:50 AM |
Posts I kudoed
| Subject | Kudos | Author | Latest Post |
|---|---|---|---|
| 33 | |||
| 20 | |||
| 25 | |||
| 55 | |||
| 14 |