About CommunityMember131357

CommunityMember131357 · ‎09-18-2020

Please help understand the reason to assign a parent to a particular line item?

CommunityMember131357 · ‎09-08-2020

Hi @nikolay, Thanks for your help. This way we have been able to execute the formula. But however both the lists had same parent i.e. 'All Categories'. So any idea why this happened?

CommunityMember131357 · ‎09-07-2020

Hi @Misbah, Thanks for your reply. I have removed P4 List Dimension from the target module and kept only in the source module but still it's not working and giving me the same error.

CommunityMember131357 · ‎09-07-2020

Hi @Misbah , Thanks for your reply but however the target and the source module both have the list 'P4 Brand' as a dimension. So, any idea on around why this is happening? Thanks in advance!

CommunityMember131357 · ‎09-07-2020

Hi @Misbah, @filip.sypniewski , @Kanishq17 I am writing the formula after selecting it directly from the list only. Attached is the screenshot of the formula and the error that I am getting. Thanks in advance for your help.

CommunityMember131357 · ‎09-07-2020

Hi All, I wanted to understand that on applying DCA on a line item as I am making only certain values to the end users readable. So as my that line item with DCA is getting referred in another line item for the calculation purpose. So will DCA read access in anyway hamper the calculations or will the calculations will not be impacted in anyway and DCA will just control the way values are appearing to the end users for the particular line item where it is applied.

CommunityMember131357 · ‎09-07-2020

Hi @filip.sypniewski, Thanks for your response. I understand that the code will be unique so the element will end up at the selected parent. But what if on a dashboard the users are assigning child items to the parent where the parent list does not have corresponding codes present. How will we come to know that to which parent member the child has got assigned so does it by default will get added to the first parent in case of duplication or how does it work?

CommunityMember131357 · ‎09-04-2020

Hi, I have a list of 'Brands' which is a production list. I know that 'select' function does not work with prod list members however, it should work with the list top member/ highest level . But when I am using it with the highest level i.e. 'All Categories' I am getting an error that the list member or version is not recognised in the model. Please help me understand the reason/ meaning of this particular error. Thanks in advance!

CommunityMember131357 · ‎09-01-2020

Hi @Misbah, The target module has brand and channel as dimension because in the target module we have other values coming from other source modules like volume and gross sales which are user input at this level. Moreover it will not be possible to split the values equally at each list level as we intent to show the value at each branch (or subsequent list Items) 0 and only the summary to display the correct total value.

CommunityMember131357 · ‎08-31-2020

Hi, I have a module created with dimensions rate area, brand and channel. However, I have another module where the user inputs the values only at rate area and department level. So from the module where the user inputs the values we are getting it into the module with extra dimensions(i.e. brand and channel) thereby causing the values to get repeated on each brand and each channel. So, is there any way to control this so that the values come only at summary level like on each rate area but only at all brands and all channels instead of throwing same value at each brand and each channel. Request your help on the same. Thanks in advance!

CommunityMember131357 · ‎07-27-2020

No, DCA has not been enabled.

CommunityMember131357 · ‎07-27-2020

No.. DCA has not been enabled.

CommunityMember131357 · ‎07-27-2020

Hi All, I am facing an issue in the import action button set on a dashboard. The action button allows the users to upload the excel file in anaplan but after the upload is complete the details show that import process is successful and show nothing under the updated, ignored and failed sections and hence no data appears in anaplan. However, for some of the users (WSA, nor WSA nor SSO users) it is working fine but most of the SSO enabled users are facing this issue. Please help me resolve this issue. Thanks in advance.

CommunityMember131357 · ‎07-08-2020

@Misbah Yes I have done that the dimensions for market share% lookup are brands, channel,rate area and a customised list header. For the calculation of denominator I have created another line item with dimension as segment,rate area,channel and list headers. But as soon as in ratio formula I applying it I am repeatedly getting the error of dimension mismatch as the numerator values are coming at brand level but denominator at segment level.

CommunityMember131357 · ‎07-08-2020

@Misbah, Whenever I am trying to apply I am getting an error of dimension mismatch while applying this as ratio formula.

CommunityMember131357 · ‎07-08-2020

How do I do that my denominator has lookup in the formula

