I need to merge different queries and data from an Excel file. Therefor I cant work with live data directly in Lumira designer and can't use hierarchies directly from SAP BW. Due to this I have the problem that I need to create a hierarchy in Lumira discovery which does not get transferred when adding the data source from discovery as offline data into the designer.
Is there any solution to transfer the hierarchy information or even create a new hierarchy in designer?
Thank you for your help!