Hello all,
I'm not too good at BW, but need to optimize a Query.
The problem is that I have too many Key Figures (Restricted + Calculated) in around 10 different Queries on a particular Cube. These 10 Queries relate to different logistical processes and areas in Stock processing. I have to create a new Query and include all these Key Figures within since a General Stock Overview is required. Many of these Restricted Key Figures contain the same Characteristics like "Material", "Time" etc.
I have to rebuild these Key Figures on the new Query as they require changes to be made and I have no access rights to change the original Key Figures. That means I have to create a whole lot of Key Figures all over again with the small changes. I thought there might be an alternative solution to doing that which I am not aware of. Maybe there is a solution to optimize the new Query with fewer Key Figures (Restricted). The Calculated Key Figures are few and in any case I cannot try to make changes since they are mere summations.
Waiting for some advice!! Thanks!!