CommunityMember131357 · ‎07-08-2020

Hi @nathan_rudman, Can you please help me understand on how to apply formula to summary. I am not being able to execute it. Thanks in advance.

CommunityMember131357 · ‎07-08-2020

Hi @Misbah The calculations are suppose to be as follows: SB1 Values A 200 B 300 C 400 SB2 values Value of A market share% child of A D 50 200 25% child of A E 50 200 25% child of A F 50 200 25% parent A 200 200 100% However in Anaplan when I am performing this calculation, the percentages are being calculated correctly for all the child list items but not for the parent SB1 market share%. The reason being is that numerator calculations are correct but however when the denominator calculation is concerned for the parent it is taking sum of all parent values of the brands i.e dividing 200 by 600 as shown below: SB2 values Value of A market share% in Anaplan child of A D 50 200 25% child of A E 50 200 25% child of A F 50 200 25% parent A 200 600 33% I want to restrict the summary of denominator to formula instead of sum but I am not being able to due to the presence of lookup. I'll be really thankful to you if you could help me resolve this or provide me an alternative solution for the same.

CommunityMember131357 · ‎07-08-2020

Hi All, I am facing an issue in the calculation of percentages at summary level.I have a module where I have a percentage calculation field where the percentages are calculated and are imported to another line item from there in the same module. As the second line item displays the option of user inputting the value under one of the headers but displays the calculated imported values under the other headers. So the summary option of the 2nd line item where data is imported and is input by the user is kept as ratio to display the correct values at summary. This is because the summary level calculations of percentages is not imported.However the summary level calculation is not coming out to be correct the formula used in ratio summary is of (volume of each child(brand)/ Volume of its parent(segment)). For all the particular brands the summary calculation is correct at an all country level, at all channel level. But the percentage calculation of the segments i.e. of the parents is coming incorrect as the denominator calculation tends to add up for all the respective brand i.e. diving each segment value by 5 times of its sum if 5 brands lie under it.Therefore the resultant value is never coming to be 100%. I have attached the images for your reference. Requesting your help on this as this is very crucial. FYI: The first Market share% is the line item from which the values are imported to market share% line item which has no formula at the most granular level and are coming correct. The market share% for lookup is the denominator in the ratio which is coming to be incorrect at SB1 segment level (which is the parent of SB2 Segment Brand child list) however the calculations for SB2 Segment brand are coming to be correct at any of the summary levels. Please help me resolve this to get answers at parent level also Thanks

CommunityMember131357 · ‎07-03-2020

Hi All, I am working on a model in which I have a combination list(A numbered list with various properties such as states, product, factories) applied to a module. When I am creating my excel sheet for that particular module using excel add in version 3.4 I am getting all the combinations of the list irrespective of the fact that I have access to only one state and can see data of that particular state only in my excel sheet. But despite of this I am getting the list of all the combinations in my excel sheet with no data information. FYI: We have applied DCA in the write access of the module which is controlling the information that is getting retrieved to me in excel. Further, to this selective access can not be applied to this particular combination list as it is a flat list and it is not possible to make it a hierarchical list and moreover the combinations keep getting updated. So is there any way to control the list information accessible to me in excel such that only the combinations of my particular state are retrieved to me using excel add in version 3.4. Thanks in advance.

CommunityMember131357 · ‎06-30-2020

@Misbah ,Thanks for your response. Also, Can you please help me understand on how to control the access in excel add in. Example: I have a module created with dimension as combination list. So if a particular person belonging to one state should only retrieve the information of his particular region i.e. the list getting retrieved in excel should contain combinations only of his regions and data with respect to and not others. So is there any way to control this. As in Anaplan we have applied DCA (for write access) to restrict the data being input by the user in his particular region only but when The read/ write connection is being created in excel it is retrieving the entire information of all the regions.

CommunityMember131357 · ‎06-30-2020

@Misbah, Thankyou for your reply. Also as the list item or line item will get automatically added, so will it just get automatically added in the filter and require us to select it or will it start appearing automatically in the sheet? As currently in the display in excel sheet we have selected line items or list items appearing through the pivot and filter option. Thanking you in advance.l

CommunityMember131357 · ‎06-30-2020

