How to make Calculated members dynamic

• ramrajan

  SSCommitted

  Points: 1737

  More actions

  March 30, 2015 at 8:21 am

  #316754

  I have the below query which calculated Percentage cost of my chemical, My dimenssions which are mentioned

  [Custom Batch Data].[EcolabTextileId].[EcolabTextileId],[Custom Batch Data].[EcolabTextile].[EcolabTextile]

  are changed dynamically , so i want to make a generic query so that i dont need to repaeat the With member for different dimenssions

  So any one can help me to find the way

  WITH member [Chemical Mix %] as

  '([Custom Batch Data].[EcolabTextile].CurrentMember,[Measures].[Price])/([Custom Batch Data].[EcolabTextile].CurrentMember.Parent,[Measures].[Price]) * 100'

  select NON EMPTY ({[Measures].[Price],[Measures].[Totalweight],[Chemical Mix %],[Measures].[NoofLoads]}) ON Columns, NON EMPTY ([Custom Batch Data].[EcolabTextileId].[EcolabTextileId],[Custom Batch Data].[EcolabTextile].[EcolabTextile]) ON ROWS FROM [TCDReport]