Thanks for your sugestion I did see this option where you can create own calculated fiends, I was checking if we can get custom MDX, like we have Custom SQL while creating connection.
ohh okay :)..
Can you post this in Idea section?, It will be nice feature to have.
On Wed, Nov 27, 2013 at 10:21 PM, Netra Pokhrel <
I got a solution for your requirement while exploring OPENQUERY today. It is a very simple workaround and many people may be using it already.
We can write custom MDX in Tableau using the Microsoft SQL Server->Custom SQL connection with OPENQUERY.
Step 1: Add the SQL Analysis server as a Linked server to the SQL Database Server
Step 2: Encapsulate the MDX query in an SQL query with OpenQuery
Select * from OPENQUERY ( "linked_server" ,'Custom MDX' )
Step 3: Open Tableau -> Connect to Data -> Microsoft SQL Server-> Custom SQL -> Paste the Step :2 Query.
Hope this will help you!
it works perfectly I need to see how it performs as it's open query
sometime it takes longer execution time for open query.
Once again thanks for your help, good job.
This might be totally our server related issues, I got this error message
while deploying to server, is there anything I need to special while
deploying to server for this type of query?
An unexpected error occurred on the server. If you continue to receive
this error please contact your Tableau Server Administrator.
TableauException: SQL Server database error 0x80004005: Login timeout
expired SQL Server database error 0x80004005: A network-related or
instance-specific error has occurred while establishing a connection to
SQL Server. Server is not found or not accessible. Check if instance name
is correct and if SQL Server is configured to allow remote connections.
For more information see SQL Server Books Online. SQL Server...
2013-12-20 16:54:26.872 (UrR2AsCoER0AABe89eQAAAGP,1,1)