x Want to participate? Join the group to interact
  • State Suggested Answer
  • Replies 5 replies
  • Answers 3 answers
  • Subscribers 138 subscribers
  • Views 2487 views
  • Users 0 members are here
Browse Forums
Announcements
238
topics
29
replies
General Discussion
5k
topics
13k
replies
Sage Data & Analytics
56
topics
95
replies
Sage Enterprise Intelligence
212
topics
422
replies
Sage Intelligence Reporting
121
topics
322
replies
erandarg

Not Displaying in X3 Dashboard

SUGGESTED
Posted By

Hello,

I have created a SQL query to show the top ten customers using SINVOICE table. Under Characteristics, Representation set to "Character and Graph". When it validates and run it shows the List and the graphs properly. But when it adds do dashboard only list shows. The graph does not appear. Can anyone help me to rectify this?

Regards,

Eranda  

Parents
  • 0
    SUGGESTED

    Hello,

    Simply, Sage X3 from V7 to V12 can't show a SQL Query on the dashboard.

    You have to use the graphical requester for instance if you want to add a request on your dashboard.

    A trick is to create a view with the SQL query and to call this view like a table from the graphical requester. It isn't always possible but it seems to be in your case.

    Hope it will help you.

    Regards.

Reply
  • 0
    SUGGESTED

    Hello,

    Simply, Sage X3 from V7 to V12 can't show a SQL Query on the dashboard.

    You have to use the graphical requester for instance if you want to add a request on your dashboard.

    A trick is to create a view with the SQL query and to call this view like a table from the graphical requester. It isn't always possible but it seems to be in your case.

    Hope it will help you.

    Regards.

Children

*Community Hub is the new name for Sage City