Here is a pretty simple request from my client - "Our work week starts on Monday and ends on Sunday. Can you make sure that the calendar in date prompt also starts from Monday?" Me - "Sure why not, MSTR is pretty flexible". I was so wrong! There is no [easy] way to do this in MicroStrategy.
One solution that 'kind of' worked for me:
1. In preferences, change the locale for date and numbers to European. This will change the display to show Monday first. Issue: Date format changes to DD/MM/YYYY and here in the US we need MM/DD/YYYY.
2. To address the 'side effect', based on TN 12819 (https://resource.microstrategy.com/Support/MainSearch.aspx?tnkey=12819&formatted=1) I made appropriate changes to format_config.xml.
This now changed the date format to US format when selected from Calendar Date prompt. But default values still showed up in European format. Furthermore, within the report the dates showed up as YYYY-MMM-DD and using Advanced Format didn't fix anything.
In summary, the issue still remains an issue. Please comment if you have suggestions to solve.
Think - calendar.js java script.
One solution that 'kind of' worked for me:
1. In preferences, change the locale for date and numbers to European. This will change the display to show Monday first. Issue: Date format changes to DD/MM/YYYY and here in the US we need MM/DD/YYYY.
2. To address the 'side effect', based on TN 12819 (https://resource.microstrategy.com/Support/MainSearch.aspx?tnkey=12819&formatted=1) I made appropriate changes to format_config.xml.
This now changed the date format to US format when selected from Calendar Date prompt. But default values still showed up in European format. Furthermore, within the report the dates showed up as YYYY-MMM-DD and using Advanced Format didn't fix anything.
In summary, the issue still remains an issue. Please comment if you have suggestions to solve.
Think - calendar.js java script.
Comments
Micro Strategy Training
Online Micro Strategy Training
micro strategy certification training
micro strategy certification training
msbi course training
spring boot certification course training
Indonesia Import Data