thank you it worked , i was struggling with the case statement

This is the full query 

USE DDS_QA

DECLARE
@Dimension_Type varchar(100),
@DBID varchar(10),
@code nvarchar(max),
@Canbedeleted INT = '',
@dependent INT = '' ,
@TableID varchar(100),
@Dimension_TypeList...

DECLARE
@SourceDBName varchar(100),
@code nvarchar(max),
@RunTimequery Nvarchar(max) ,
@TABLE_NAME varchar(100) ,
@Database_Name varchar(100) ,
@seriescode varchar(100),
@sqlCommand nvarchar(1000) ,
@sqlstatment nvarchar (max)

SET @SourceDBName = 'WDI...

Hi 

My current time dimension is yearqauater something like 1998Q1

The mdx query is not working