tag:blogger.com,1999:blog-3546795444588179926.post888554431930441801..comments2024-03-28T00:39:52.391-07:00Comments on Alex on DAX (Alex Kwitny): Usage data explainedAlex Kwitny (Kwitwell.com)http://www.blogger.com/profile/12458072273859749789noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-3546795444588179926.post-45616642533907056862012-04-09T10:37:25.902-07:002012-04-09T10:37:25.902-07:00Oh, also, in the "before" system, you do...Oh, also, in the "before" system, you don't really need to concern yourself with the code at all...just the database before your changes, because you only need to see the value in that container.<br /><br />So no need to try and revert code, etc. Just a previous database backup that has the one record in it.Alex Kwitny (Kwitwell.com)https://www.blogger.com/profile/12458072273859749789noreply@blogger.comtag:blogger.com,1999:blog-3546795444588179926.post-52678046195519453362012-04-09T10:33:59.153-07:002012-04-09T10:33:59.153-07:00This is sort of hard to do an example for, but I c...This is sort of hard to do an example for, but I can tell you how you might be able to figure out what went wrong. You need to setup a before and after system.<br /><br />In the before system, go to the AOT>Forms>SysLastValue, then right-click on the SysLastValue DATASOURCE, and go to Add-Ins>Table Browser. This is a sneaky way to view hidden tables. Find the object that you're having usage data issues with in this table for a user.<br /><br />Under the value column, it looks blank, but click on it, then click the lookup/dropdown, and it will invoke "conview(...)" so you can see the contents of the usage data in a tree view.<br /><br />Do this in your after system too and compare the difference. They might look identical, but that's because the usage data doesn't match the new form, so reset the usage data for that object for a user, then re-make your changes by hand, then look at the usage data again.<br /><br />This will let you see how the system expects the usage data to be stored. If you really need a fix, you can create a job to repair usage data for specific objects if you can figure out the change.Alex Kwitny (Kwitwell.com)https://www.blogger.com/profile/12458072273859749789noreply@blogger.comtag:blogger.com,1999:blog-3546795444588179926.post-14928271364069487582012-04-09T10:13:49.529-07:002012-04-09T10:13:49.529-07:00Nice post, Alex!
An example would be a great idea....Nice post, Alex!<br />An example would be a great idea.<br />We're now observing some unexplained loss of usage data after the last build we did...EugeneGTIhttps://www.blogger.com/profile/05259880469948209979noreply@blogger.com