Standard Metadata Extract: Member formulas with line breaks split CSV records across multiple lines
Summary:
We are running a standard metadata extract where one of the dimension properties contains member formulas.
We’ve run into an issue with the structure of the resulting CSV export: As soon as a member formula contains a line break, the data record in the extract is no longer displayed in a single line, but is split across multiple lines.
For example, a typical record gets interrupted and formatted like this in a text editor:
Hard line breaks in member formula lead to: 1: ID_001;Employee_A;Active;"IF (Status == 'Active') 2: 3: Calculate_Bonus = Salary * 0.10/ 4: Total_Months; 5: 6: ENDIF;" 7: ID_002;Employee_B;Inactive;<none>
Tagged:
0