About abhay.kanik

@tejaswini  I suggest you to use a custom version list with 2 items, let's say original and updated .  Create a boolean and compare it with the original version . whenever user will updating something in updated version boolean will go true and use that as a filter for your saved view for import.  Crate another action which will import from updated version to current version and add it in the end pf the process.   Thanks Abhay ... View more

@ChrisM  Seems like a different feature is delivered than was was asked from some of us.  ... View more

Recently faced this issue while one of our go live was unable to test the production model features with the app while model is offline. ... View more

HI All,   Is anybody is aware that when we schedule for the exam on the portal what is the time zone of selector, Is it my profile time zone or something else? ... View more

@Alessio_Pagliano  Totally agree with you , It will also help in showing information only related to the current context. Elements are not applicable for all the combinations.  +1 from my side! ... View more

@ankulkarni  Yes it is achievable , but at what cost!  it has its own nuances. You will be required to run process everytime at the time of addition of user. If its an automated job to add users then it wont be a big problem but if you manually add users into model then it will be an extra step at the time of addition which someone can miss. Explain a bit more about your use case so we can provide you the best possible way to do it.   Thanks Abhay     ... View more

@rmat066sysf    I have a different approach from @andrewtye @nikolay_denisov , Please suggest if this approach has a particular issue . In this approach you wont be required to do current date hustle.   Add 3 line items to your module    Line item 1 - Date (Date Formatted) - Import date into this one Line item 2 - Rank(Number formatted) - use the formula Rank(Date) . It will give rank to your date from latest to oldest by default. Line item 3 - Delete Flag (Boolean) - Use the formula Rank>5 , All the dates older than 5 days will be true and you can run a delete action using selection with this flag to delete older days data. Thanks Abhay   ... View more

That is a great approach @jasonblinn ,  @riddhishah17  I have done it using DCA till now, You will need 4 more line items to do it. Line item 1 - Locking Driver(Boolean) - Set it as true Line Item 2 -  snapshot scenario Flag(Boolean) - no formula Line Item 3 - Read Driver (Boolean) - if item(Scenario List)= Scenario List.snapshot scenario and snapshot scenario Flag then true else false Line item 4 - Write Driver (Boolean) - Not(Read Driver)   Use the read and writer driver for DCA   Now to make this work update your saved view for action and make sure you import from Locking Driver to snapshot scenario Flag after copy action . Keep action separate and you can put both in a process. This will allow you user to update once but not second time as it will be locked once flag is imported. You can also Create an admin action just to reset the flag back to normal at the time of reforecast. add a new line item for that .   Thanks Abhay ... View more

@hyudolee    You can calculate your end period for formula in a separate line item which will reduce your length of formula. Use the day(Date formatted line item) function to figure out the day. now you will be able to recreate your formula like this IF Inventory <= MOVINGSUM(Demand, 1, DAY) THEN DAY ELSE 'OTHER CONDITION'   Thanks Abhay ... View more

@ashish.banka  I can assure you currently there is no way of doing that, but it might be in cloudworks roadmap. Its an Important feature to have so that data owners should know the statuses of integration running You can post an idea for this in idea exchange if its not already there.   Thanks Abhay ... View more

@soumyarani    Yes, Qliksense can consume Anaplan APIs Using its REST connector. You just need an export action in your model You can go through the details in the article below https://community.anaplan.com/t5/How-To/Extracting-Data-From-Anaplan-With-Qlik/ta-p/88214   In general any BI tool which can consume API can be used with Anaplan APIs for data load into it and for those where Anaplan Connector is available it is a straight forward point to point approach.   Thanks Abhay   ... View more

@nicoledawis  I can see you need manly time and a field in bottom which is a free text field. I suggest to create a separate module with time and your line items . it will be a straight forward approach.   Thanks Abhay ... View more

@eang92  It is very crucial feature to have. But I believe its not in roadmap. You can see the same Idea is posted earlier. You can support the same. https://community.anaplan.com/t5/Idea-Exchange/Enable-Power-BI-Anaplan-Connector-with-SSO/idi-p/92071   Thanks Abhay ... View more

@MarkTurkenburg    As I can understand you want to filter the line items on be basis of the item selected in the selector. You have to crate a custom filter to achieve that. If that is the case you can do it with the steps below -  Create a line item subset(LISS) of the line items . Create a system module dimensioned by user list and add a line item 'Selector'  which will be formatted by the Line item subset you created. Create a filter module which will be dimensioned by the LISS ad User list, Create a boolean line item and put formula Selector = item(LISS) Use the boolean to filter the line items in module ,save and publish the view Publish the selector line item on dashboard and it will act as a filter. This will also help you in NUX Thanks Abhay ... View more

Saw codes Column for line item in blueprint today, is this already released? ... View more

@JoannaAn    If  you use a field card to filter it will not automatically synchronize , It is just like a normal selector.  To enable filtering with that you have to create a system module compare the user input in the field card and the data in module and apply that filter in your saved view or Custom view. Something similar to this -  https://community.anaplan.com/t5/Anaplan-Platform/Line-item-as-Page-selector/m-p/112647#M27406   Thanks Abhay ... View more

+1   Very important features as many users miss to follow the instruction and run the action anyways which made them think they have completed the action. Action can be enabled/ disabled on a a condition ... View more

@margauxplet    In addition to what @LipChean_Soh  suggested , there is a 3rd long way if you have to do it repeatedly and is more strategic than tactical. Step 1 - create a numbered list name it fake users import users into it with code as email ID, name the action accordingly. Lets suppose it as 'Action 1'  for now. Step 2 - Create a module using that list, name it 'User details'. with line items email ID, first name, last name, role, Delete Flag(Boolean)  and import the data into it. lets call it 'Action 2'. keep formula in delete flag as 'TRUE' Step 3 - Setup and action into user list from User details module .'Action 3' Step 4 - Create a delete action using delete flag .'Action 4'. This will clear out your list fake list an data after import so that you don't use unnecessary space for it. Put all the actions in a Process in same order created, Publish it on dashboard. It will allow you to select file and add users in prod model. Don't forget to mark fake list as production.   Thanks Abhay ... View more

@jrimmer93    In My experience we always had 3 workspaces for Dev, QA/Testing and Production for each functional area or planning area. So if you have Finance and WFP use 6 workspaces. Recommended Size of workspaces will be in the order Prod>QA>Dev.  Except all these keep separate ones for datahub( Dev, Prod and QA) because that will simplify your entitlements. Although these are not defined best practices but this setup works and is easy to maintain. Hope it helps!   Thanks Abhay ... View more

@NancyKhurana    If you don't have quarters in your target modules how you plan to show the final output. Where you will land values for Q1,Q2 etc. separately? Are you planning to have separate line items for each quarter?   Thanks Abhay ... View more