About Alexandru.Rosca

Hi Community,   I am thinking that would be very beneficial for model builders to have the possibility to view Data Sources for Export Definitions. For the large models with lots of external integrations and different export actions is pretty difficult to follow the source of a particular export if you can have dozens of saved view for one Module.   Found this topic from last year. Thought of bringing it back into discussion.  https://community.anaplan.com/t5/Idea-Exchange/Access-to-source-views-on-saved-exports/idi-p/37624 ... View more

Hi Team, Colleagues,   I don't know if this has been brought up by now as I am not able to see any similar topic.   Is there any possibility to check export data source, especially Module saved view it's pulling from? If not, are there any plans of upgrading to this feature? For us, would be a life saver as we use multiple saved views and export actions and sometimes is pretty difficult to follow all the views in order to reach to the source of the export.  ... View more

Hi Community,   I've tried to post the same query yesterday, but it seems it didn't go through. I'm gonna have another try.   I'm working on creating a Variance Dashboard at Cost Center / GL level. Having those two dimensions alone would make a relative big module, but I have added couple more which is causing me a lot of troubles in terms of spacing (Page - Time, CC, Reporting ccry, comparison scenarios; Column - Line items I choose line items instead of dimensions as I would need to calculate the data based on various criterias; Rows - GL accounts. I have added for page selector comparison scenarios and "Eliminate FX impact"- this last one does not apply to my module or to any of the line items in it. I's just an IF formula referencing it. The big advantage is that will not occupy space, but the main disadvantage is that the selection is a manual input and will change it for all users.   Here is what I wanna achieve: ex: if Comparison Scenario is Actual vs Budget and "Eliminate FX Impact" is true, then variance will calculate( Actuals at Budet rate - Budget). Is there a more practical way of obtaining this, instead of applying so many dimensions? And more important, can I do it through dropdown selectors rather then Input module which will apply the same change to all users?   *** IF ITEM ( VS ) = VS.Actual vs Budget AND Latest Estimates.Eliminate FX Impact = TRUE*** (latest estimates being just the dummy module I used for Eliminate DX impact bolean line item) Thank you!   ... View more

Hi Community,    I am struggling building up a Variance dashboard at CC/GL level. Having so many members I encounter spacing issues. I have also added a numerous other dimensions (Rows - GL accounts / Columns - Line items ->I will bring the data through line items formulas instead of Versions so that I can calculate different scenarios / Page - Time, Cost Center, Reporting Crry, Comparison Scenario).  What I intend to to is to calculate the line items based on Scenario and FX impact ( ex: if Scenario is Actual vs Budget and Eliminate FX impact, then Variance = Actual at Budget Rate - Budget). Trying to avoid the spacing issue, "Eliminate FX impact" does not apply to source model of the dashboard, but instead it's a line item of another dashboard (selection is not dependent and user can input it directly). The disadvantage is that Selection will change for everybody. Below is part of the formula.  Is there a more practical way I could make this dashboard instead of applying all dimensions to the module and also not being modified by the final user?   ***IF ITEM ( VS ) = VS.Actual vs Budget AND Latest Estimates.Eliminate FX Impact = TRUE ****     ... View more

Hi Colleagues,   In one of our Model we are using couple numbered lists and we are giving the users the possibility to insert new lines with a create action. Now I am setting up a new model for 2020 and I am trying to make some cleansing through the model, and would be great if I can reset the counting to start back from 1.    I did went through previous topics and seen that I have the possibility to reset if only after it reaches 899,999,999 million. Is there any other possibility? What if I un-tick numbered list and put it back? Will this reset the list? If so, will it impact anything else? Actions/line item formulas, considering that I already deleted all the items created in the past year in the numbered list.    Thank you and regards!   ... View more