About MaartenGijbels

MaartenGijbels

Hi, Currently the hierarchy filter does not work if a selection (e.g. levels or specific elements) is applied over the dimension. While this would be useful in some cases with a high number of levels in the dimension or in the case you only want to show specific elements of that dimension and it's parent. Thanks,

MaartenGijbels · ‎02-04-2021

Could you share the reason why the request was denied? I can imagine multiple uses where this could be very usefull.

MaartenGijbels · ‎01-29-2021

There is a better way. Link multiple models to one app and make the changes in the pages on your DEV. But only publish after pushing the revision tag to prod. Here's an article.

MaartenGijbels · ‎01-29-2021

typically it goes pretty fast. Did you verify if you completed the final activities? Such as uploading history and downloading the certificate et cetera?

MaartenGijbels · ‎01-12-2021

I'm not aware of anything that you could access to follow that up. Have you considered using certificates? They are valid for a year so require less maintenance. All the best,

MaartenGijbels · ‎01-04-2021

Hi all, They TEXTLIST-function isn't allowed over the USER-list while this would be helpful in some cases. Can this be altered? All the best,

MaartenGijbels · ‎01-04-2021

Hi all, It would be helpful if we could control selective access via a sort of system module with booleans. This would allow a relatively standard import to update access that can be done by regular users if set up by the admin As well as enable some extended filtering capabilities and references per user to be made. all the best,

MaartenGijbels · ‎12-01-2020

Hi All, I'm trying to add all users with selective access to in CC of an email to be send via "MAILTO". But can't seem to get it working. Did anybody already try something similar? Thanks,

MaartenGijbels · ‎11-17-2020

Hi @saurabhkc You can change the default time list to some week options in the Time-tab: Brining the montly value to a week could be done by the formula 'monthvalue' as explained here All the best

MaartenGijbels · ‎11-17-2020

code is a function that needs to be applied to a specific list. There is an explanation here

MaartenGijbels · ‎10-20-2020

The problem is that in that case I would hardcode a fixed number of allowed iterations... Which could, in theory, expand in the future. So I might provide for 4 iterations, but would need 5 in one month...

MaartenGijbels · ‎10-20-2020

You can do the create via Forms. Delete can be mimicked with some kind of selection and a "delete from list using selection"

MaartenGijbels · ‎10-20-2020

I have a case where I want to allow Anaplan to make circular references, what do I want to do? Basically to make a coffee I need: 1 Cup 1 cookie 50 grams of flour 5 grams of butter ... 150 ml of coffee 160 ml of water 3 grams of coffee powder So when I needs 2 cups of coffee I can go down the "hierarchy" and calculate how much I need of everything. Ending up in my base components (cup, flour, butter, water and coffee powder) But I can't find an elegant way to do this... Any ideas/opinions? Thanks,

MaartenGijbels · ‎09-29-2020

Weird, the issue you have seems to be similar to what you get if you try to match a numbered list on names. Based on what I'm seeing, I assume the list is numbered? Could you alter the descriptions to be different from the codes? It's a hail mary but that might confuse Anaplan.

MaartenGijbels · ‎09-29-2020

Could you post a screenshot of the column headers in the file and the list in Anaplan?

MaartenGijbels · ‎09-18-2020

First of all, congratulations on passing L2! Via the academy you can take a virtual lesson of "the anaplan way", I've heard good review about this. So this is probably the best option. There is also the option to do it in person via a classroom training provided by Anaplan or if your company invites a trainer. But that's very dependant on what's possible in your region due to COVID.

MaartenGijbels · ‎09-01-2020

Hi @nimesha , On the screen of your 2nd and 3rd step you see additional tabs. (1 for the employee list and 1 for the line items.) Could you open these? This is were the mapping comes into play. Do the employees in your first column automatically map with the employees in your list? Do the column headers link to the line items? All the best,

MaartenGijbels · ‎08-31-2020

It's a bit of a pain, But could you add a screenshot of your source and every tab within the import process? That will probably clarify a lot. You could prepare by paying specific attention to tabs that are suspiciously empty. Maarten

MaartenGijbels · ‎08-31-2020

