You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Standard Metadata Extract: Member formulas with line breaks split CSV records across multiple lines

edited 7:12AM in Planning 2 comments

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!