I want to create a row template in HFR, there are almost 500 members in rows and we already have them listed in an excel sheet in rows. They are not under a particular hierarchy so cannot choose the relationship functions ( like idesc or children and all). Is there a way we can copy paste it some way in HFR from excel or do we need to pick every member in HFR separately.
Firstly format the members in excel such that they end with a comma, then "Copy" and "Transpose" paste these on a new cell in excel.
Copy the transposed line and paste in financial reporting studio in the formulae bar & click save.