Anyone able to connect to AX Odata Services through Tableau Dashboard?.I had faced some challenges initially and looked for some online help while learning & preparing this demonstration.īelow is the link to the discussion with Dynamics user community: There are lots of customers/clients still using this tool.īasically, this is to give a quick tour through the Tableau options available in the desktop version which were captured at a point in time, since it was designed some time ago. Tableau is now one of the Salesforce product which was recently acquired in 2019. Once the specified cube is set, the user can then drag the dimensions and measures from the list onto the design page layout to slice and dice the data according to the requirement.Īfter designing these pages, you can upload and publish/deploy them to the Tableau Cloud Server and share the content to the users, so they can access through the dashboards. Provide the Server Connection details of Microsoft Analysis Services, it should present you with the following screen displaying available list of cubes. Once the specified entity is set, the user can then drag the dimensions and measures from the available list onto the page layout.īELOW REPORT WAS DESIGNED USING SSAS OUT OF THE BOX CUBES.
$metadata - will list out all the Entities that are available in the system as demonstrated in the image below:Ĭonsuming the OData service entities from the available datasources.
TABLEAU DESKTOP 10.1 FULL
(Please prefer using full naming convention instead of localhost. Validate OData service is accessible in IE browser before consuming it. Once the Query is added, you can drag the dimension, measures, SUM fields onto the layout to slice and dice the data columns and rows the way you want.Ģ. Partition = 5637144576 Group By IT.DataAreaId, IT. Partition), 0) AS Purchased FROM InventTable IT _ Partition), 0) AS QtyBought, ISNULL(( SELECT SUM(PL.LineAmount) _ĪND PL. Partition), 0) AS Sales, ISNULL(( SELECT SUM(PL.QtyOrdered) _įROM PurchLine PL WHERE PL.ItemId = IT.ItemId AND PL.DataAreaID = IT.DataAreaID _ĪND PL. WHERE SL.ItemId = IT.ItemId AND SL.DataAreaID = IT.DataAreaID _ĪND SL. Partition), 0) _ĪS QtySold, ISNULL(( SELECT SUM(SL.LineAmount) FROM SalesLine SL _
TABLEAU DESKTOP 10.1 CODE
Copy Code SELECT UPPER(IT.DataAreaId) AS COMPANY,IT.ItemId,ISNULL(( SELECT SUM(SL.QtyOrdered) _įROM SalesLine SL WHERE SL.ItemId = IT.ItemId _ĪND SL.DataAreaID = IT.DataAreaID AND SL.
0 kommentar(er)
