About CommunityMember131357

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 ... View more

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. ... View more

Hi All,   I am facing an issue while exporting data from a dashboard by selecting Tabular multiple column export option. Although the table on the dashboard has been published by creating a saved view(i.e. by selecting 'Show Selected Line Items only' option). However, while exporting the data in tabular multiple column(.csv) format the other line items which are not visible on the dashboard or the saved view are also getting retrieved.   Further Information: The grid view format retrieves the desired line items only but do not suffice the user purpose.Hence a solution is required around tabular multiple column export format and the data can also not be retrieved in(.xls)  format as it shows too many rows error therefore it can only be obtained (.csv) format.   Please help me around this.   Thanks     ... View more

Hi All,   I am working on a model where I have a module with dimension including a combination list, version lists & stages created with respect to P&L. The combination list has been created with the combination of states (rate area), product (Sku) etc. Now to restrict the access of each Regional Finance Manager so as to allow them to only import values in the module with respect to their region I have created a DCA module with the dimension as that combination list only and used another module to mark their respective regions. I have used this DCA module in the write access of the module where the values are to be imported so that each RFM is able to import values with respect to their region only.    But somehow things are not working and each RFM is being able to import values for all the states irrespective of his rate area. I have also attached the images, requesting your help on the same.   Thanks in advance.   ... View more