Hi @nimesha , The easiest, and best practice, is to have codes everywhere. Once you link the column to the list the mapping should be there automatically. If that's not possible you could always open the tab of the specific list and switch to manual mapping. There you can link the elements as you wish. There is a bit more meat around this topic here. All the best,

MaartenGijbels · ‎08-21-2020

Hi @cbeh , Even though the L2-training is now 1 year in use, there are still some errors in them. In my point of view you are right. Also note that the second solution would prevent users from being able to view/read the total value for all products. Best thing to do is to flag this to Academy@Anaplan.com. All the best,

MaartenGijbels · ‎08-19-2020

@Ana_22 , The number given by @Misbah is correct, but it's a consecutive number. So even if you delete values they still count in this. It's a nuance that usually isn't an issue, but if you have a large list that is completely cleared overnight (delete all items) and recreated this could add up significantly and in time reach the limit. All the best, Maarten.

MaartenGijbels · ‎08-19-2020

Hi @rie1995 , To my knowledge they currently have servers in the USA that serves the clients in the Americas and APAC, and servers in the Netherlands that serve the European clients. So if your client can't have the data being stored outside of it's home (presumably Saudi Arabia) that could be an issue. It's a question we receive regularly from our German clients, Anaplan is working on a collaboration with AWS to host specific models within Germany. Presumably a similar solution could be created for Saudi Arabia, given the assumption that a partner can be found to do the hostings. But it's something you best take up with the Anaplan-team to clearly specify the need. (Some of this info might be out of date as it's been a while since I've had the last update.) All the best,

MaartenGijbels · ‎08-06-2020

Hi Maggie, This is probably related to the clear module prior to import. Typically this is controlled by 2 things: - the settings on the top left of the import pages (all pages, so the mapping of columns to lists/line items and each dedicated tab per list or the line items.) - the cells available/included in the data set you're loading. I'd look on Anapedia with regards to those clear-functionalities and feel free to link back if something is unclear. Kind regards, Maarten.

MaartenGijbels · ‎07-28-2020

Hi @Hend , In my knowledge there is no connection with Google cloud or apigee. Depending on what you want to do, you could use a tool to make a regular download of a document on Google to a fixed location to be picked up by Anaplan connect. Or use anaplan connect to generate an extract on a regular basis that is then picked up by a scheduler and put on Google cloud Depending on your goal and what you want to do off course. All the best, Maarten.

MaartenGijbels · ‎07-03-2020

Hi @Ankitjain , It is possible when you create a page: (Please note: my organization has not enabled that functionality.) All the best,

MaartenGijbels · ‎07-03-2020

Yes, unless you add that filter to a filter line item that was already used. => this might be a bit to abstract. For example: Month product amount filter (amount>0) Jan laptop 5 true Jan iphone 0 false Jan laptop 6 true Jan iphone 2 true is the original view on which you created the export. Filter on true. Adjusting the formula of the filter would "update" your export automatically. For example: only true for values bigger than 0 and the current month. All the best,

MaartenGijbels · ‎06-12-2020

Hi @KokiS , There is no function for this, but you can "recreate" it yourself via the different available functions. I'd have a look at the PREVIOUS() function. All the best, Maarten.

MaartenGijbels · ‎06-08-2020

Hi Sunil, It appears that you do have a time range in your module. I would verify the module, remove the time scale and reload the data. All the best, Maarten.

MaartenGijbels · ‎06-05-2020

Hi, Anaplan needs to be "pushed", you'll have to set up a file watcher on a computer and have it check for new files on relatively short intervals. Then you could use that to trigger an action via anaplan connect. But it's not natively available. All the best, Maarten.

MaartenGijbels · ‎06-05-2020

Hi, I agree with @Misbah that a DEV-model is very valuable when there is a lot of data validation/internal logic. But it should only be done in that case, if it is a straight forward data repository: don't bother. However: I would never split up a DH-over geographies. IF size becomes a significant issue I'd prefer to split it over logical blocks. As some models would else have to connect to multiple data hubs to compose 1 list... The best practice should be 1 data hub if possible. All the best, Maarten.