About MaartenGijbels

MaartenGijbels

Hi @praba71 , Are you typing the formula? I'd add ' before and after the line item. Probably he just gets stuck with the ()'s in your LI-name. All the best,

MaartenGijbels

Hi pratyaksh.dua@polestarllp.com , You could create a separate line item do flag for formatting that is only filled in for that specific version. Then you could use that as the "Based on the values from". The exact details will be dependant on what you want to format and under what conditions. But it should get you started. All the best,

MaartenGijbels

Hi @jasonblinn , Anaplan explains it better than I could here. There are some conditions to be met, but it is possible. All the best, Maarten.

MaartenGijbels

Hi @lps In general it is sufficient to ensure 2 things: - Users need to have access to everything so they can open the dashboard in question - ensure the dashboard is available in the contents-panel via the "content"-tab It's also obvious that you could check that other user groups don't have it in their contents panel. Maarten.

MaartenGijbels

Hi All, It would be useful to be able to do conditional formatting per user. For example: allow the user to set a personal threshold for a certain line item and formatting adjusts automatically to ... A default current user filter already exists within the filter options. E.g.: However, it's impossible to do with conditional formatting. Unless you dimensionalise the relevant line item over users. Unfortunately that significantly increases the size in just about any case...) All the best,

MaartenGijbels

Hi @Star , I would agree with both you and @Misbah . But have you considered an alternative solution: By using a input module and having the user make a selection within a Line Item, preferably dimensionalised by user. You could drive a filter module linked to the view. So your table would be time synchronised with the selection, but not with other tables. All the best,

MaartenGijbels

You could probably "fake" it using duplicate line items. Line Item 1: "Upload": here you load the value with decimals. Line Item 2: "Reference": here you reference the other line item without decimals, set summary settings to formula. All the best,

MaartenGijbels

Hello, I'm not familiar enough with the technical aspects of Anaplan Connect to answer that. I know the authentication in A.O. is different for a "normal" workspace and SSO. So there could be an impact. But again, the only way to be sure is to test it. You could also reach out to support (support@anaplan.com) to ask the question. They might have more information on the background.

MaartenGijbels

Hi Mao, If it's the same tenant I do not see why this wouldn't work. When the user is logged in, they see both workspaces no? The easiest way to determine it is to try. All the best,

MaartenGijbels

Hi @nishantgarg , As far as I know that probably isn't possible in the old UX. Within the new UX you can change that setting. The only way to do that in the old UX is via the security, but as you are an admin you can't change that for yourself. A possibility is to work with ALM. An interesting article can be found here. This would prevent you from changing production data. All the best, Maarten.

MaartenGijbels

Hi Why don't you just use a custom list? A list specifying: 2016 Q1 2016 Q2 ... 2020 Q4? This could also be done using 2 lists: Year: 2015, 2016, ... , 2020 Quarters: Q1, Q2, Q3, Q4 Both would require only 1 line item and the size would be roughly the same. Something to consider: Anaplan is not designed for storage of data/information. Using it as a data warehouse can become quite costly due to the size-implications. So it might be good to consider alternative solutions. All the best, Maarten.

MaartenGijbels

Hi @Star , Hi @johndorma, Although I agree that you can use a functional area to open that. I would be very careful. (Mis)using the functional area's to act as an action button to open a set of dashboards can be dangerous: - a dashboard can only have 1 functional area; - functional areas are supposed to be used to group dashboards in logical groups; Both could be at risk. This off course needs to be checked with the user stories... Maarten

MaartenGijbels

In principal data can be imported in every module. It's a matter of getting the file "right" to map every list and relevant line item. So it could be more work then benefit. In some cases it might be more interesting to manually copy/paste certain specific fields or parts of a dataset. All the best, Maarten

MaartenGijbels

Hi all, It would be interesting to set a default colour palette per workspace/app/... in order to customize to the client. Currently everything has to be changed manual for each chart & graph. On top of that actions et cetera are always blue. All the best,

MaartenGijbels

Hi all, It would be interesting to have a logaritmic scale for an axis of a graph. This would allow for a cleaner view when there are big differences in the values or show an exponential growthcurve in linear way. All the best,

