About anirudh

Hi Swapnil, Yes that's correct Add another line item with the formula: IF Ending Inventory < Safety Stock Target then 1 ELSE 0 Then use this line item for conditionally formatting the Ending Inventory line item The advantage with the static value of 1 is that now you can easily set the minimum and maximum value to 0 and 1 respectively and not worry about the actual difference in the inventory and safety stock Regards, Anirudh Regards, Anirudh ... View more

Hi Johan, > Do I need to create a separate module without the time dimension that feeds the reporting module? This is exactly right. Employee data does not need to be updated for each month. Since it does not vary by time, the time dimension is not required. Regards, Anirudh ... View more

Hi Praba, Definitely! Just right click the conditional formatting line item and click Hide to hide it Regards, Anirudh ... View more

Hi, You can do this by hardcoding the value based on which conditional formatting is done Here's an example   The Data line item is highlighted the same, irrespective of the values Here's the setting for conditional formatting The CF line item just has the formula "2" applied   Let me know if this works for you   Regards, Anirudh ... View more

Sorry, I'm not really sure what the context is behind the model you're building. I was suggesting the way to fix the formula. Basically, you need to make sure the first part of the IF formula resolves to a TRUE or FALSE.... The part that's causing the issue is 'INV01 Inventory Ordering'.Override Suggested Order Amount as that's not a conditional and does not resolve into a boolean ... View more

Hi Tom, It is quite painful to do, but you can achieve this with IF statement loop and length check constraints such as: IF LENGTH(TEXT(Number)) > 6 THEN LEFT(TEXT(Number), LENGTH(TEXT(Number)) - 6) & "," & MID(TEXT(Number), LENGTH(TEXT(Number)) - 5, 3) & "," & RIGHT(TEXT(Number), 3) ELSE IF <Write similar condition for greater than 3 digits> ELSE TEXT(Number) TEXT functions as well as text formatted line items are always best to avoid so do try avoiding this if possible. Another thing if you want to optimize the formula above, is to reference the TEXT(Number) conversion and the LENGTH(TEXT(Number)) instead of calculating that in the formula each time Let me know if you need additional help Regards, Anirudh ... View more

Hey Tom, Try: DATA[SELECT: Time.'Jan 20'] Although as a long term solution, you'll want to create a line item subset from the Jan, Feb etc line items and map them with Anaplan time. Then use the formula DATA[LOOKUP: LIS to Time.Mapping] Let me know if you need more help Regards, Anirudh ... View more

I just checked now on an import I'm positive I did not create and the import completed successfully ... View more

Try changing the formula to IF PARENT(ITEM('CFO Highlights....')) = 'CFO Highlights....'.Alo World THEN 1 ELSE 0 That should work! Although I have to say, this kind of hardcoding is almost never a good idea. Do consider using another approach... Regards, Anirudh ... View more

Hi Santosh, If I'm not mistaken, you will have to feed Informatica a 'dummy' data source like a DB connection. That will populate the source setting and in the subsequent step, allow you to actually select the action/process you need to run Regards, Anirudh ... View more

You will have to create export actions in all the modules that you want to pull data from Use "Tabular Multiple Column" option to get the data in a consumable format as well as in the fastest way You can then programmatically extract all the data from a model by pointing the rest api at each of the export actions   Regards, Anirudh ... View more