Convert String to formula

Hi Paul, I think it should work when you put this data field into a static value variable. You can then use this variable at the place in the analysis where you want to put the query. Cheers David

Hi Daniel, thanks for you quick answer. Unfortunately it doesnt work. The formula is not always the same in the table column. The formula has different parameter/arguments based on other data fields. If I use a static variable, it will be used only the first entry from the formula column. I have to map the correct formula to the corresponding data from another table. Cheers Paul

Hi Paul, if its different in every row, that doesnt work then. You probably have two options then:

1. Create a CASE WHEN containing which conformance formula should be used for which condition. You then have to push the formula to the component in your analysis. You have to get the TabkeChart object in python, and then add with the add_dimension() function. If you only want to do this once, you can just copy the CASE WHEN manually in the component in the CPM4 frontend.
2. You can send each conformance query separately via python first and get the query results in python. Then write the results into the table you are pushing. The downside is that when the data in your data model changes, you have to execute the script again (but maybe you need to do this anyways?).

Best David