Is there a way we can skip records with blank values while loading data into BPC. I have a data extract in which some dimension values are blank and it's a requirement to skip these records.
In the conversion file I tried this formula, basically if the length is zero then SKIP the record. Doesn't work
If(vb:len("%external%")=0 then *SKIP;%external%)
thanks in advance