1 Reply Latest reply on Feb 22, 2016 2:28 AM by Amanjot Klair

    Accessing SASS Cube Dimension Properties

    Kevin Hulin

      I am attempting to include my project's name in a worksheet, however, the name is stored in the cube as a Member Property (rather than a measure).  (I've removed irrelevant content from the below screen capture.)

      SSAS_Project_Name.png

      In Microsoft SQL Server Management Studio, I am able to access the data I am seeking using this MDX query (filtering here on a specific project number 1234567):

      WITH
      MEMBER Measures.ProjectName as [Program].[Project_Task].Properties( "Project Name" )
      select 
      {Measures.ProjectName} on 0,
      from [MyCube]
      where [Project_Task].Project.[1234567];
      

       

      However, when I attempt to create a calculated member (as below), the field is always Null.

      ProjectName_Tableau.png