Hi,
We have a TM1py python program that runs MDX queries against our TM1 server. We run MDX queries concurrently and our MDX queries look like this.
SELECT
{{TM1SubsetToSet([Attribute Measures].[Attribute Measures],"List_of_Attributes","private")}} ON 0,
{{DESCENDANTS([Organizations].[Organizations].[{first_value}].[{second_value}],99,LEAVES)}} ON 1
FROM [Node Attribute]
We loop through it with different first value and second value combinations.
The MDX queries do not always work, and we wonder why? My colleagues had more success in running it than me.
They usually received this error, Text: '{"error":{"code":"65","message":"ObjectSecurityNoReadRights"}}' - Status Code: 400 - Reason: 'Bad Request',
while I received this error, "code":"501","message":"List_of_Attributes: Cannot resolve TM1 subset (rte 114)
And I never had any success in running the same MDX queries. My success only came when I rewrote the query to use the individual attributes instead of using the List_of_Attributes.
Anyone has insight into how to find out what the problem is? We are new to MDX. Is it the way we constructed the MDX? Could it be the concurrent programming? I think my colleague used AI to help writing the concurrent programming.
For now, my colleague added an error check to re-run the query if it fails. Sometimes the query will success and sometimes it fails. Strangely though, when there is success, sometimes, there data are all 0 or blank, though we know there are data.
Thank you
Edited
3/20/2025
Since I cannot delete my own post, I will edit it instead.
Putting a hold on this.
One of my colleagues seemed to be able to get it to working mostly. Therefore, would like to put a hold on this until it becomes an issue again.
Thanks.