we have the requirement to retrieve master data e.g account information in formula-optimized mode in AfO in order to help end user to create a report having the master data available to create sapgetdata() formulas.
For instance the end user should be able to retrieve all accounts below net sales in a column without typing in each item manually and leave some accounts out.
For dimensions without hierarchy this is possible using formula SAPListOfMembers() but this function (by design) does not allow this for dimensions with hierarchies.
Now the question is whether there is the chance to reach this with some workarround/ Modification?
Thank and best