Hi All, I just wanted to understand few things about excel add-in feature in anaplan: 1. When I use pivot and filter to generate a view in excel using excel add in through anaplan and later the list which has been filtered in my excel ammends or changes in the module(e.g a new item has been added to the list or an existing item has been removed from the list) then how will the changes be reflected. Do I have to select that new list item in pivot and filter option to make it visible in excel or will it automatically start appearing. Secondly, if the list item has been removed from the list during ammendment then will it show me an error on clicking refresh button or will that list item automatically disappear? 2. When a new line item has been added to the module will it automatically start appearing in the module or will it have to be selected in the pivot and filter option to make it visible as I am filtering out the line items and showing only specific line items in the excel sheet. 3. I had created my excel worksheets using excel add in but now that model was copied and archived and currently we are using the unarchived version of that archived model. So, whenever I click on refresh button this gives me an error. So does it mean that the connection no longer exists and I will have to create new worksheets? 4. Once I have used pivot and filter and have saved my worksheet so whenever I refresh it or login and log out from anaplan through excel addin, will my format be always preserved? 5. Any kind of formula (using Vlookup) or formatting in excel applied will it be preserved always? I'll be very thankful to you. If you could provide me the answer of the above mentioned questions. Thanks in advance.

CommunityMember131357 · ‎06-17-2020

@einas.ibrahim, Thanks a lot for this.

CommunityMember131357 · ‎06-17-2020

@Misbah okay.. Thanks.. Can you please also help me understand how do we create such a view by sorting such that we get the summmary FY21 first and then the respective months as I am not beingable to replicate it. As shown in the first and second image.

CommunityMember131357 · ‎06-17-2020

@Misbah , thankyou for your response. No, as you can see in the image the second table is also not updated automatically with FY21 months ie. July20 to jun21. With respect to First table yes these are subsidiary views but I can not create another module for reporting line items. Is there any other way around?

CommunityMember131357 · ‎06-17-2020

Hi @Misbah I have these two tables published on dashboards by creating saved views in the module. How do you suggest me to publish them so that they get updated with the changed time ranges automatically and we do not have to be publish them repeatedly again. FYI: We have time range in column then the line items in column and brands in rows. Thanks in advance.

CommunityMember131357 · ‎06-16-2020

Hello, I am facing an issue in my dashboards. As soon as I have changed the time ranges created that were applied in different modules on opening of the new budget cycle.Certain tables that were published have disappeared and some tables that were published with time ranges in columns have got updated with new time ranges whereas others have not. This has left me highly confused on how to publish my dashboards having time ranges displayed in columns (whether with a saved view or by hiding manually on the dashbaoards) so that when the next year the new cycle is opened the tables are updated automatically. Please guide me with best practices to follow with this respect. Thanking you in advance.

CommunityMember131357 · ‎05-29-2020

@jasonblinn Yes, when I bring my line items to rows and export the data there is no trouble associated with it. But however, we do have other modules also created where we have line items in columns and are exporting the data in multiple tabular column format without any hassle. I am unable to find the problem associated with this.

CommunityMember131357 · ‎05-29-2020

@jasonblinn The pivot view and the levels to show have been selected as attached in the below image: In addition to this certain brands have been hidden from the row and then the saved view has been created and the required view has been published on the dashboard. While taking out the export in multiple tabular format the levels which have been selected are only exported but the brands which have been hidden and the line items which are not shown in the saved view are also coming. Thanks in advance.

About CommunityMember131357

Re: IS Summary

Re: Formula Error

Re: Formula Error

Re: Formula Error

Re: Formula Error

DCA

Re: List import

Formula Error

Re: Formula

Formula

Re: Import Error

Re: Import Error

Import Error

Re: Percentage Calculation

Re: Percentage Calculation

Re: Percentage Calculation

Re: Percentage Calculation

Re: Percentage Calculation

Percentage Calculation

Excel Add In

Re: Excel Add in

Re: Excel Add in

Excel Add in

Re: Dashboards Issue

Re: Dashboards Issue

Re: Dashboards Issue

Re: Dashboards Issue

Dashboards Issue

Re: Issue in Tabular Multiple Column Export Format

Re: Issue in Tabular Multiple Column Export Format