Automate Stuff with System Manager - MicroStrategy

[@richardong5267]

I really enjoy all of your tutorials, James, but most especially the way you teach each lesson. You are a natural-born teacher. I first came upon your MSTR Architect course at Udemy and since then, I have watched several more videos that you've done via your website and directly in KZbin. It's my Go-To videos to refresh my knowledge of everything related to MSTR especially when I haven't used a specific process for a long time. Keep on making more!

[@thehanuu]

Thank you James, great video

[@tamaravuletic4670]

Hi James, great video. Is there a way that we can use this process to trigger incremental refresh reports?

[@devita73ful]

great video James!

[@JamesOliver]

Glad you enjoyed it

[@sauravchaudhury802]

I must say this is Amazing video.. and the example you cited here is a very much real time scenario used in Projects once the ETL/Data load is completed.. Request you to make a series or more videos on command manager and system manager if possible.. Keep up the good work !!

[@JamesOliver]

Thanks for the kind words and ideas! Let me know if there is anything specific you would like to see regarding System Manager or Command Manager.

[@sauravchaudhury802]

@James Oliver , Maybe things like create attributes or facts from scripts in command manager, and check if it is cost effective route to follow rather than manually creating the schema objects in microstrategy developer. It will be of great help if you can make a crash course video on Intelligent cubes, cube refresh options, design analysis criterion before start building the ICube as applicable in real time project situations.

[@kob408]

Perfect use case that I needed for my work

[@chrisfielding7645]

Great video James, can't wait to try this out. Have previously been doing this through the command prompt but this looks lots more versatile. In terms of another video I would love to see what you are doing with the Narrowcast server in terms of distributing multiple reports at a time. This is exactly the sort of thing that I would like to do and I have only been able to send a single report with Distribution Services. Keep up the good work. Chris

[@JamesOliver]

Thanks! Sure, I can do a video on Narrowcast. And yea not being able to send multiple attachments is the main reason why I cannot move to Distribution Services as of yet.

[@hakan0045]

Is there any way to create .bat file without password typing? This is not secure for our customer. Thanks.

[@venkatabhiram194]

How can we trigger the Subscriptions after cube refresh completed through SM ?

[@ddddinnnno4ka]

You can use Command Manager script as a part of the System Manager workflow, saying "trigger subscription..." or "trigger even...t"

[@abdulkhader101]

Awesome.. Help to do more admin vedios James Oliver.. I am following you everywhere. :)

[@JamesOliver]

Thank you for your support. It is much appreciated!

[@simosmetaxas6257]

Great video

[@chandrakumarreddyvennapusa7806]

How can we use our GMAIL for testing purpose ?Could you please suggest me

[@JamesOliver]

Try using the "Send Email" function and entering smtp.gmail.com as the SMTP Server and then use port 587. Also populate your user name and password under TLS section.

[@chandrakumarreddyvennapusa7806]

what is .trg file and can u show us what code it has ?

[@JamesOliver]

.trg file is just a made up extension to indicate it is just an empty file that serves as a flag to trigger certain things.

[@simhakotni]

Hi James...thanks for the video. How do the ETL team load file into Microstrategy server? Answer to this question will help me solve my problem.

[@JamesOliver]

I might be misunderstanding but your ETL team should load data into the data warehouse. Why would they load files into Mstr?

[@simhakotni]

@@JamesOliver thanks for your reply. Maybe I was not clear with my question. I was asking about the trigger file (empty file) generated by ETL that the decision box checks for. At 4:52 you were discussing about it.

[@JamesOliver]

@@simhakotni Sorry for late reply. So the ETL team would simply create this empty file on any server they choose and the Mstr workflow would simply use this file to indicate the ETL is complete. ETL team can use whatever method they choose to create this empty file after the ETL is complete like a shell script or batch file etc.

[@thirumalaip6458]

Thanks a lot for the video.

[@JamesOliver]

You are very welcome.

[@mugundhg]

Awesome 👏👏, how to start execution depending on database flag table???

[@itsmerhlgupta]

Thanks for the video. Create a video on creating a report from scratch in MicroStrategy

[@JamesOliver]

Thanks for the idea. Yes, I plan to create a video for beginners that will cover that.

[@itsmerhlgupta]

@@JamesOliver Awesome! looking forward to it