Topics Map > University of Chicago > IT Services > Business Systems > Reporting Systems

Business Objects - Webi - Concatenated List

This article explains how to create a variable in Business Objects that will contain a concatenated list of values from previous rows of data (i.e. a list of accounts, months, etc...) for another variable (i.e. a list of accounts for department).

Given that you have a data object like a SL Account number, department number, sub account numbers, etc. that you want to create a concatenated list of values in a single of values for another data object (i.e. a list of accounts for a department, departments in a division, sub accounts for an account, etc...)

  1. Create a measure variable that will determine the last value for the range (in this case the Department number and name on the account)

    =Last([SL Acct6 No]) In ([Dept No + Name (display)])

  2. Create a Dimension variable for the previous values
    =If(Not(IsNull(Previous(Self;([Dept No + Name (display)]))));Previous(Self;([Dept No + Name (display)])) + ";") + [SL Acct6 No]

  3. Create a detail variable for the full concatenated list of values associated to the variable you are grouping the list on (i.e. the Department number and name for this example)

    =[VAR Concat Acct 6 v2] Where ([SL Acct6 No]=[VAR Last Acct 6 v2])

Related Links

Keywords:BO report GEMS AURA IRF Payroll Financial SDW   Doc ID:50450
Owner:James I.Group:University of Chicago
Created:2015-04-14 14:08 CSTUpdated:2016-08-02 10:34 CST
Sites:University of Chicago, University of Chicago - Sandbox
Feedback:  1   1