Hi,
Performance Tuning can done in script and design. Follow is few which i know
Backend:
- Avoid Calculated in UI instead i would prefer to use in script if it is possible
- Try to drop all fields which are not usable in design and load very less data if not needed. Ex - If you have data around 20 years data then load only 2 years data
- If you are loading tables which is similar try to store in QVD and use that.
- Flags are very powerful. You can use as many you want call them in set analysis for better performance.
Frontend:
- Use Set Analysis as much as possible.
- Try to use charts using Hide and Show future
- Restrict charts for only one chart and create buttons will reduce and save the time to Save(Ctrl+S)
- Calculated dimension is not the good idea, If so - Try using that Calc. in measure
- If..Else consume RAM instead Pick..Match can save some memory
Does it make sense??
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
