SUMMARY:
The statistics referred to in this technical note are for recording Mobile Client activity to Enterprise Manager 9.x. The issue in the technical note is considered a defect in 9.x. There are no workarounds for the behavior.
SYMPTOM:
After enabling mobile stats in the project configurations, mobile executions are logged to table CT_EXEC_STATS but no device exists for those executions in CT_DEVICE_STATS in Strategy Enterprise Manager 9.x.
STEPS TO REPRODUCE:
1. Enable mobile stats by going into Project Configuration
2. On the Statistics tab, enable both "Basic Statistics" and "Mobile Clients"
3. Reload the project or restart the Intelligence Server
4. Run a report on the iOS Mobile device.
5. Access the CT_DEVICE_STATS table in the Stats warehouse, you will see the Columns: APPVER, OS, OSVER, STATECOUNTER are all empty, where all the other columns are logging results.
CAUSE:
This is a known issue with Strategy Entperise Manager with Mobile Statistics.
ACTION:
Make sure both the Mobile operating system and the Strategy Mobile application is up to date, and try again.
This issue has been fixed in Strategy 10.x. Upgrade to the latest Strategy Platform Release or Feature Release version to take advantage of the fix.
TO LEARN MORE:
KB42730: "Error executing the following SQL -- CREATE TABLE CT_DEVICE_STATS...TABLE ALREADY EXISTS" error message is encountered when upgrading the statistics tables to MicroStrategy 9.3.0
KB44197: Warehouse tables for Mobile clients in MicroStrategy 9.x and 10.x
KB44150: In MicroStrategy Intelligence Server 9.3.x, the project configuration > statistics option "Mobile Client Manipulations" doesn't log any Statistics data
