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

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

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

    ‏2009-09-15T02:36:08Z  
    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

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

    ‏2009-09-15T02:46:03Z  
    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

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

    ‏2009-09-15T10:14:04Z  
    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.
    Wonderful ! Thanks a lot!!
  • SystemAdmin
    SystemAdmin
    801 Posts

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

    ‏2009-09-20T20:44:43Z  
    • wudongf
    • ‏2009-09-15T02:36:08Z
    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);
    }
    Hi, am just stuck up with another issue as in the attachment, can i get help with it pls.
  • wudongf
    wudongf
    289 Posts

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

    ‏2009-09-21T02:09:15Z  
    Hi, am just stuck up with another issue as in the attachment, can i get help with it pls.
    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

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

    ‏2009-09-21T14:13:58Z  
    • wudongf
    • ‏2009-09-21T02:09:15Z
    Hi,

    I think you'll need to clear the data in xmlAllBrResponse at the beginning of selectAllBrnQueryResults.
    E.g. waa.getVariables().setXml("xmlAllBrResponse", null);
    Hi Dong, thanks for the reply but it still doesnot resolve the issue....
  • wudongf
    wudongf
    289 Posts

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

    ‏2009-09-22T09:41:00Z  
    Hi Dong, thanks for the reply but it still doesnot resolve the issue....
    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

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

    ‏2009-09-22T09:46:56Z  
    • wudongf
    • ‏2009-09-22T09:41:00Z
    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.
    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

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

    ‏2009-09-22T13:26:14Z  
    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.
    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

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

    ‏2009-10-20T08:59:53Z  
    Hi, am just stuck up with another issue as in the attachment, can i get help with it pls.
    Where are the Html template file please?
  • SystemAdmin
    SystemAdmin
    801 Posts

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

    ‏2009-10-20T09:06:57Z  
    Where are the Html template file please?
    The issue is resolved.
  • SystemAdmin
    SystemAdmin
    801 Posts

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

    ‏2009-10-20T15:09:58Z  
    Where are the Html template file please?
    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

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

    ‏2009-10-21T02:21:08Z  
    Do you mean the HTML template file used in Summary Drilldown builder? The template files ares specified as default values in the builder UI.
    Please look at this picture, how to solve this problem?
  • SystemAdmin
    SystemAdmin
    801 Posts

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

    ‏2009-10-21T09:26:37Z  
    Please look at this picture, how to solve this problem?
    Please verify if the file ATtoInv.htm is under %Your_Project_Dir%/WebContent/solutions/dashboard/ folder
  • SystemAdmin
    SystemAdmin
    801 Posts

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

    ‏2009-10-22T03:30:13Z  
    Please verify if the file ATtoInv.htm is under %Your_Project_Dir%/WebContent/solutions/dashboard/ folder
    Above the compression packages do not have this file.
  • SystemAdmin
    SystemAdmin
    801 Posts

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

    ‏2009-10-22T07:36:56Z  
    Above the compression packages do not have this file.
    PFA file.Hope this helps, But the issue is resolved long back with Dong's help.
  • SystemAdmin
    SystemAdmin
    801 Posts

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

    ‏2009-10-22T07:37:27Z  
    PFA file.Hope this helps, But the issue is resolved long back with Dong's help.
    Sorry PFA.
  • SystemAdmin
    SystemAdmin
    801 Posts

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

    ‏2009-12-16T03:11:24Z  
    Sorry PFA.
    Where is the "stannah.dashboard.servicesKPI.InputParam" please?
  • SystemAdmin
    SystemAdmin
    801 Posts

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

    ‏2009-12-16T08:51:01Z  
    Where is the "stannah.dashboard.servicesKPI.InputParam" please?
    PFA.
  • SystemAdmin
    SystemAdmin
    801 Posts

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

    ‏2009-12-17T00:45:06Z  
    PFA.
    Hi:
    Can you give me the project successful to have a look at?
    Thank you.