I have an issue with an active form in Canvas for which I’m not able to enter data which is perfectly working in TM1 cube view or in active form XLS. The cell is displayed as writable, user is ok (both TM1 and Canvas), no security, no picklist, nothing special. The data I have to enter are a string element and the input works perfectly for consolidated level but not leaf level. I have tested with a simple element and it’s the same behavior, data enter for a leaf element are not taken into account and revert back to the original data.
Any idea of what can cause this issue ?
Thanks
Stephane
Just a guess: Is it any special character in the n-lvl element? Can you try input a value one more time, and just post only lastest error message, no need to post the whole log.
Also you can try to test input using an old tm1-ui-dbr directive.
here is the last records in log file:
2017-06-07 12:26:28 com.cubewise.rest.api.a ERROR ActionBase:365 POST: https://localhost:8877/api/v1/Cubes(‘Question%20Management’)/tm1.Update?_t=1496834788145
2017-06-07 12:26:28 com.cubewise.rest.api.a ERROR ActionBase:367 Body: {“error”:{“code”:“278”,“message”:“‘1.1.3 - 2.4 Are Hub Governance Rules & Key Tasks formalized and communicated’ can not be found in collection of type ‘Element’.”}}
Our Development team should decide whether it is a bug, rest api bug or not, but it looks this is a special character issue. Log says that ‘1.1.3 - 2.4 Are Hub Governance Rules & Key Tasks formalized and communicated’ can not be found. As for me the best practice is to avoid having special characters in a principle name.
Does another n-lvl element (which does not have special characters) works fine in the active form?
it’s not the principal name, that’s the alias description (so I do not know why it refers to the alias). The principal name is a code. And again for parent elements it works perfectly just for leaf
In this case an old tm1-ui-dbr directive ( where you are able to construct request with .key elements) may help at least as a temporary solution. If table is not big, you would not feel any difference in terms of performance.
I have also found some issues with the Canvas active form. I have created an active form using the page creator. I have also created a simple chart to reflect the values in the form as they are being entered.
The issue is that the totals/consolidated elements as well as the chart do not refresh after a value is entered.
Only after selecting a different element in the SUBNMs or by manually refreshing the entire page the data entered is reflected in the consolidation of the active form and the bar chart.
What do you mean about the consolidated elements? Do you mean how to grab them? You should be able to grab those via the same way that you are accessing it on the table row elements.
What I mean by consolidated elements is; if you look in below screen, the “Walk up” element is a leaf that sits under the C elements “Admissions” and “Consumer”. When entering a number in this active form against any leaf, in this case “Walk up”. The totals for “Admissions” and “Consumer” do not refresh despite being part of the same active form.
Luis is saying that creating an active form via the page creator in the admin console doesn’t refresh the totals in the active form if you change the editable cells.