EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

MicroStrategy reports on Apple Watch


Robert Prochowicz

Manager, Sales Engineering • MicroStrategy


Thanks to the open nature of MicroStrategy platform and REST APIs it is possible to display reports on Apple Watch even without official MicroStrategy Apple Watch client. I will demonstrate how you can achieve it with 'Numerics' app.
ka04W000000ObG5QAK_0EM44000000RcKF.jpeg

There is no official Strategy client for Apple Watch, however REST APIs allow such an integration. I've found an app called Numerics that could display data on a watch face as a complication. On the main watch face I can now see my data. After tapping on it more data tiles can be opened.
SETUP
- I've created two Strategy reports in My Reports folder. Both of them contain just one row of data.
- On a separate machine I've created a Python script that runs according to schedule. This Python script generates two CSV files and saves them to a public folder on Tomcat. I am using mstrio and the code is very short and simple (see below).
- on iPhone I use 'Numerics' app to set up the connection and format the widget. I am providing URL address to CSV files. There are other data options within this app like JSON file (URL as well) or Google Spreadsheet. Important thing is that this app has particular requirements about file structure, Python code is very handy here (flexibility in formatting).
Apple Watch app checks the CSV files every 10 minutes (I believe) for updated data.
 


### PYTHON CODE ###
from mstrio import Strategy
conn = Strategy.Connection(base_url="https://your.server/StrategyLibrary/api",
                               username="QQQQQQQQQQQ", password="XXXXXXXXXXXXX",
                               project_name="YYYYYYYY", login_mode=ZZ)
conn.connect()
report_dataframe = conn.get_report(report_id='2081C97211E909BFB9810080EFE54C63')
report_dataframe[['Activity Robert %']].to_csv('activity.csv', index=False)
report_dataframe = conn.get_report(report_id='51C78AE411E909D8710B0080E6A59CFB')
report_dataframe[['Activity Team %']].to_csv('team.csv', index=False)

Generally I can see some use cases for Apple Watch in retail. If the store manager wants to be very close to the results of ongoing promotions Apple Watch is as close as you can go. If the promotional sales is dropping (because the product is not on the shelf) you can see it just by raising up your arm.


Comment

0 comments

Details

Example

Published:

December 28, 2018

Last Updated:

November 21, 2022