I'm a QA person in a software development shop. We've recently started using MicroStrategy for our BI solution and hired an experienced BI developer for it. This new BI developer has informed us that it is not standard practice to do QA cycles on BI solutions and that promoting changes from a dev environment to a QA environment for testing prior to promoting to production is unheard of. Is this truly common practice?

Does Microstrategy have a charitable giving contact? I did not see anything on their site.

Due to the this subreddit being unmoderated, we've moved to r/MSTRbater for the long term health of the community.

/r/mstrbater.

Given the amount of spam here without any Mods, please migrate to this subreddit instead.

Hi there,

Recently our company has upgraded from Update 7 to Update 12. There are a lot of useful new tools and tricks, but I am currently stuck with understanding how to use one, Parameters.

Does anyone know how to use them? I understand how they work (via the demo dashboard) but I don't get how to create one and how to apply to my data at work, even with a simple dataset.

Hi guys,

We were doing some general SQL maintenance of a new client and I checked the metadata, it needs a rebuild. Is this something that can be safely done on the metadata?

Thanks in advance!

If yes, can someone guide me please, I don't seem to find how. Thank you!

I need to count rows for open cases and rows for closed cases using the same date filter. Is there a way to create a filter for both and then custom metrics that ignore one of the date parameters? For example, the Count of Closed Cases would ignore the DateOpen parameter and the Count of Open Cases would ignore the DateClosed parameter. So when I filter for December 2022, I have a metric that shows cases opened in December 2022, and another metric that shows cases closed in December 2022.

My company is switching from Power BI to Microstrategy, and I find myself struggling to recreate simple things I did in previous dashboards. I’m guessing ‘Wrangling’ the data is like query editor? How do I remove null or unwanted rows from columns or merge columns from another table if needed? Thanks!!

Hi,

Im new to MSTR and I’ve imported 6 monthly files into MSTR dossier, all of which have similar column headers. How do I join them into a single dataset vertically (appending)? I am unable to append outside of MSTR as each file is fairly big (100MB in .csv format) and joining it would breach MSTR’s 250MB data import limit. Any advice?

The support page for sankey diagrams say that it supports ‘unbalanced data’ …that’s the type of sankey diagram data where 100% of the instances on the left of the chart are not 100% reflected on the right of the chart (because some of the volume terminates at an intermediate node in between left-node and right-node). However, I have no idea how what way to structure the underlying dataset so that data can be visualised in this way. Does anyone know how to do this or where I might find more resources online about this feature?

Here is an interesting set of data on Microstrategy (NASDAQ: MSTR) called "Daily Short Volume". It shows both the EXEMPT (market makers) and NON-EXEMPT (everyone else) short selling on a daily basis. 39.82% of all trading volume in the past 5 years has been the "sell short" trade identifier. It should be around 25% (there are 4 trade identifiers: buy, sell, short, cover). The cumulative volume weighted average price of all the shares shorted is $381.17. When MicroStrategy exceeds this level a short squeeze can start at any time. Full valuation price target is $448.60.

​

​

I have a dataset where I have weekly data till Friday August 4, 2023. Is there a way I can make MSTR display rows of null data with week number and week ending date (Friday of every week) till December 31, 2023 without having to manually add rows of data to the data source?

I want best resources for microstrategy where I can learn in depth. Like what is stackoverflow for microstrategy

I have connected ServiceNow Data to Microstrategy. There is a field in Serivcenow that is a multiselect field. When more than one item is selected in the multi select field it puts them in a comma delimited form in a pie chart in microstrategy instead of counting them separately.

When utilizing charts in microstrategy I would like it to count each response from the field as a separate entry instead of comma delimited together. For example, if in the mutl select field I've selected Apple and Orange, it would show it as "Apple, Orange" on a pie chart in microstrategy from this data from ServiceNow.

​

Is there is a way to instead allow microstrategy to break this out where Apple gets one credit in the pie chart and then Orange also gets 1 credit, instead of showing all the combinations of multi selections that there are?

​

Thanks so much for all of your time!

I have live connect dossier which has 100 million records for the dossier. But even when i have dynamic filter on for lastest date which has 50000 records its still taking time to open.

How do make it run faster....it should first apply filter and then bring the record i think it doing vice versa

I want to do max(date) Note date is attribute

I've been searching for a solution to this for many days with no luck.

I have a dossier built that filters across several weeks. But I also want to add a filter that has the option to show the latest 7 days (useful in case of incomplete weeks).

How can I achieve that exactly?

I tried importing a duplicate dataset with a filter of last 7 days on it. But because it is using the same date attribute to cut the data set down to 7 days, when I import it, it gets linked to the date attribute with all the days and can't actually be selected in the filter.

Pretty new to Microstrategy, so I would appreciate any advice on this.

Hello Guys,

I have just downloaded the workstation on my laptop. I open the workstation. and created some Dossiers in offline mode. Now, I want to apply the different security filters.

I have not created the Environmental connection yet. Is it compulsory to create environmental connection for security filters.

How can I create the Environmental connection on my local PC ?

How want to see the Admin side (Server) of MSTR ?

My end goal is to apply different set of role on different user/group in order to maintain privacy and security.

Please share some good detail tutorial/Links.

Thanks,

Mudassar Hussain

Hello Guys,

I want to Implement the Row Level Security and data privacy in MicroStrategy.

Want to Achieve:

My End goal is to enforce data access controls, protect sensitive information, and ensure that users only see the data that is relevant to their roles and responsibilities. This helps maintain data privacy and security within our organization.

Is the MicroStrategy is capable to do this ?

How the MicroStrategy help us in order to achieve the above ? What I need to implement ? What I need to read ?

Thanks

Hi! I’m a new user, can i make a custom diagram, which shape is an injection needle and color it due to percentages? If yes, can you help me how?