I would like to know if there is a facility to 'dump' the configuration of each query into a spreadsheet for the purpose of having it documented for future reference.
I specifically would want to know the Characteristics, Key Figures that are used, whether they are used as a filter, or used in rows or columns or as free characteristics. I would also want to know what restricted key figures or calculated key figures are used. Furthermore, I would also want to include the 'properties' for each item and the overall query properties including any 'conditions' or 'exceptions' that have been used.
Basically this will include everything I have incorporated into the design of the query i.e from kowing the technical name of the query through to the order in which 'objects' are arranged in the column or row and whether it is 'scaled' 'hidden' etc. etc.
I would welcome any advice. (It's a long and tedious task documenting everything!)
Thanks in advance.