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

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