About Alexandru.Rosca

Alexandru.Rosca

Unfortunately we do not have ALM yet in this Model and I believe this is the only solution available. It's a pain whenever we need to retrieve some old data as we need to take the production down. Only that this time we also want to use history, not just look at older values. Thank you all for the replies and solutions.

Alexandru.Rosca

That is the tricky part as I need to archive Production due to space limitation, otherwise I would have unarchived without asking the community. Thank you for the help!

Alexandru.Rosca

Hi Guys, Does History still works on Archived models (Change the mode from archived to standard). I cannot retrieve data from the production model due to switchover for some cells and I would like to check it out from an archived model. Regards,

Alexandru.Rosca · ‎05-05-2020

It is strange why I am seeing this topic being brought to life now :). What I've decided in the end was to remove the page selector and FX removal tick, and instead I created them through line items. This way I could control where currency impact applies and what are the calculated scenarios. Reduced the cube quite a lot since some of the scenarios were not even relevant in the initial approach. I also attached a snipe from blueprint if anyone is interested in the solution. The only disadvantage is that the users are seeing all data bulk in a dashboard and is not calculated through the selection. Can be easily solved through saved views, but wasn't a requirement so far.

Alexandru.Rosca · ‎02-11-2020

@Misbah I would use AND instead of OR in this instance. As it is written, the formula will return TRUE each time even if last digits are 000000 or 0000002.

Alexandru.Rosca · ‎02-07-2020

Here's the way I managed to do, which I guess can be followed even by the beginner Admins. (the only disadvantage is that you can take the ID's individually, not a bulk export).

Alexandru.Rosca · ‎02-06-2020

It only works in a certain sequence you do in action list, learned by try and error I'd say. I suppose it's because of the language used that did not displays all the code once you inspect it. Not a Web Developer, but I could do a walk-through if anyone else is interested.

Alexandru.Rosca · ‎02-06-2020

For that one, I found a way for pulling the ID directly from Page source, although it's not the most elegant way, but it does its job.

Alexandru.Rosca · ‎02-06-2020

Thank you, Alex, I was trying to get Anaplan Connect to work just for retrieving Export definitions and Action IDs. I need those for other external Integrations which some of them make use the action's ID and not the name. As you said, updating a saved view will not update the export definitions, therefore this feature caused us a lot of the issues in the past. Our thought so far was that any new export that overtire an existing export (same name) will also create a new internal ID. Thanks both for your replies, I will try make some changes to see how B2BI integration pull out the data upon updating the definitions.

Alexandru.Rosca · ‎02-03-2020

Hello Community, I'm reaching again support for some questions I have, some of which may appear silly for some experienced users. I've been trying to find an easy way to obtain Action's ID in Anaplan as those are used for our B2BI integrations with other ERP and EPM systems. Initially, I thought I can easily get them from the page source, but turned out to be more difficult for that. Digging a little bit, I've seen that I can obtain the information I need using Anaplan Connect, but as a non software developer, I find this a bit difficult to use even having the guide available to Anaplan. Here are some of the questions I have. - Is any more detailed API quide available through Anaplan discussion for beginners(nothing that I found was straight forward for first time users)?. I only need to understand how to connect to Anaplan Models (export actions ID and export definitions). - By updating export definition (ex: change a filter in the export view), will this also change the action ID? Such change I can only do by exporting again and saving export definition with the same name (that is why I'm thinking a new exprt ID will be created). - Is it possible to update export definitions using the above approach or through Anaplan connect?

Alexandru.Rosca · ‎10-28-2019

To this I would add also a reference whenever a line item is used as a filter in modules. Especially when your model contain a time filter module where you can have multiple line items.

Alexandru.Rosca · ‎10-28-2019

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

Alexandru.Rosca · ‎10-28-2019

Hi Usman, Thanks for your support, I am aware we can see the source module but not the view it's using. Going forward we may be using notes for each action, but is no 100% reliable when having to maintain dozens of export actions, notes being a manual input the admins need to take care each time they make adjustments. Also, thanks for the tips, I'm gonna try to Idea exchange section to see if it goes through.

Alexandru.Rosca · ‎10-28-2019

Hi David, Thanks for your reply, I'd just like to highlight I am not an advanced Model builder, I'm just now learning the ways for effective models. Here are my comments: 1. I don't want to have the calculation based by users, I just want to have the calculations independent by other user's choice. (more like a page selector instead of Boolean cell that can be modified by users). 2. Then how would I link the module to behave like a page selector in the dashboard? Or maybe I don't quite get the approach. 3. I don't have that much experience with line item subsets, but will that cover spacing issues? If I do calculate them separately, I still have lots of combinations to cover, the only advantage being that I can exclude couple combinations that I do not want (like FX impact to be applied at Local Crry Reporting).

Alexandru.Rosca · ‎10-28-2019

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.

Alexandru.Rosca · ‎10-22-2019

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!

Alexandru.Rosca · ‎10-21-2019

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 ****

Alexandru.Rosca · ‎09-02-2019

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!

Alexandru.Rosca · ‎08-05-2019

Hi Community. I would like to explore the possibility of extending one of our models that currently has a 0 future periods. So far we created a new model each fiscal year, but now I am considering extending the future years. Besides the space and hard codded line items formulas what would be the other constraints?

Alexandru.Rosca · ‎08-09-2018

After a long struggle, I managed to set the security with an upload. Put the different CCs on separate loads and it worked just fine. Thank you!

Alexandru.Rosca · ‎08-08-2018

Hi Comunity, this is my frst ever post on this forum, and for sure it won't be the last. Before posting this, I had a look through previous questions but couldn't find quite what I needed. Here is my issue. In the model I am working with, we have thousands of CC split between regions and Cost types and you can imagine it's a nightmare assigning multipleCC access to a single user since the drop down list does not have a search button. I tried manually inserting them separated by comma (the way export file is showing for simmilar users) but this didn't work. Is there a better way of doing this job? Finding 50 cost centers between the entire list will take hours of work. Thank you!