Product idea exchange

Share your feature requests with our product team.

Product idea exchange

Share your feature requests with our product team.

Product idea exchange

Share your feature requests with our product team.

1

Review

Our guidelines prior to submitting ideas.

2

Explore

And search current ideas before sharing your own.

3

Contribute

And comment on existing ideas.

4

Submit

Your own ideas to suggest product enhancements.

New Post

To speed up and / or make the design prozess more "agile/userfriendly", instead of executing the dashboards everytime with "all data" a "Run with Option" Button would be helpfull.

Specially when handling large Datasets:

Via the "Run with Option" Button we could configure how to process during the design-phase:

 

1. Run with "no Data": Shows "placeholder-data" instead of any real data.

2. Run with "limited Data": Shows n-Rows of real data. User can set the Number of rows manually.

3. Run with "all Data". Shows all data, as it is today.

 

Benefit: Save-Time during Design-Phase specially when handling large datasets.

 

 

As we have explored the new "My Page" feature, we've compiled a list of suggested improvements to make it more viable in a SaaS/OEM deployment of MicroStrategy such as we have here at Premier.  We think it's a cool feature and the suggestions below would make it viable for us.

 

1. We would like the ability to manage the default My Page layout and have the ability to allow or disallow users to change it.  Right now, it seems users can do whatever they want.

2. Recents section is being pulled from browser cache, not from metadata. So, once user clears cache all the Recent history is gone.  Need to move this to metadata-managed and not browser-managed.

