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:
- 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).
- 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:
- 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.
- Ability to collapse/expand attributes in a column (outline mode for columns).
- 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.
- 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)
Example B (Attribute Hierarchy Collapse, #1, #2, #4)
Support a Salesforce ODBC driver that automatically handles keyword objects without need for the keywordconflictsuffix setting.Status: New
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.
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
Geo prompt: allow to enable document to automatically read the current geo information and apply to document in MobileStatus: New
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.
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.
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.
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.
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.
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:
- To give the users the latest data by just running the report (without changing the prompt value)
- 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.
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.)
Add Object GUID to the Contract Requests in the DSSErrors.log in order to be able to identify objects allocating a lot of Memory during executionStatus: New
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.:
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
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!
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.
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.
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.
If you switch between the dark and light themes, that color goes back to original grey value and yopu no longer can control it.
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.
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.
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.
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.
Create an option for preventing selector attributes to be added to the page-by section when drilling to a template from a Web documentStatus: New
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.
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
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.
Provide filter sensitive attribute selectors to display automatically the right hierarchy level in a dashboard based on user selectionStatus: Acknowledged
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.
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
- With the attribute selector visible to demonstrate the use case
- 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.
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?