About Misbah

@robinsalk    Step 1: Create Line Item 1 - Time Dimension                 Formula - ABS(Source Line Item) Step 2: Create Line item 2 - Probably in another module with no Time Dimension                 Formula - TIMESUM(Line Item 1) - Make sure  Step 3: Filter on Zeros - You will be able to see all the Accounts with No Transactions   Thanks, Misbah ... View more

@DavidSmith    Apart from the reasons mentioned above by you , due to Inactivity in the model for more than 60 minutes does the model go back to disk and it has to come back to memory when somebody tries to log back in to the system?  Heap & Stack memory concepts.   Because In one of my client's case our model opening time was around 5 minutes as it was a huge model and we brought it down when we scheduled a job every 10 minutes - This job basically did nothing just to poke the model to stay awake and didn't let it go back to sleep.   Hope my understanding on the concept is correct. Thanks, Misbah ... View more

@DavidSmith    No Problem:) Thanks a lot for clarifying. ... View more

@DavidSmith    I think your earlier math was accurate. It was just the statement about the cell count that was confusing.   Now there is a confusion in your new calculations as well. What you are saying is that for every 100 list members, you will multiply list members with the number of properties first (in this case 2) and then calculate bytes based on the format of those properties (basically double count) On top of it you are multiplying 500 bytes with 200 instead of 100. 500 Bytes should come only once as it is the space that list item would be consuming only once and then the calculation for list properties would come into picture.    I think the math should be what you posted earlier -I am backing it with my R&D on one of dummy models. My model size increased exactly by 0.49MB for 1000 list item count which is aligned as per below math.   1000 members = 1000 cells 1000 * (8b +4b) +(1000 *500b) = 5,120,000b   Let me know if that's not the case. Thanks, Misbah   ... View more

@DavidSmith  Thanks a lot for the detailed information, it is really helpful. However I found some anomalies between what you say and what I observed.    I created a list with exactly 100 List items in it - Cell Count didn't go up,it remained zero as you rightly mentioned  I then added two properties to it, date and number formatted - Cell count jumped to 200. This is against what you said in your comment section."List Properties add to your space and not to cell count". Below screenshot for your ref Did you intend to say list items? Let me know if I am missing anything here   Thanks, Misbah ... View more

@AshaPatil    Please share the exact requirement with snapshots(if possible). Community is here to help   Thanks, Misbah ... View more

@kavinkumar    There is a catch here. If you shuffle your dimensions from Page selectors to Columns - It will throw an error if your list is too big - Anaplan has put a limit on the number of columns that it extracts.   Workaround can be - you try it in Tabular format - Single or Multiple. Here in this case it can be Single.   Thanks, Misbah ... View more

@fredrickstraube    Please Export it in Tabular Single column Layout instead of Grid Layout. Attached screenshot for your reference.   Let me know if that helps. Thanks, Misbah ... View more

@Ankur.Sonthalia    Have you specified both read and write access drivers in your DCA selection for the line item or only the write access. Try specifying both and see if you get the desired result.   Thanks, Misbah ... View more

@Panji  You can do this using Dynamic Cell Access feature   1. Create an Access module with two line items (One specifies Read and other Write) & Time as a dimension (Or any other list that you want to put the selection upon) 2. Make both these line items as Boolean formatted. 3. Go to Summary and change the Summary from None to Any 4. You can manually check the boxes that you want to put the selections upon or you can write codes in these two line items - to keep it dynamic 5. Go to the module where you want to apply the changes - go to bluerpint mode and scroll towards right and you will find Write and Read access columns. Choose line items from the dropdown (that you created in Step 1) 6. Once selections are applied, users will be able to read, write or see based on the selection     Happy Planning! Miz   ... View more

@abhay.kanik    Few points before you go thru the link below:   If you obtain both the public certificate and private key in a single file, use openssl to extract and save both the files separately in PEM format.   When you extract the private key you are prompted to create a passphrase. This Passphrase is needed if you use your private key for authentication.   Option 1: Use Private Key with Anaplan Connect                Option 2: Create a Java Key Store   I believe you are taking option 2- below document will help you in resolving the issue https://s3.amazonaws.com/anaplanenablement/Community/Anapedia/Anaplan_Connect_v_1_4_1.pdf   Thanks, Miz   ... View more

@Panji    First you have to understand what is the issue here:   You have a multi dimensional module (With Versions & Time also as a dimension). Now you want to do away with Versions and Time and get the aggregated data into a flat module. (You can do this with any dimension provided you have selected top level for those dimensions). But if you have versions in the source module then you have to tell Anaplan - numbers of which version should flow from multi D module to flat module - for that better option is to Go to Versions command and tick the current version against the version which you are trying to retrieve. And for Time you again have to educate Anaplan what numbers should flow. You can use Select function if you are bringing Data for all periods - SELECT: TIME.ALL PERIODS or you can also use LOOKUP if you have a dynamic time range.   Hope this helps Thanks, Miz ... View more

@AshaPatil  Please share the screenshots.It should be pretty straightforward if you are using native time scale in both source & target modules.   Thanks, Miz ... View more

@nathan_rudman    This might not work when your timescale is in weeks as Anaplan has put the limit on 200 items. Although there is a workaround on that but this topic has a caveat - Only when Time scale < 200 Items.   Let me know your thoughts.   Thanks, Miz ... View more

@NathalieLbn    Can you please share an example with the screenshot. Will be glad to assist you   Thanks, Miz ... View more