Loading data from .csv into cube

[pooja_11284]

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.

[Wim Gielis]

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.

[jim wood]

Moved to the correct forum.