Skip to Content
Author's profile photo Former Member

An easy way to build views or workbooks for charts when you donโ€™t have sufficient data in development system

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:

  1. Create your query in query designer in development system.
  2. Transport your query to production.
  3. Open your query in query analyzer in production.
  4. Make the changes necessary for the chart.
  5. Here is the trick. On the menu bar click on disconnect.
  6. Click on connect, and connect to development system.
  7. Click on refresh button.
  8. The view you have got will be loaded with development data but now you have exactly what you need to show your chart.
  9. Click on Save button to save it as a workbook or view.
  10. Transport your workbook or view.

Hope it helps.

Yasemin ULUTÜRK

Assigned tags

      17 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo CH Raman
      CH Raman

      Very useful information. thanks for making and sharing. if you add screens, its make more effective doc.

      Thanks

      Raman

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Raman. I can update it with screenshots in the next version ๐Ÿ™‚ .

      Author's profile photo CH Raman
      CH Raman

      Thanks for considering. Have a great day ๐Ÿ™‚

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      You have a great day too ๐Ÿ™‚

      Author's profile photo Former Member
      Former Member

      Nice sharing of your knowlwdge

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Sushant

      Author's profile photo Former Member
      Former Member

      Good Document..!

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Naveen.

      Author's profile photo Former Member
      Former Member

      Brilliant Trick.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Cem.

      Author's profile photo SVU 123
      SVU 123

      Thanks for Sharing the Workaround Yasemin.

      Author's profile photo Mehmet Ozgur Unal
      Mehmet Ozgur Unal

      helpful Mrs.Yasemin .....

      Author's profile photo Former Member
      Former Member

      Very useful tips. thanks for sharing

      Author's profile photo Former Member
      Former Member

      thanks for sharing

      cheers

      Raj

      Author's profile photo SRIKANTH GARBHAM
      SRIKANTH GARBHAM

      This document is useful specially when you are working from offshore where you have limited data access. Thanks for sharing.

      Srikanth.

      Author's profile photo Former Member
      Former Member

      Thanks for sharing tricks and tips.

      Author's profile photo Former Member
      Former Member

      Nice work around. Thanks for sharing, Yasemin !