Working on a customer with a high concurrency project, we have reached limit of 64GB on the working set cache.
Users are very active and run very large documents, so during peak hours they reach limit on working set. Then Intelligence server start writing to the tmppool folder and all system slows down and impact users.
System has plenty of memory available, only using 40%.
I would like to request this value could be set to a bigger number. Administrator should be able to set a value on MB or as % of system memory using the Intelligence Server configuration panel.
Thanks, Jose Antonio
It would be great if we could export to PDF the value from a Transaction Services Toggle control Style.
As of today, we see only an ugly Textfield with the value in it.
It would be great if in the PDF export we would see the image that is shown in Web.
Provide full D3 Functionality also on Android Devices / In general keep the API synchronous on all devicesStatus: New
since version 10.6 the Microstrategy API for D3 Graphs is from my perspective close to stable and can be used in productive environments for Web and Mobile iOS Devices. Nevertheless if I look into the current API support table it seems like that in the whole D3 topic Android is not covered at all.
By the way what i miss in in this table is the custom properties API.
For my customer who is following a bring your own device to the company approach it is hard to explain why this great feature of including D3 graphs is only available on iOS but not on Android.
Therefore I want to request that the D3 capabilities are available 1:1 in Android as they are in iOS right now. In generall all enhancements of the D3 API shall be available on all Devices (Web, Mobile iOS, Mobile Android and PDF Export) for Visual Insight and Report Service Document.
What do you think?
I would like to propose adding the ability to choose intelligent cubes as a source from any project, as long as you have access to those objects. You already have security groups that can be shared across projects since they are at the server level. And an intelligent cube exists in memory so it's not like the project needs to import all the schema. With the way projects are, you have to choose between stand alone projects that have absolutely no communication between them, or one project at the microstrategy level with individual folders as 'projects'. While the later allows you to create reports that can use both 'project' data sets, it also means it gets harder to add things or make changes to it as it starts to grow and become complicated. However, if we could select intelligent cubes from other projects, this would go a long way to being able to bridge that gap.
It often happens to me that i have to create the same threshold on all the metrics of one grid (from Developer). Then, i have to create the threshold for the first time on one metric, and then copy and paste it on the others. The option 'All metrics' here would speed a lot my work:
Don't you agree with me?
This would apply also to Web dashboards or documents.
Enable automatic recognition in Esri maps of a geographical attribute form even when it is not a display form.Status: New
If you have an attribute with a geo form that is neither set as display, nor browse form, this is not recognized as such when using it with the Esri map widget, with the result that you will not see the shapes for this attribute.
Present design force you to enable the form manually. As end-users should be able to drag and drop any objects from a cube onto a grid and change the visualization to Esri maps, they will be facing the counter-intuitive need to add additionally an attribute form of the geo attribute for display, which on purpose is not used because it does not bring any meaningful insight to the users and is just confusing.
Some attribute forms are artificial keys. We use them to link the data warehouse with the Esri database. Therefore we don’t need or even want this attribute form on the grid, but we expect that the plugin recognizes the attribute form and retrieves the shapes from the Esri-server.
As the attribute is recognized as a geographical attribute, the tool should be able to display the shapes automatically even if the form is not a display form.
Provide Custom Groups within iCubes to allow fast reporting on Custom Structures not available in the WarehouseStatus: New
I did meet the following requirement for several times now at my customers. Even if the best practice is to implement complex structures in the backend it might be that for a certain time period the busines wants to report on complex strcutures that are not yet available in the warehouse.
Sample Use Case: Provide a flattend Profit and Loss Structure based on an 12 Level Account Hierarch in Combintion with Busines Functions.
This use case can only be achieved by building it within Custom Groups in Microstrategy. As these structures might become quite complex the runtime to the database is quite long and analysis in Visual Insight just does not work this way.
Therefore I request to include custom groups in iCubes. What do you think?
Since i use every day Support Site (i’m talking about the new one, which is https://mymicrostrategy.force.com/support/ ), I post here some improvements that should ease and speed technical assistance experience.
Details about Case Management:
- Add the possibility to add someone in email cc to a case;
- When I open a case from this site, but then I answer by mail adding some there attachments, please save automatically those mail attachments together with online attachments;
- Add tags to the case. This would ease the search among all cases;
- Add the name of the Case Owner that is following you into a new column into Case Summary;
Preferences and Configuration:
- Add the possibility to save Visualization preferences; e.g. if I prefer to see Case Summary details with this order:
And not with the default one, I would like to save it somewhere and visualize it as default when I acces to Support site;
- (LAST BUT NOT LEAST) Add a section where I can save Internal MicroStrategy Configurations; this is fundamental since they are almost always required from Support after a case is opened. With such a section you wouldn’t have to report those configuration every time Support need them (and, yes, it is extremely frustrating to repeat them every time).
I’m talking about: MSTR version with Hotfix ; O.S.; IIS version; MSTR Desktop version; type and version of database; eventual upgrade planning; etc.
Obviously please report me if something of these features have already been implemented or are going to be implemented.
Currently in Intelligent Cube, if there is any structural change like adding a new attribute etc, we need to full refresh the cube to take the change into effect.
In would be really great if there is a functionality, where there is no need of full refreshing the cube if there is no need of back-fill of new attribute values. So for new incremental refresh the new attribute will publish data, but for old data, this new attribute will show blank values.
It will save a lot of time when the cubes are of large sizes.
It would be great to be able to see the description of Attributes and Metrics directly from the Visual Insight Screen :
When using the Data Retrieval Parameters VLDB settings to leverage Teradata's TPT API, the DSN name for TD_TDP_ID must be hardcoded. Because this utility utilizes an ODBC connection in conjunction with the TPT API, this may cause a report to improperly run against two different DSNs. Hardcoding a DSN also makes migrations into a production environment more difficult and risky.
Also, the Data Retrieval Parameter for TD_QUERY_BAND_SESS_INFO (which is a query band for the TPT session) does not accept Microstrategy wildcards like a regular report query band. This makes it very difficult to have meaningful query bands for TPT sessions since all of the values must be hardcoded, and you cannot include parameters such as Job ID.
This enhancement is requesting that the TD_TDP_ID be called with a parameter pulled from a database instance or ODBC connection in order to prevent hardcoding of a DSN name. Additionally, that TD_QUERY_BAND_SESS_INFO be allowed to accept Microstrategy wildcards..
Currently it is not possible to get rid of the "All" option for filters used in the Visual Insight (VI) Filter Panel (see Screenshot beyond):
This works perfect in many situations. However there are requests to remove the all option for specific filters within the VI filter panel. An option "Show option for all" like we do have it within a "normal" filter (see screenshot beyond) would be very helpfull also for the filters within the filter panel.
Please provide that option.
Thx and best regards,
Excel and mstr-Files (not connected) are quite similiar: both have data and you don't know if the data is still valide. The advantage of mstr-Files could be an expiry date which tells you that the data is no longer valid. So when a user opens the mstr-File in MicroStrategy Desktop, he'll get the message.
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.
I need the ability to search for users based on an LDAP DN, Trusted User ID, and/or NTSID values. This should be available using the various front ends as well as through the SDK.
Business case: When managing users through any of these login mechanisms it aids in the creation of automated systems to managed users on these values and also aids in maintenance and troubleshooting issues.
Although this information can be retrieved from the DSSMDUSRACCT table, it does not solve all of my use cases and is not a preferred/optimal approach. This type of request should be available via the SDK.
TN 249512 explains how to change the icon that shows in the browser tab or in the bookmarks. However, this small cosmetic change requires to change multiple page templates separately, requiring several copies of files and related files. This is way too complex and should be simplified.
In the same lines as there should be a straight forward configuration setting to change the logo displayed, there should be a simple configuration setting to change the favicon.
Support confirmed me that, when i change something in the dataset of a dashboard (or a document), then the dashboard doesn't feel this change in any way.
I make an example to be more clear. I've created a dashboard based on a grid, and this grid contains 9 metrics. After the dashboard creation, i had to add a threshold on those 9 metrics, and i did it from Developer. Then, since i would have liked to see this threshold also into my dashboard, from Web i tried to regenerate (and after re-run) my dashboard, but nothing happened. Also replacing this dataset with itself didn't work.
So please find a way to make dashboards and datasets communicating with each other, so that when there is a change in the dataset, dashboard feels it.
I know that there is the ability to create links in text boxes and Image Boxes as well as dynamic links on attributes. What I am proposing are links on things like Title bars: this would allow you to create a VI dashboard and the ability to go to a detail report. each panel could link to a different detail report. What is causing me to ask for this...I wanted to use the KPI Widget which is a single metric. that is great but if I want to see the detail behind that sinle number...you cannot. so I thought I can do this with a grid report and a single metric no attributes but alas I cannot get a link there either. if I could create a link on a title bar this would alleviate the issue. maybe a link in a metrric Name? Metric Column Header?
If this can already be done and I am missing something...I apologizew, please enlghten me :-)
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.
In the Data Science community, Python is also a very powerful tool for predictive
modeling. Especially, jupyter notebook is a very popular alternative to R. (http://jupyter.org/)
In recent symposium I was approached by customers who asked whether Python and Mstr can be integrated.
Currently, it is not the case.
As Jupyter Notebook is a web application, and JSON API allows Mstr to fetch report
data from IServer. It should not be too far away to combine both components into one visualization object.
The proposal is to have a visualization, which
* one can drag a "Python-Visualization" into a Dashboard
* the visualization loads a Jupyter web application as if it is a portlet (the notebook should be a parameter)
* the visualization also takes care of Mstr authentication and loading one or more datasets into the Jupyter environment as json objects or as panda dataframes (dataset is another parameter of the visualization)
* each time the dashboard is executed, all the cells of jupyter get excuted as well
* the last cell is shown as the content (specification of output might be another parameter as well)
Debugging Tools – provide the capability of allow Web Users to view the SQL generated by dashboards, and allow for a talk-to-user VI mode, i.e. while the dashboard is being executed show the user what’s going on, where messages are displayed on screen informing the user about the current process/stage of execution, and the user’s memory and CPU% consumption.
This is in order for users to better understand this tool, its best practice and limitation; provide guidance for do’s and don’ts of using VI; the limitations of VI; best practice for the different types of analyses and reports; and, the step-by-step guidance for sharing with one’s group/department, and separately, for sharing enterprise-wide the managed objects by promoting to become schema objects, etc.
In Developer, into Report editor and design mode, when we want to replace a filter with another filter, you can just do it by removing the old filter and inserting the new one into the report.
It would be much more easy to do it doing right click on the old filter and selecting 'Replace with...'; then you should just select the new filter from the Filter folder, and that's all.
This would ease and speed the report development process.
This is obviously applicable also to prompts.
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.
I could'n find a way to create a script ho will give me: All Reports of a Project, contain a VLDB with a specific Hint or with a Hint. Also need the same to change all the Report of a Project with specific VLDB specific Hint to anothe Hint or to the Default.
We have the option of hiding the messasge 'No data returned...' at project level.
I think it wiould be better to have this option overridden at report level.
For operational reports, its a good option to show that data has been returned. But if we have some dashboards with multiple grids, it shows no data returned (if not data exists for that grid). This will not be understood to the users. So I think it would be a better option to override at Report level.
We have several users who can access to MSTR objects through mobile.There is not many differences with these users except the user name. We want to set only one mobile configuration link and after user login on mobile, different users can have different home page documents. These users are in charge of different departments, for example, Marketing, HR and Finance. We want to have the users from the marketing team to get the marketing document as the home page document as well as the users from HR team to have the HR document as the home page document. So users from different departments have different home page.