Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

MDX query with range in where condition

Hi All ,

I have a MDX query which is retrieving data from BW ,

APPEND 'SELECT' TO lt_mdx.

APPEND 'NON EMPTY { [Measures].[D478AI4915PGBGUNCJKU9U4DG],' TO lt_mdx.

APPEND ' [Measures].[D478AI4915Q8036EO30GC9IN8] ' TO lt_mdx.

APPEND ' } ON COLUMNS, ' TO lt_mdx.

APPEND 'NON EMPTY { [0MATL_GRP_2].MEMBERS , ' TO lt_mdx.

APPEND '[0MATL_GRP_3].MEMBERS , ' TO lt_mdx.

APPEND '[0PLANT].MEMBERS } ON ROWS ' TO lt_mdx.

APPEND 'FROM RCHL_M01/STQ_CHLD_Q002 ' TO lt_mdx.

APPEND 'WHERE (' TO lt_mdx.

CONCATENATE '[0MATL_GRP_2].[' lv_mat2 '] , ' INTO lv_where. APPEND lv_where TO t_mdx.

CONCATENATE '[0MATL_GRP_3].[' lv_mat3+1 '] , ' INTO lv_where. APPEND lv_where TO lt_mdx.

CONCATENATE '[0PLANT].[' lv_plant '] ) ' INTO lv_where. APPEND lv_where TO lt_mdx.

The above query fetches data but its repetative and also with some blanks in 'DATA(field)' column of the internal table I am storing.

and also is it possible to pass the range in where condition ,

Thanks in advance for any input .

Regards

Vinay kolla

Tags:
Not what you were looking for? View more on this topic or Ask a question