TM1 Forum

You can try the mdx on control cube , eg }ElementAttributes_Branch. This will give you the list of elements in the dimension and also the attributes that attach to the dimension. Sorry for the late reply. I have got the attributes values for Branch dimension through }ElementAttributes_Branch. Now h...

Hi Experts, One of our TM1 architecture tool users creates '.cma' file by clicking on export dimension. Now we have to get same data by running mdx query in TM1 through ETL Tool - DataStage. What columns and rows to select in mdx query? For eg:- Dimension is Branch. Will the query be ... select {[Br...

Thanks for the help!! We are using ETL Tool-Datastage 8.7 to pull the records from TM1 through mdx query. I have ran the query with 'non empty' command and it returned 0 records .... :shock: .... this means all the results are having some 0 value. When I removed the 'non empty' clause there are almo...

Hi Experts, I am new to TM1 mdx query,actually I am ETL developer. Currently we are planing to pull the data directly from TM1 into our ETL process. For this is I am creating TM1 mdx query in our ETL process. Below is the query which I have created:- Select {[Branch].members} on rows, {[Time].member...