Generally, the clients ask for many charts on WAD templates or workbooks. If you don’t have sufficient data to generate the graphics, it may get very difficult to build the required queries or views. I just wanted to share a simple trick which I have learnt from my colleague Fatih Cagiran .
Here are the steps to generate a query for a chart where you can foresee how it will be seen in the production environment:
- Create your query in query designer in development system.
- Transport your query to production.
- Open your query in query analyzer in production.
- Make the changes necessary for the chart.
- Here is the trick. On the menu bar click on disconnect.
- Click on connect, and connect to development system.
- Click on refresh button.
- The view you have got will be loaded with development data but now you have exactly what you need to show your chart.
- Click on Save button to save it as a workbook or view.
- Transport your workbook or view.
Hope it helps.