Copying Members Names From a Text Application

You can copy members names from a text application, such as an Excel spreadsheet, and paste them as new members in the corresponding dimension in Financial Reporting Web Studio.

For example, you could copy the members names in the "Year" dimension in an Excel spreadsheet to a grid in Financial Reporting Web Studio that contains the "Year" dimension.

To copy members names from an application to Financial Reporting Web Studio:

  1. Open the source application and select the members to copy.
  2. In Financial Reporting Web Studio, open a report and select a grid.
  3. Select the dimension cell to which you want to copy members.
  4. In the formula bar, clear the content, then right-click, and then select Paste.
  5. Edit the text in the formula bar by adding commas between members.
  6. Click Validate button to verify the member names.