TM1 Forum

I have a .csv file from which i want to load data into cube. The requirement is only non zero values should get loaded as the sheet has lots of zeros. What is the best approach to load data in this case? I was thinking to put if condition in data tab so that if data <>0, Cellputn statement executes. I have 24 measures getting loaded from the sheet. Let me know if there is a way to use macro or something in the sheet itself to suppress zero data or apart from using if loop we can use something else.

Please can you post in the appropriate subforum ?

Regarding the question:

Yes, put a condition in the data tab to exclude some CellPutN's or do an Itemskip to skip processing that line from the csv file.

Moved to the correct forum.