Adding Un-editable Note in Export Action

Options
saiteja
saiteja Member, ALL USERS, Partner, Certified Model Builder Posts: 2 New Contributor
in Extensibility
There is need of adding a disclaimer/note in the first cell of file. How to add that cell in the exported file.? and also that disclaimer should not be editable in Anaplan model when another file is imported with different disclaimer.
For Reference: I Have attached a Screenshot. 
Employee(Column B is the List), Comment and Salary (Columns C & D) are the Line Items.Community.png
Tagged:

Comments

  • nitish
    nitish Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Occasional Contributor

    So there are two parts in the solution, for the first part:-

     

    The module comprises of list as a dimension (As per the depiction in the attached screenshot)

    Add one property named “Disclaimer” in the list, and while exporting from the module choose that property first in the Labels section.

    Nitishsingh_0-1583472898533.png

     

    For the second part:-

    To bring that disclaimer in only one cell and to make it non-editable you need to hard-code it using cumulate function.

    Below is the example of the same, you can use other functions like ISFIRSTOCCURRENCE as well but to use that you might need to add some more list properties.

    This is best solution I found, please feel free to suggest some more solutions.

    IF CUMULATE(1, “Argument”,”List Name” ) = 1 THEN "Disclaimer:- qwertyuiopasdfghjklzxcvbnm " ELSE BLANK

     

    Note:- You might face some issues in getting the disclaimer in the first cell when you are using composite list.

    Thanks
    Nitish Singh

  • saiteja
    saiteja Member, ALL USERS, Partner, Certified Model Builder Posts: 2 New Contributor

    Hi Nitish,

     

    Thanks for solution. It works.😊

  • nitish
    nitish Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Occasional Contributor

    @rob_marshall

     

    Hi Rob,

     

    Thanks for suggestion, but with the suggested option as well, we can't get Disclaimer in first column.

    Please suggest the option from which we can get it in the first column, first cell.

     

    Thanks

    Nitish

Categories