Home      Functions     Common Solutions      Contact     






MDX Functions:
 
MDX Functions

 
Common Solutions

Common Solutions
 
Resource Links

MDX Books
MDX Related Software
MDX Related Blogs
 
Other Links

Contact Us
 
Microsoft SQL Server Analysis Services Function Page
Function Name: CustomData
Category: Other
Description: The CustomData function returns the value of the CustomData connection string property if it is included in the connection string. If the CustomData connection string property is not included in the connection string, null is returned.
Syntax: CUSTOMDATA
Technet Link: MDX CustomData Function




The query below would return the CustomData property in the connection string for the current connection (if it exists).
 
WITH
      MEMBER [Measures].[CustData] AS
      CUSTOMDATA()
SELECT
      {[Measures].[CustData]} ON COLUMNS
     
FROM
      [Adventure Works]
 
The query above returned null for me because the connection string that SQL Server Management Studio uses by default does not include the CustomData property.
 

 
 

 
Copyright 2008 by MDXpert.com.
 
Terms of Use                              Privacy Statement
 
Site Powered By - WinHost.Com