Best Of
Re: How to retrieve the mapping information of import action ?
For model-to-model imports, you have to edit each action and check what all columns are mapped vs unmapped.
For CSV loads you need to update the import data sources to edit the action and check the mapping.
I believe there is not other easy way to get this done. You have to do this manually.
Dikshant
Re: The ITEM function should take a hierarchy as argument
thank you @jagadishdash. this really helps me. :)
Atz1234
Re: The ITEM function should take a hierarchy as argument
Hi
(ITEM('REP01 Long Term Loan Payable'.Balance )).
Issue is with this part of formula . Item function will only take list as it arguments
As you have referred lineitem , it is troughing error. Try to refer to suitable list, it will get applied.
Let me know if this helps out!
Thanks
Pujitha
PujithaB
Re: The ITEM function should take a hierarchy as argument
@Kenshee I believe, Balance line item from REP01 is not a list formatted line item. It's might be a number that's the reason error is occurring. Item function will only applicable for list formatted line item. so please do a check on that line item.
Re: 1.5.6.2 Import Data into Historic Volumes Module | Invalid line item identifier
Hello
In the third screen shot for mapping, you need to map the volumes as Fixed line item. and then in the DAT03 Historic Volumes Line items tab select the fixed line item. It should work.
Thanks 😉
shrav
Re: Import Error Issue
Hi @Monpero
In this case, Possibly Level1 parent code would be different from the above screenshot items.
Thanks
Pujitha
PujithaB
Re: Is there a way to change which browser is used by Excel Add-in for SSO authentication?
@KirillKuznetsov - thank you for your reply and trying to get some attention to this issue.
I connected with Anaplan support yesterday and found a workaround that works (for now), though it is not ideal. The workaround was to insert a line into the Settings.xml file found in %LocalAppData%\Anaplan\ExcelAddIn\4.4 to enable a feature named "EdgeLegacy" — however I suspect this is a duct tape fix that works for now, but I don't think will be sustainable.
I'd like to see the next update of the Excel Add-in to allow user to specify which browser to use as an option in the Authentication settings rather than solely relying on an embedded browser — hoping this is possible!
Zak_G
Re: April 2024 Community Member Spotlight: Kirill Kuznetsov
The name of this parrot is Ricky. It is my nieces' bird. But I have a dog called Darwin - a black English cocker spaniel.
Thank you for your feedback. It is very important to me!
Re: Character limit of 60 on Anaplan code - Possible solution to address the issue required
If that is the case, then concatenation is the only way to go. To get around the 60 character limit, have you thought about having an "Anaplan" code? This is how it would work...In your flat lists, you would have the real code from the source system. In the SYS Properties module for that list, you would have an "Anaplan" code to which you would use for the hierarchy code. For example, in your Product Category Flat list, say a members code is 1000000000009, but in Anaplan, the "Anaplan" code would be 10. The SKU flat list, a member from the source could be 20000009, but in Anaplan, the "Anaplan" code would be 20. So, in the Anaplan hierarchy, the code would be 10_20.
And if you needed to export the data out of Anaplan, then you could always refer back to the flat list to get the true source code.
Hope this helps,
Rob
Re: ALM enabled between 2 Dev models linking to the same Production Model
@PujithaB @Yehya123 - I was looking at the conversation going on above.
@PujithaB - The option 1 which you suggested is suitable , the only thing we can do is to inform the end users that will be taking the model offline for sometime so that @Yehya123 and team promote their changes to new Prod Model. This model offline activity can be performed during the month end or when the users are not actively using the system. We must inform the end users about the same.
Option 2 is good but as @PujithaB mentioned you will lose dev history, that is the only concern.
