About Alexandru.Rosca

Alexandru.Rosca · ‎03-08-2021

Hi Guys, Is there an easy method of scheduling process running in Anaplan? Our consolidation process is not live and requires data pushes through inport actions within the model - that we need to run at certain hours. Basically we would need to open Anaplan model and run the process that we can even attach to a welcome cockpit to make it easier. Just saw CloudWorks, but I am not familiar with it. Can it achieve the desired result? Are there alternatives?

Alexandru.Rosca · ‎10-27-2020

Hi Guys, thank you both, but I believe I see what seem to be the problem. I only have one Model in that WS, this having 65 GB. The error message is misleading, as I would think the new model size is 28 GB (after I press create from revision tag), but not the case. I managed to define a few other production lists, just to reduce the size of the dev model and finally I could create the model from revision tag. My issues is that I have so little production data, therefore making my dev model just about same size. Still don't understand why error was pointing to a 28 gb size.

Alexandru.Rosca · ‎10-26-2020

Try to change your cell format in column C in csv. Right click -> Format Cells -> Custom -> Type: mmm yy -> save your file and load again.

Alexandru.Rosca · ‎10-26-2020

Hello Community, We've just identified this error while migrating to ALM one of our Models. This is the second one we are trying to deploy. The approach we've taken is to have One production model + One Dev + One Test Model (DEV and Test both in the same workspace). Model that is failing has 66.5 GB size from a total of 130 in the WS (WS for dev and test will have a smaller size, but its a separate discussion), as below error is generated while running "Create Model from revision tag" in the 130 GB WS - just to see how big the DEV model will be. First one that we deployed it's even bigger (70GB from a total of 130), it's true that has much more production lists and its DEV is only 14 GB, but still cannot understand the logic why the other one is failing. Appreciate all your thoughts.

Alexandru.Rosca · ‎07-16-2020

Thanks for your feedback and insights. For the sync part, we only moved a small change (one member in a list), that would normally take 2-3 minutes to make it in production. Doing the sync took around 20-25. Wondering the time would take for much more changes. As for the integration, that would suit the MD loads, but not actual data inputs in Actuals or forecast, that are done solely in Anaplan Production model.

Alexandru.Rosca · ‎07-16-2020

Hi Guys, We have just started going though the documentation on Amapedia and make some testing for our organisation, as we are preparing to bring in ALM (we already have a production system). Those are some initial questions that poped up, before going even deeper in updating any referenced formulas. Would appreciate if yo can tell from your experience which would be the best practice for the below. 1. Import model vs Create from revision - assuming we already have the production model, can we make the Initial dev through an import instead? are there any inconveniences when synchronizing further on? I'd choose this as we want to have a 1 to 1 copy with the production, meaning also Production data - I would not achieve it through create from revision tag. 2. How long does usually take for a synchronization (60 -70gb model) - our first test took around 20-25 minutes for just a line item added in one list (is it normal or might be due the fact highlighted above?) 3. How do you bring in Data and MD in your Dev model? We do have daily integration with other systems that populates master data lists and also we would probably need to update Actuals every month - This creates problem if we want to keep 1 to 1 relationship with our dev model, as only production will e updated. Is it a common practice to make regularly copies of the production that will become a new Dev model? Is there an alternative?

Alexandru.Rosca · ‎06-15-2020

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 · ‎06-15-2020

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 · ‎06-15-2020

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!