Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Analysis 2.0 add excel formula between BW hierarchy

Hi All, 

I created a BW query where we leverage GL accounts hierarchy from ECC. 

Users have the ability to expand the node within the hierarchy.  Now, we want to add a formula for example Net Revenue minus COGS between the hierarchy.  In 2.0, we insert a row by clicking on new cells icon.  But the excel formula we set is gone after refresh.  Is there a workaround to have the excel formula there after refresh? Thank you very much for your insight. 

Lynn

Not what you were looking for? View more on this topic or Ask a question