3. By default the initial Recent section shows MicroStrategy Demo dashboards which are not related to Premier nor Premier projects (remember, we're SaaS/OEM).  We don't see any way to override this from showing MicroStrategy content initially - an administrator should be able to point Recents initially at a pre-defined folder of content within a specific project (e.g. project-level path setting) or to the user's History List most recent N number of messages.

4. In the Recent section, consider showing N (configureable may be) number of entries for the specified content path and include a checkbox to include a History List thumbnail/icon (if desired) so users can easily jump to their History List if the most recent N number of reports in the Recent section doesn't meet their needs.

5. If users are able to modify their My Page layout, an Administrator should be able to reset it to a "default" layout at any time within a project for all users.  Currently, an Administrator can upload a new/default My Page template but users can decide whether or not to import it.  In a controlled environment such as ours, we need the ability to upload and force the import.

6. Changes made for MyPage on web server 1 must propagate quickly to all others in a web server cluster - there are situations where this seems to not be happening.

In desktop if you download a Dashboard from the Dashboard Gallery or even from an internal source in your organization and you don't have all the visualization plugins that were used to build the dashboard you get an error like the following:  "[The following custom visualization plug-in is missing and will be displayed as a grid: D3Calendar.]"

This is confusing for end users.   I propose 2 possible solutions:

  1. When Saving a Dashboard with a custom Visualization Plugin used ask if the viz plugin should be saved (embedded) in the dashboard.
    • A new user opening the dashboard should be given the option to import the plugin or not when opening (maybe with a security warning about unknown plugins etc).
  2. Online Download, same idea as above but without storing the viz in the mstr file. When opening the dashboard with a custom viz, the user should be prompted (given option to download the viz used).  This would require a metadata tag added to the Viz plugins with a download "source".  (Security Warning should definitely apply since the download could be from anywhere or the link highjacked).

Personally, I prefer the first solution, but I do understand that could require a bit of effort depending on how a MSTR file is structured.

Some logs in MIcroStrategy do contain a converted timestamp, like the MAEntMgr.xml, see below:

log4j:event logger="MAEntMgr" timestamp="1475702496941"

For investigation purposes it would be better to have a similar timestamp like in the DSSErrors.log available.

 

There is a lack of options when dealing with columns in a grid or dashboard compared to other BI tools. We keep hitting into these walls when users ask us if we can replicate reports that they have built.  I feel if we had the items below, we would not only meet the criteria but go beyond it.

 

These abilities are:

  1. Ability to assign an attribute placed in a column to only specific metrics.  Right now, if you put an attribute on a column, it applies it to every single metric.
  2. Ability to collapse/expand attributes in a column (outline mode for columns).  
  3. Ability to set a template of columns and set a sort of page-by to the template, but display the results side by side, rathern than just single page views as it is now.
  4. Similar to #1, but the ability to use a attribute Hierarchy on a metric.

 

From example A below, you can see that the attribute Region and Store apply only split out the Unit metric (#1). Stores can collapse into Region (#2).  And there is a template that goes Dealership > Units, Budget, Variance, which is then repeated based on Region (#3).  

In example B, you can see a hierarchy version with Date.  Notice, I only apply this to certain metrics that I choose.

 

The idea of applying an attribute to a single metric (or multiple) is the most important.  Maybe I want a YTD Budget like in the examples below, or maybe it's completely different.  Such as, I have a use case where I want to show a metric Date of Oldest Ticket, and I have a metric with # of Tickets and I want to add the Category attribute but only apply the Category attribute to # of Tickets.  Right now, the only way to do this is to stack multiple grids next to each other and fake it, but you have to hope that grids line up right, and you most certainly can't have any report where the column number is a variable.  Or the other way is you make a metric for every single element, which means extra overhead in filters and metrics.  Make life so much easier if you could do this in a single grid using a single metric with a single attribute.  

 

There are a ton of different use cases and I'm only scratching the surface, but here are two that highlight the items above.

 

Example A (Template example, #1, #2, #3, #4)

grid_collapse.gifgrid_expand.gif

 

Example B (Attribute Hierarchy Collapse, #1, #2, #4)

Grid_collapseB.gifgrid_expandB.gif

Currently when using Salesforce if tables used reserved words they will fail until an additional configuration step is taken using the keywordconflictsuffix setting as seen in the below tech note.

https://community.microstrategy.com/t5/Miscellaneous/TN44651-How-to-query-keyword-objects-in-Salesforce-com-with-the/ta-p/194397

This should be configured automatically either for DSNs created through the connectivity wizard or as the default setting for the ODBC driver.

Full support for Linux only MicroStrategy Systems

As an OEM it is critical that we have access to all the functionality available from Windows environments supported in Linux environments. Our cloud deployments are heavily Linux-based, the cost of having to have additional Windows VM's for each of our tenants just to handle a small number of support and maintenance tasks can be costly since Windows has a higher OS cost on top of the costs related to a limited use VM running 24/7.

We were told that replacing MicroStrategy Developer with a platform neutral or fully web-based version was on the roadmap. To date that has not materialized.

We need to have the following applications to be fully supported from Linux, ultimately we would like to have no reason to every look at a Windows machine, but these are our immediate needs and I would assume that same for your other customers, partners, and OEMs.

  • Command Manager
  • Object Manager
  • Project Merge
  • Project Duplicate
  • System Manager

 

Currently we use document with geo prompt in mobile.

Our actual scanario is to run the document in somewhere and get the geo infor. 

Later the user with ipad would move to the next place and do the same thing. 

currently we need to manually tap on current geo info and apply to document. 

Then after moving, we need to manually clear the cache. And do the same again.

We hope that it can be supported to allow document with geo prompt to automatically read current geo info and apply to document. And user don't need to manully clear cache any more.

 

Forgot Password Option

Status: New
by Senior Guru Senior Guru Thursday

Provide Forgot Password option for users in Web, Mobile & Desktop/Developer

I feel this as the key business use case in current world of accessing the applications.

It should be supported with authentication modes that MSTR has it now.. Standard , LDAP, Windows , etc.

https://community.microstrategy.com/t5/Platform-Installation-Deployment/Forgot-Password-option-for-the-User/td-p/49734

Enable Prompts for Desktop

Status: New
by dtobaben Pioneer 3 weeks ago - last edited 3 weeks ago

Hi,

 

we have many reports which require an answer for a prompt, where we cannot define a default selection.

 

 Desktop_Prompts.PNG

Please enable us to answer prompts within MicroStrategy Desktop. With this option we can simply use existing reports instead of building new ones for every usecase.

 

Kind regards

Attachment

Emulator for mobile

Status: New
by ccostache Active Seeker on ‎12-06-2016 11:51 AM

It would be great to have an emulator, or a way to test the documents and VIs to know how they would be displayed on different devices that you can pick from a drop down., say iPad etc.

This would be a great way to test this without having an actual device connected, especially when you don't have all expected devices.

Current situation:

 

a) We can only change the prompt answer via Command Manager for Subscriptions.

b) The manual change of the default prompt answer in the prompt would apply to reports as well, if those reports are saved as prompted.

Example:


1.Create a value prompt and choose the numeric prompt. Set default Answer to 2014
2. Create a Report with Year and Revenue and make Year a simple prompt with the prompt defined above.
3. Running this report with no changes takes 2014 as default answer.

 

Requirement:

Possibility to change the default answer (default value) with Command Manager. So, next time when the report is run by a user, there should be for example 2015 as default date.

The reason behind:

  1. To give the users the latest data by just running the report (without changing the prompt value)
  2. To automate the setting of the default value. So on 1th of January the default value will change automatically.  This example is just to explain the logic, but it would work similar for reports in which the changes of dates are more frequent and in a more complex manner.

 

In Visual insight, the current refresh button refreshes the datasets against the cache. We would like there to be a button that refreshes all datasets against the data warehouse. The workarounds for this at this time are to turn off caching at the project level and rerun the datasets individually. However, we would like to maintain caching for our projects, and re-running all datasets is extremely time consuming

This button would allow us to keep the datasets up to date with what is in the warehouse with greater ease. It would be much easier than re-running all of the datasets individually, and caching can remain enabled on the project level.

There is requirement from business users to be able to launch VI dashboard on the big monitor in presentation mode and automatically switch between sheets and panels after defined time interval.

There is already parameter for automatic refresh in Presentation mode so would be good to have additional checkbox and text box for time interval in seconds.

Capture.PNG

In our company we don't have a MSTR project dedicated to Human Resources, and it would be really useful. Anyway, the problem would be that in this project we should have also data about salaries of all the company employees. We know that there are user filters, security filters etc., but the problem is that even MSTR Administrator shouldn't see those salaries data.

It would be wonderful if MSTR Team would find a way to store data into a project, with the limit that Administrator can't absolutely see those data.

(Already checked with MSTR Support that this is not currently possible.)

Complex documents or dashboards may allocate a lot of memory on the Intelligence Server side e.g. when datasets are joined. This may lead to a crash of the Intelligence Server but due to the crash the culprit object cannot be identify from statistics.

Therefore, in order to identify such documents it would be good to add the object ID of the document to the individual contract manager requests, e.g.:

switch from

yyyy-mm-dd hh:mm:dd.ms+01:00 [HOST:My_Server][PID:2541][THR:249845504][Kernel][Info] Contract Request Succeeded: Source=join, Handle=47817, Size=1588834304, ContractedTotal=2251055104, AvailableTotal=47419921204

to

yyyy-mm-dd hh:mm:dd.ms+01:00 [HOST:My_Server][PID:2541][THR:249845504][Kernel][Info] Contract Request Succeeded: ObjectID=xxxxxxxxxxxxxxx, Source=join, Handle=47817, Size=1588834304, ContractedTotal=2251055104, AvailableTotal=47419921204

At the moment it is not possible to add to a report created from an intelligent cube an Hierarchy expression prompt (this is explained here in this TN).

Since this is an old defect, since it is very frequent to have an hierarchy prompt into a report, and since the proposed workaround is a little bit tough, please resolve this as soon as possible!

Datamart to AWS S3

Status: New
by MarkW Pioneer 3 weeks ago

Be able to create a data mart report in MicroStrategy that will export the data into AWS S3.

When the sub-totals are enabled in the grid, only the Total cell is highlighted. We'd like to have the possibility to control the background color of the total rows. This will increase the readability of the values and provide structure to the grid.

Totals.jpg

 

 

 

Control the prompt details in VI Dashboards as in documents

Status: New
by ccostache Active Seeker ‎12-06-2016 11:43 AM - edited ‎12-06-2016 11:43 AM

EVen if it's not straightforward, you can display the prompt details in a VI text container, but you cannot control which details of that prompt to display, as you can do it in the documents.

 

PromptGraph.jpg

 

 

 

 

Control the color of the visualization separators to have a seamless dashboard

Status: New
by ccostache Active Seeker ‎12-06-2016 10:36 AM - edited ‎12-06-2016 10:38 AM

If you have a look on the Travel_Sights example on the Microstrategy desktop, you will notice that the visualization separators are set to white so they are not visible. This gives a seamless flow of information without seeing those separators.

 

 

 Example.jpg

 

If you switch between the dark and light themes, that color goes back to original grey value and yopu no longer can control it.

 

 

 Example2.jpg

 

We don't know how this was managed for desktop, but this would be a great feature, as the visual experience is so much better f you can control the color of these separators so you can "hide" them.

 

View filter for VI visualizations

Status: New
by ccostache Active Seeker on ‎12-06-2016 11:05 AM

The view filter functionality at document level si really useful and it would be great to also have it at VI level. It should be available for all visualziation types.

Prompt users to save a document before exiting

Status: New
by Montreets Pioneer 2 weeks ago - last edited 2 weeks ago

When users navigate out of a document, they should be prompted to save changes.  In cases where I either accidentally hit a link or do something that navigates me out of the page AND I have pending changes needed to be saved, it would be great if the application would alert me before I go.

It looks like the functionality was added to VI Dashboards.  It would be nice to have the exact solution for Report Services Documents.

save changes.png

In a grid report containing a filter, an attribute and multiple metrics it is desired to drill to a template from any of the numbers in the grid. When drilling, the user expects to see the single records behind the aggregated values in the base report.

template drill.png

So in the example provided above, the user would want to see the two records in the target report. Unfortunately, the metric filter is ignored and the six records from the metric without filter are presented. This is because only the filters contained in the base report are passed when drilling. The filters that are used in metrics are ignored.

As it is expected to obtain exactly the data behind the aggregated values, it would be great to include this functionality.

 

 

 

In a Web document containing a grid report with drill-to-template functionality, all the attributes that are used in selectors in the document are passed to the page-by section of the target report (the one defined in the drill-to-template).

Unfortunately there is no option for all values in the page-by section, so the users can't access the entire data set at a single glance. Also, when attributes that are used in the selectors are present in the template, they are removed from the grid and added to the page-by section.

Ideally there would be a checkbox or something similar in the drill properties of the document to enable or disable this functionality.

 

 

Nowadays there is no easy solution to have one version of the truth and not having one super big project. It is common that there are multiple projects and in many projects there are certain objects, that are the same - attributes, metrics, hierarchies.. the problem is that one must maintain all the schema objects across multiple projects and that is far from ideal. My idea is simple:

To have one (core) schema definition or its part (especially useful for hierarchies) that could be inherited/shared to multiple projects (or linked) - readonly - so in other projects it would not be necessary not only to create it again but also there would be automatic propagation of changes from the original project. 

This would greatly improve ability to have single version of truth, it would also significantly decerease developer maintenance resources.

shareSchemaObj.PNG

It is possible to utilize the "Us as Filter" option in a VI Dashboard to be able to drill from one visualization to another within one sheet as shown below

community.PNG

It is highly desirable to be able to utilize the option to drill from one panel to another panel. For example, if the grid in the above image was on panel 2 inside sheet 1 and New York was clicked, the grid would filter just as it does if both visualizations were on the same panel.

I am struggling with this use case for a while now and finally did come to a solution with Web SDK. Nevertheless as this is a common use case from my perspective and I am not a big fan of customizing -> Please let´s consider including this functionality in our product. The use case is very intuitive but not easy to be named. It´s all about the possibility to use selectors not only as filters on a dashboard but to let them also influence which dimension shall be shown for a filter selection in all affected reporting components. Right now it is very difficult to use hierarchy components in a filter an in parallel on the dashboard screen because this setup does now provide meaningless selector combinations.

 

 

Scenario:

We have a product hierarchy with multiple levels (in case of tutorial data its Category, Sub Category and Item). The controlling user wants to create a dashboard where he does display the product information versus his targets in a graph. Next to the graph there are respective selectors containing the different levels of the hierarchy.

 

As we are starting on the highest level and want to drill into our data the user does start with an All Selection on all levels of the hierarchy.  Therefore he wants to display level one of the hierarchy in the graphs. If I do select now a category within the first level selector the graph will only show this one node in an ugly graph without any additional information.

 

An intuitive behavior the user would expect is that the graph adopts the selection of the selector and does show the next level node in the hierarchy automatically. If we select a single category the graph will show the respective sub-categories. If we select a  single sub-category the graph will show the respective items. If I go back to All Selections also the level in the grid/graph shall go back up. Find a video of this scenario attached

  1. With the attribute selector visible to demonstrate the use case
  2. With the attribute selector hidden in the background so that the user isn´t event aware that he does change is perspective.


This is an intuitive way of navigation that I did see as requirement at many customers. My current customer marked this feature as show stopper for a go-live. 

Technical Approach:

Since Version 10.3 we are offering the so called Attribute selector. This feature allows us to change the attribute that will be shown in a grid /graph with just one click on a selector. That was the first important piece in the puzzle for our solution in SDK.

The idea is to connect regular filter selectors with the attribute selector to define the level of the hierarchy that will be shown in the graph. Maybe we can find a more elegant way in the regular product. Probably this can also be combined with the new hierarchy browsing approach in Microstrategy.

Summary: From my perspective this will be a very intuitive enhancement of our product in sense of usability and as I did face this request at multiple customers it seems like this is not a special use case for single customer needs.

What do you think?

Status: Acknowledged
Is there was a way to set report-specific export headers/footers per report at the project level? Right now, we have a way/can set up the excel export headers/footers but it will be applied to all the reports but our need is to apply only to a specific report. Please refer to the ticket number - 133463. Based on the discussion with technical support person, it is not possible right now, so the support person advised us to post a the requirement as a new idea. Please let us know if you have any question. Thanks

At this moment a threshold on a metric cannot be applied on the cross-tabulation null values. It should be useful to add the option to apply thresholds also on this type of nulls.