In HP SM 9.4 - creation of Dashboard for Custom table data

Hi All,

I am tryint to create dashboard\charts in my SM9.4. but while trying to configure the dashboard for my custom table i am not able to see the name fo my table in 'Source Data' drop down field. It is having the list of only OOB tables and not custom tables. By doing what changes I will be able to see my table in the drop down list? can any one help me on this issue and creating charts for custom tables in SM9.4?

Please find the attached screenshots for reference.

 

Thanks & Regards,

DMK

  • Verified Answer

    Hello DMK,

    if you recently created the new customized table you want to use in a report, please logout and login to SM (Service Manager) again.

    I tested that myself by these steps:

    1. create a new dbdict with name "heike"
    2. create new formats for that dbdict
    3. create some records for that dbdict
    4. logoff SM
    5. login to SM again
    6. System Navigator - Dashboard
    7. Create Dashboard
    8. give it a name and description
    9. Add Content
    10. Create New report
    11. Source data: heike - heike

    Background:

    The format displayed to create the new report is "inbox.report.chart"

    The list behind label "Source Data" is using the variables

       Value list: $G.report.tableList.key
       Display List: $G.report.tableList.display

    The variables are defined within ScriptLibrary record "reportingHelp" and is based on the variable "$G.files" which is the list of all dbdicts available. There are some more restrictions depending on the ownership but if you use first of all a SysAdmin user to test this, you should be able to see your customized table.

    This global variable "$G.files" is updated when you login to SM. If you create a new dbdict you need to re-login to SM to make this new dbdict available in $G.files and therefore in variable $G.report.tableList.key and $G.report.tableList.display .

    About the naming convention:

    As long as you don't have an Object defined for your new dbdict it uses simply "name - name", in my case "heike - heike"  in the list of Sources.  The list of sources is sorted alphabetically and shows the uppercase values first. Scroll down in the list or just start typing the dbdict name should show you your new customized dbdict.

    If you create an Object and use a display name for your dbdict in datadict record this looks different.

    Please test yourelf again and let me know if you have further problems with using your customized table in dashboards.

    Best regards,

    Heike

  • Hello Heike,

    Thank you very much for the detailed explanation, i have tried the steps you suggested and it worked for me, Thanks a lot.

     

    Thanks & Regards,

    DMK