Adding Un-editable Note in Export Action

saiteja

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.

nitish

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.

 

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