Topic
20 replies Latest Post - ‏2009-12-17T00:45:06Z by SystemAdmin
SystemAdmin
SystemAdmin
801 Posts
ACCEPTED ANSWER

Pinned topic Single Summary & Drilldown builder to show the graph with many sql's

‏2009-09-14T16:20:47Z |
Hello,

Can any one help how to achieve a graph with the values o x-axis form different SQL's as in the attachment.

Thanks in advance!!
Updated on 2009-12-17T00:45:06Z at 2009-12-17T00:45:06Z by SystemAdmin
  • wudongf
    wudongf
    289 Posts
    ACCEPTED ANSWER

    Re: Single Summary & Drilldown builder to show the graph with many sql's

    ‏2009-09-15T02:36:08Z  in response to SystemAdmin
    Hi,

    It looks that in the method getInvDays, you are trying to create a new XML to assign to xmlResponse variable, that's why only the last result is showed.
    You can try some code like this:

    IXml transactionDetailsList=waa.getVariables().getXml("xmlResponse");
    if(transactionDetailsList ==null){
    transactionDetailsList = XmlUtil.create(DashboardConstants.TRAN_SUMMARY_DETAILS_LIST);
    }
    • SystemAdmin
      SystemAdmin
      801 Posts
      ACCEPTED ANSWER

      Re: Single Summary & Drilldown builder to show the graph with many sql's

      ‏2009-09-20T20:44:43Z  in response to wudongf
      Hi, am just stuck up with another issue as in the attachment, can i get help with it pls.
      • wudongf
        wudongf
        289 Posts
        ACCEPTED ANSWER

        Re: Single Summary & Drilldown builder to show the graph with many sql's

        ‏2009-09-21T02:09:15Z  in response to SystemAdmin
        Hi,

        I think you'll need to clear the data in xmlAllBrResponse at the beginning of selectAllBrnQueryResults.
        E.g. waa.getVariables().setXml("xmlAllBrResponse", null);
        • SystemAdmin
          SystemAdmin
          801 Posts
          ACCEPTED ANSWER

          Re: Single Summary & Drilldown builder to show the graph with many sql's

          ‏2009-09-21T14:13:58Z  in response to wudongf
          Hi Dong, thanks for the reply but it still doesnot resolve the issue....
          • wudongf
            wudongf
            289 Posts
            ACCEPTED ANSWER

            Re: Single Summary & Drilldown builder to show the graph with many sql's

            ‏2009-09-22T09:41:00Z  in response to SystemAdmin
            I may misunderstand your original problem.

            What's your problem is that: each time when you click Go button, a new copy of data will add in the end of the previous data, right?

            Should work.
            • SystemAdmin
              SystemAdmin
              801 Posts
              ACCEPTED ANSWER

              Re: Single Summary & Drilldown builder to show the graph with many sql's

              ‏2009-09-22T09:46:56Z  in response to wudongf
              Yes u ahve understood the problem correctly but even I too wonder as to why it doesnot work and each time i press the Go button the data is just added.
              • wudongf
                wudongf
                289 Posts
                ACCEPTED ANSWER

                Re: Single Summary & Drilldown builder to show the graph with many sql's

                ‏2009-09-22T13:26:14Z  in response to SystemAdmin
                My only suggestion is that:
                add some log to trace waa.getVariables().getXml("xmlAllBrResponse") in the beginning and end of selectQueryResults to see whether it is specified properly.
      • SystemAdmin
        SystemAdmin
        801 Posts
        ACCEPTED ANSWER

        Re: Single Summary & Drilldown builder to show the graph with many sql's

        ‏2009-10-20T08:59:53Z  in response to SystemAdmin
        Where are the Html template file please?
        • SystemAdmin
          SystemAdmin
          801 Posts
          ACCEPTED ANSWER

          Re: Single Summary & Drilldown builder to show the graph with many sql's

          ‏2009-10-20T09:06:57Z  in response to SystemAdmin
          The issue is resolved.
        • SystemAdmin
          SystemAdmin
          801 Posts
          ACCEPTED ANSWER

          Re: Single Summary & Drilldown builder to show the graph with many sql's

          ‏2009-10-20T15:09:58Z  in response to SystemAdmin
          Do you mean the HTML template file used in Summary Drilldown builder? The template files ares specified as default values in the builder UI.
          • SystemAdmin
            SystemAdmin
            801 Posts
            ACCEPTED ANSWER

            Re: Single Summary & Drilldown builder to show the graph with many sql's

            ‏2009-10-21T02:21:08Z  in response to SystemAdmin
            Please look at this picture, how to solve this problem?
            • SystemAdmin
              SystemAdmin
              801 Posts
              ACCEPTED ANSWER

              Re: Single Summary & Drilldown builder to show the graph with many sql's

              ‏2009-10-21T09:26:37Z  in response to SystemAdmin
              Please verify if the file ATtoInv.htm is under %Your_Project_Dir%/WebContent/solutions/dashboard/ folder
              • SystemAdmin
                SystemAdmin
                801 Posts
                ACCEPTED ANSWER

                Re: Single Summary & Drilldown builder to show the graph with many sql's

                ‏2009-10-22T03:30:13Z  in response to SystemAdmin
                Above the compression packages do not have this file.
  • SystemAdmin
    SystemAdmin
    801 Posts
    ACCEPTED ANSWER

    Re: Single Summary & Drilldown builder to show the graph with many sql's

    ‏2009-09-15T02:46:03Z  in response to SystemAdmin
    Hi,
    From the doc you attached, I guess you're going to create a chart with multiple columns on x-axis, but every of these columns is from separate SQL calls. If I'm right on understanding your question, I think the general solution for your request is as following:
    1. Invoke all the SQL calls to get data from database
    2. Composite the results of SQL calls into a single XML data
    3. Create a variable and schema for the new XML generated in last step
    4. Specify the XML data in the Summary&Drilldown builder

    There is also another possibility that in the chart the number of columns on x-axis is changing, that means, sometime there are 5 columns, and sometimes 6. In such case, creating schema for the composite XML data is not a good way. If you're facing such case, you'd better user "WebCharts - Enhanced" builder with which you need not minding about the schema which the Summary Drilldown builder needs.
    • SystemAdmin
      SystemAdmin
      801 Posts
      ACCEPTED ANSWER

      Re: Single Summary & Drilldown builder to show the graph with many sql's

      ‏2009-09-15T10:14:04Z  in response to SystemAdmin
      Wonderful ! Thanks a lot!!