Not Displaying in X3 Dashboard

Question

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

L.V. Expertise X3 · Answer

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.

Shereef · Answer

I also face the same issue and it got solved by delete and then re create all ( Dashboard, Sql query, Menu item, View..)

chunheng · Answer

Hi, check this kb: https://us-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=224924750070139 KB ID: 224924750070139

Sage X3

Not Displaying in X3 Dashboard

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING