Preview the new community

We’re making it easier for you to find answers and network with others. Visit our preview site and let us know what you think.

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
0 Likes

More options in search results

Status: Acknowledged
by Roberto926703 Seeker on ‎08-05-2016 09:05 AM

We suggest to have the possibility to work a report starting result search. I explain the step:

  1. Open Web.
  2. Use search option ( by clicking loupe icon in the top right-hand corner).
  3. Put some search criteria.
  4. At this point the only possible option is the report execution

We like to use more options, i.e. editing, sharing etc.

Status: Acknowledged

Hello all,

I would like to ask for an enhancement in Visual insight that is essential in the eyes of our internal business user:

If a custom group , that has been designed to create totals in its internal options, is used in a report which is the source of a dashboard, the following functions that work with attributes, do not work or are not offered for a custom group:

e.g. Table Visualization : Adding a total for the column with the CG is not offered - regardless of its settings inside its own options.

This behaviour - it's MicroStrategy 9.4.1 HF 7 - is completely different to the behaviour of CGs used in regular reports or report services documents. In order to avoid irritation for the users the total behaviour should be either consistent to those known from the other objects. Or it would be better not to offer the usage of CGs vor Visual Insight dashboards.

 

Kind regards

 

Beate Fischer

OBI Smart Technologies, Germany

Add an option to modify the Tooltip of Image Layout DHTML widget (SDK)

Status: More Information Needed
by Helper Kstepien Helper ‎08-31-2016 09:16 AM - edited ‎10-28-2016 03:11 PM

Currently the tooltip of Image Layout and its display depends on the formatting of Image Layout itself and the grid behind it.

This idea is about possibility to modify the display of the tooltip separately from the Image Layout.

For example:
a) If in the grid the metric does not display the "%" or currency, the tooltip will not do it.
b) The size of the font is not editable (in some cases it looks too big)
c) If the size of Image Layout is small, the tooltip dispaly is unclear (it breaks one word into two lines or one number into two lines).

Status: More Information Needed

Waiting for a little more details how this would visually look like both on the creation and consumption side and hoping to get more comments from the larger community.

Enable Hierarchy Prompt Search to filter results of all nodes including children nodes

Status: New
by Mark1475462 Pioneer ‎02-10-2015 05:00 PM - edited ‎02-10-2015 05:02 PM

When building a hierarchy prompt and enabling search, currently the search criteria only searches within the node you are on.

Given this structure: Primary node -> Secondary node -> Node X, etc

In order to locate an item within the secondary node or Node X, the user must click on each node and search there.

I would like the ability for the prompt search to traverse the tree and pull back all matches within every node. Additionally, the search should function as 'contains' not just 'begins with.'

For example: This is for users who may not know where a particular product falls within the hierarchy.

SOAP Web Services to support parsing attachments

Status: New
by MT Newcomer on ‎01-28-2016 05:00 PM

Our web services return large datasets as CSV attachments in the WSDL response. We would like XQuery to be able to parse data attachments.

Better Intelligent Cube View Filter Creator

Status: New
by Jon H Helper ‎12-22-2015 04:12 PM - edited ‎12-22-2015 04:52 PM

 One of the benefits of intelligent cubes is that you can store large datasets in memory so it's quick.  This leads to creating intelligent cubes with a lot of metrics.  The problem is that this causes the view filter editor to become almost unusuable.  The biggest gripe is for Developer, mainly because the list of metrics is not sorted in alphabetical order, what order it's in is beyond me.

 

You end up with a list like this; good luck finding your metric.

ViewFilterIC1.jpg

 

And what about linking to a prompt you've already created rather than building a new one?  It's at the very bottom of the list, which can only be scrolled through by hovering your mouse over the down arrow which is at the bottom of the box (which can get chopped off on certain display sizes), making navigating it slow (or really fast!  Sometimes you speed right past your metric so you have to go hover over the up arrow now).  You ask, is there a scroll bar?  No.  What about, can you use your mouse wheel in the box to scroll faster?  Of course not, that's too advanced.   Nope, just good ol mouse over.  The interactivity is very painful here.  It would also be helpful just to move the prompt link to the top.  It's not going to grow out of control because it's just one link.

ViewFilterIC2.jpg

 

Is the experience any better in Web? Ah look at that, you get it sorted alphabetically, awesome!  You get a scroll bar, awesome.  And your mouse wheel works, awesome!!  I'll just use Web exclusively... oh wait, I can't link to prompts I've already created using Web... back to Developer...

ViewFilterIC3.jpg

 

Please make the experience in Developer more like Web.  And for web, please add the ability to link to prompts.

 

Shout out to this idea:  http://community.microstrategy.com/t5/Idea-Exchange/Allow-to-assign-prompts-to-Intelligent-cube-reports-over-Web/idi-p/240269

Ability to create "complex" metrics on the fly (smart metrics) with no code (or easy code), business-users friendly.

 

"Complex" metrics (but key for users) should include:

- Filtered metrics: A metric filtered by another attribute or metric present on the dataset

- Transformation metrics: Typically a metric with time transformation (LY, YTD, LM..)

- Level metrics: A metric calculated to a specific attribute level

Based on a requirement, i have created three datasets based on three database sources inside a dashboard.

After building the datasets and linking them - i wanted to setup a refresh schedule for the newly created datasets (cubes ). To my surprise all i could see is 'Republish Cube' option and  no 'Schedule' option. I haven't created these datasets as Intelligent cubes first and they were build within a dashboard. I could see the three datasets as cubes residing in Iserver's memory, but couldn't find a way to schedule them.

On approaching Tech Support, they said there its not possible to schedule the Data Import cubes created within a VI Dashboard to be republished . They suggetsed to create the Data Import cubes as standalone objects and then schedule them.

After a day struggle, i was able to save the individual datasets or cubes to a specific folder and enable a timebased refresh schedule

To make the product very intuituve and consistent across the product -  scheduling of cubes should remain the same no matter where the cubes are created or how they are created.

 

Cube refresh

 

 

Sometimes we need to search for report or document names at the project level and then identify if the report/document has any dependent subscriptions.

What you need to do currently is
1. Search for the name of report/document at the project level.
2. Find the path of the report/document and browse to it
3. Then right-click on the object and select "Search for dependent subscriptions"

You cannot directly search for the subscriptions from the search window.

 

Below are the snapshots to explain the difference:

 

When you directly right click on the object:

Capture.PNG

When in the Search box (no option to search for subscriptions):

Capture1.PNG

 

It will be good to have an option to search for subscriptions while in search window as well.

Advanced VI Thresholds on graphs

Status: New
by Active Contributor Markus Active Contributor on ‎10-02-2015 07:58 AM

Hi All,

 

 

currently we can apply advanced thresholds to Visual Insight dashboards only to a grid.

Since VIs main strength is visualisations you should have the options to use advanced thresholds on a graph as well.

 

Regards,

 

Markus

Multi-select selector sortable by metric

Status: New
by Kenny.Wade Junior Contributor ‎08-05-2015 09:57 AM - edited ‎08-05-2015 09:59 AM

We have multiple business scenarios where a dashboard is requested with a high cardinality dimension included in the selector.  The dashboards we create are DHTML/Interactive Dashboards, and we have two options for the selector:

 

1. Grid as selector - this allows us to sort and present the high cardinality dimension via a metric, but does not provide the ability to multi-select

2. Traditional check-box selector - this allows us to multi-select the dimension, but with a large number of values in the selector and no ability to sort with any context, searching and selecting can become tedious.

 

Can we have a selector available in traditional document/dashboards (in other words not a VI-specific solution) that provides either of the following options?

 

  • multi-select selector and sort via a metric

OR

  • allow grids as selectors to multi-select

Add XML as a new data source for Data Import

Status: New
by Moderator on ‎06-30-2015 10:18 AM

I wanted to have XML file as a data source within data import. It would be great if MicroStrategy could take in an xml file that could be stored on the desktop or is provided over the web and parse into one or more tables as needed. 

 

Here is one such example. 

At the moment it is not possible to enable Dynamic Sourcing if the Cube or the report have a metric qualification.

Unfortunately this is very usual in most of the cases; in fact, it often happens that you have to create a metric with a condition inside of it.

Please make the metric qualification available for the Dynamic Sourcing!

Hi,

 

The feature sort metric hierarchically already exists for a standard report.

Adding this feature in VI will help to manage total behavior during sort.

 

Options to Enable sort buttons option is not working in presentation mode. Having sorting option for grid is always a good option, Currently its only enable in Editable mode.

We use MSTR Integrity Manager intensively for our Release Tests.

The steps we go through are the following:


1. Tests before the changes - Baseline 1 is being created

2. Changes (DB, MSTR etc.)

3. Tests after the changes – Baseline 2 is being created

4. Comparison Baseline 1 and Baseline 2

In the comparison we can see the differences between the two baselines but as an absolute number. It would be very helpful for us to see it as a percentage difference, because the value itself doesn’t tell us if it’s a lot or not (depending on the size of the report).

Because of this we need to do the comparison manually (in Excel) and as we have to do this for several different countries (we use a different user for every country, therefore also a different IM test), it takes a lot of time.

Security filters with Intelligent Cubes (pass through i.e. using an ApplyComparison) - Please Make this work

Status: New
by JJSKW Newcomer on ‎07-28-2016 11:36 AM - last edited on ‎11-14-2016 02:42 PM by Community Manager

Currently our security filter for external clients, which, was initially set up by Microstrategy at their suggestion solution/methodology for SSO pass through, uses a pass through filter based on a system user prompt and security filter table.

This makes combining user data with schema data for external clients unuasable. 

ApplyComparison("(#0 IN (SELECT {Attribute} FROM {Table} WHERE LoginID = #1))",{Attribute}@[{AttributeID}],? [User Login])

This was highly aniticipated and we really looked foward to combining user data and presenting to our external clients but, alas, this feature does not work.  Throws the Where 0 into the where clause and ultimately returns no data.

Would really like to see this feature in a near future release.

See our tech support case #129128

Hello,

It seems that all forms of attribute filters. Forms should be extracted and added.

Also sorting should be able to do.

Attachment

Ran into this today..  Something interesting..

Uploading a excel for cross tab but also wanted to create a new attribute...

 

1) have a cross tab xls that does not have numberic values in it.

2) now when you create the cross tab with external data there is always at least one metic created. Import always requires it with cross tab parse option.

3) Now what if that value is actually text attribute and not a metric?  Well you change it to text and change it to an attribute..  

4) Now I want to wrangle on that new attribute...  You cannot.... When you go to wrangle it reverts to metric again and the metric column is blank in the wrangling interface.

 

What I would like is to Parse and wrangle on any comlun that I had to change.  Or give a way to cross tab import data and have no metric so you can wrangle all columns.

 

The options available in the context menu for Visual Insight Dashboards in MicroStrategy 10.1.0 should have a separate "Run" and "Edit" option where "Run" opens the Dashboard in Presentation Mode and "Edit" opens the Dashboard in Visual Insight for editing. The "Edit" option should only be displayed for users who have access for editing dashboards. Additionally the default mode (Run or Edit) for "clicking" on a Dashboards should be available to configure.

Most of our users will have limited Edit capabiliities enabled - but most of the time they want to click on the Dashboard and view it without first having to be presented with the Visual Insight Editor. This was available or is still available for Documents and Reports just not for Dashboards.

Author of a modification

Status: New
by Celine1691099 Seeker on ‎03-14-2017 06:05 AM

On a object, we can see the owner, the creation date and the last modification date but we can't known who has done this modification.

It would be very helpfull when many people work on the same object (dashbord, metrics, attribut):

 

author of modification.png

0 Likes

Current behavior:

 


Since prompt is a feature on top of dataset, not document, if you have multiple prompted datasets in one document, you have to answer prompt for each of them.

 

Requirement:

 

To have a prompt on document level - being able to answer once for all datasets.

Workaround: 

If you create Prompt as a separate object and insert this object in some Reports, Document based on those Reports will ask about this one attribute only once.

Metric format order

Status: New
by Enrique Lopez Junior Contributor on ‎06-21-2016 04:06 PM

In versión 10.3 the metric format order is confusing for end users. They usually format the metric headers because they forget to change to metric values. In practice the most common metric formating is to its values. So it would be great if metric values is the default selection:

AS IS:

Capture.PNG

TO BE:

Capture.PNG

0 Likes

mstr license

Status: New
by dreddy44 Pioneer on ‎09-21-2015 07:07 AM

Hi all,

 

presently we are using 9.4.1v ,we want to upgrade from 9.4.1 to 10.

again we need to buy mstr license  or we can upgrade directly?

please let me know if any one knows.

 

thanks,

damodhar 

Metric values and scale

Status: New
by Adrian Nunez Seeker on ‎02-15-2016 12:41 PM

I have worked on a project dealing with financial reporting that was used across all levels of the organization: from Global to Local reporting. Security settings set up what level of information could be seen, and MicroStrategy standard functionality (security groups, hierarchies) was perfect for that.

However one feature was missing on metrics, and a workaround had to be implemented at quite an expense. The feature was the ability to change the scale of metrics dynamically on the report (or dashboard).

The business scenario is that a global level the financial figures will have a lot more digits than at a local level (millions, thousands or units). This applied both to the values of monetary and non-monetary metrics.

Feature requested: for metrics to have three small buttons (or two tiny arrows pointing left & right) to control the scale of the metric (millions, thousands or units), and for the metric name to indicate in brackets the scale used. These buttons will also be available to affect all the metrics at once (maybe under the "Metrics" label?) so the user can change the scale of all metrics at once or of each one individually.

The state of this selectors can be saved with personal copies of the report, and in history list.

This shall be available in reports, and documents as part of the standard interface.

Note: please note that this change of scale does not require a calculation necessarily, as it can be done with a formatting property of the number displayed.

Note 2: please note this functionality is different than choosing the number of digits shown on a metric, as:

  - that feature stops advancing when there aren't any more decimals to show.

  - that feature is not controlled on the metric itself, but it requires using the menu.

Workaround: a combination of prompts to choose metrics was used. Another option is to use a value prompts for a denominator taking values 1, 1000 or 1000000 to affect all metrics. The latter method does not make the scale being used apparent to the user of after the report has been exported/printed.

 

 

 

0 Likes

Reusable Document Header

Status: New
by Expert on ‎08-03-2015 08:28 AM

When you think about how many document dashboards most companies have, then you tell the developers to update the headers on every single one, it makes your head spin.

 

Now, you of course could use an iframe to create a 'header' document then view into that document, however if you have navigation, filters, etc. the only way to make that work is to 'Open in new window'.

 

So, it would be great if there were a feature (without SDK) where we could build a document dashboard then 'insert' it into multiple documents, but then MicroStrategy treats it as part of the document you are viewing. THis would be identical to iframes, except rather than the page you are viewing being a 'portal' it would essentially be a physical part of the document you are viewing.

This way, you can manage navigation and other common elements in one location but MicroStrategy Web treats them as if you built it directly in the dashboard you are viewing.

 

Think about the possibilities!

We have multiple incremental refresh and data refresh options for a cube like, Insert, Update, Delete, etc..

What INSERT option does is takes the new incoming data, compares it with the existing data in the cube and if the rows don't exist it adds them to the cube.

I understand it is designed that way so that data doesn't duplicate in the cube.

But sometimes it could be a problem as well.

 

I have worked on a lot of cubes for different customers and worked on optimizing them too. But most common sccenario we go through is to insert YESTERDAY's data into the cube. We do know that there will be a change in the date so there is no way any records exist in the cube for yesterday's date, so in this case we just want to fetch the new data and insert it into the cube BUT I-Server first compares all of the new rows if it already exists and then inserts them.

 

It would be really great to have an option of INSERT ONLY, so that no comparison is made to the existing data in the cube and data is added as is. This would certainly improve the performance of the incremental loads. Correct me if I am wrong.

Subscriptions to Sharepoint 365

Status: New
by Mohamed1386832 Newcomer on ‎09-01-2016 01:14 AM

We have a business requirement where the output from the subscriptions must be sent to Sharepoint 365. How can this be accomplished?

Issue: Graph is not showing the last month label on a graph.

 

ScreenShot.JPG

As seen in the graph below the x-axis doesn’t show ‘Jul 2015’ on the axis but data can be seen in the graph. The document runs in flash mode and property from document properties “Use optimal number of labels for category axis” is checked.

 

 

... because NOT everybody uses (likes) Apple and Google stuff ...