MaartenGijbels

Hi @Star , 1) No, opening a dashboard will require a "click". (With an exception for the landing-page.) 2) Users have access to all dashboards for which they have the necessary read/write permissions for all elements on that dashboard. So if you restrict their access for a module used they should no longer have access. Note: this is considerably easier in the new UX as you can set access by role. All the best,

MaartenGijbels

Hi @Catheline , Great to hear it works! This means: - the process works fine; - the anaplan connect batch file is set up correctly => the issue is in security. When you have more time: It would be worth while investigating if the FULL ACCESS has all the required read, write, access settings, ... Do not forget about any selective access that might have been set. All the best, Maarten.

MaartenGijbels

Hi @sharmagh , If the time scale is in the applies to it will have to be visible. Else you can't identify which week (or aggregation) you'd like to see in the view/module. You could hide it in the dashboards or worksheets. Or build a module without the time scale. A bit depending on what you'd like to do with it. Maybe a good question to ask yourself is: if I don't need to see it/be able to filter by it. Why do I need it there? Maarten.

MaartenGijbels

The normal comparisons work. Something like IF List.Property = Name( TEST 2 ) then TRUE else FALSE => Apple = Samsung => False => Apple = Apple => TRUE The bold part is just to make it more visual, functions exactly the same without. => best practice.

MaartenGijbels

Hi, Depending on what you would like to do with it there are probably easier solutions. And not even a need for a workaround. I'd assume your current solution isn't optimal from a performance, size and usability perspective. But depending on the settings of the line items you could use functions like NAME() to make some comparisons.Or bluntly compare the line item TEST 2 with the ITEM()-function/property you are using to name it. In case this isn't detailed enough, please provide the following information: - display name used: text or list? What list? - blueprint view of the module; All the best, Maarten.

MaartenGijbels

Hi @Star , There is a difference between exporting a view and using that view as the basis for an import. They are 2 different actions. The export view might contain those filters why the import view does not. All the best,

MaartenGijbels

Hi Catheline, Can you try with him as an "Admin"? That should ensure all security requirements are met... If it's something else we'll need more information. Like the scripts, detailed errors, ... All the best,

MaartenGijbels

Can you ensure the export-view is used as a base. This can be easily done via the actions - imports:

MaartenGijbels

@Srinivas_Gudi , Are you referencing the line item with the post function or the post function itself?

MaartenGijbels

Hi @Catheline , Anaplan connect requires a user, does that user have all required access-rights? Maybe try to run the script with your personal username and password to verify if it would work the same. It's a bit of a guess, but it's the error you get when the sources are different. So it would be the most obvious cause.. All the best,

MaartenGijbels

Hi @Srinivas_Gudi , It could be related to a lot of things, but in principle it should work. Have you considered breaking up the formula in multiple parts? By using a separate line item for the value if true, value if false and the actual IF-condition it typically helps you to structure. All the best, Maarten.

MaartenGijbels

Hi @niti, I believe it should reference the offsetted ending inventory. As this would be the case in a real world scenario. In my experience, things like this are best flagged to the academy via email. They sometimes take their time but they ussually straighten it out for future purposes. All the best,

MaartenGijbels

Hi @Star They shouldn't be different, they are just 2 ways of achieving the same thing. All the best,

MaartenGijbels

Hi Ips, I made a small draft, and will include some screenshots. It's based on random things, so it won't be exactly the same as your L1. The lists: Hierarchy: A module with inventory on PRODUCT-level: And a module with PRODUCT FAMILY in the applies to: (I didn't even bother to fill in the Line Items here) The dashboard: Publish selector from the SYS PRODUCT FAMILY-module: Publish a view from the module, I chose this: On the dashboard you get this: A page selector containing only the options for PRODUCT FAMILY, a selection here automatically drives the table below. But the table also allows to select a lower granularity (a product.) Have a look and see if that works for you. All the best,

MaartenGijbels

Yes, you could do exactly the same as you did for the PRODUCT-list. However starting from the higher level dimension. In essence this means starting from a module that uses the PRODUCT FAMILY in its applies to to create the selectors. More info can be found here.