Skip to main content

Release notes

Arria for MicroStrategy

For help with any of the features or issues below, please contact our Support Team.

Version 3.4.4

September 2022

Note

Arria for MicroStrategy 3.4.2 and 3.4.3 were released internally only.

Fixed issue

  • Security updates

    This release includes essential security updates.

 

Top

Version 3.4.1

Arria Answers 1.3.0

21 August 2022

Arria Answers 1.3.0 is now available through Arria for MicroStrategy 3.4.1 and includes the changes described below.

New features and enhancements

  • New "overall" keyword

    When you include "overall" in your query, Arria Answers analyzes the whole dataset, no matter how you've set the default time filter. See Querying the whole dataset for guidance.

  • Exclusion filters

    You can now exclude non-time dimension instances from your query. For example:

    "What are my Sales excluding Germany?"

    "Tell me about Profit except for Retine and Glower."

    See Exclusion filters for guidance.

  • New single-period variance queries

    You can now ask how much a measure has changed over a single month, quarter, or year. For example:

    "How did my Sales change in June 2022?"

    See Single-period variance for guidance.

  • Changes to group-by queries

    • Group-by queries now work with four aggregation types: sum, average, maximum, and minimum.

    • Group-by queries with sum aggregation (e.g. What are my Sales by Country?) now return a list of aggregated totals in descending order.

    • You can now ask if the group-by values are similar or identical, or if there are outliers. You can also ask for a specific number of values — for example, the top three only. See Group-by queries for guidance.

 

Fixed issues

  • Handling of null values

    • Measures

      Null values in measures can affect the accuracy of calculations. Arria Answers now warns you when you query a measure that has one or more null values. For example:

      "In 2019, Sales were $43,580. Please note, your Sales column has some missing data."

    • Dimensions

      Null values in non-time dimensions (e.g. Country) are valid. Previously, Arria Answers returned an error when you queried a dimension that had one or more null values. Now, the null-value rows are removed from the analysis and a valid answer is returned.

       

    • Time dimensions

      Previously, Arria Answers generated an error when you queried a time dimension that had one or more null values. Now, the null-value rows are removed from the analysis and the answer includes a sentence alerting you to this. For example:

      "In February 2022, Sales were $5.03 million. I found some incorrectly formatted temporal data and removed those rows from my calculations."

  • Querying a time period with missing data

    Assume that your dataset has data for February and March but none for January. If you ask How are my Sales between January and March?, the answer now includes a sentence alerting you to the missing data. For example:

    "Between January 2022 and March 2022, Sales were $5.72 million. Not all months within the time period had data."

     

Known issues

  • Arria Answers may return multiple values for each dimension instance

    An average group-by query finds the average value for each instance of the dimension and returns a list of values. This works if you have selected one dimension (e.g. Country) for use with Arria Answers.  If you have selected multiple dimensions (e.g. Country and Product), you may get multiple average values for each instance.

    arria-answers-group-by-averages-multiple-dimensions.png

    In the example above, the answer doesn’t return a single value for each country. You get multiple values for Canada (one for each product), multiple values for France (one for each product), and so on. To avoid this, deselect every dimension other than the one you wish to group by.

    See Group-by queries for more information.

  • Day values are not working in cardinal form

    A time-point filter should work whether the day value is a cardinal number (e.g. 1 July 2022) or an ordinal number (e.g. 1st July 2022). Due to a bug, Arria Answers currently returns incorrect answers if you use cardinal numbers. Please use the ordinal form.

  • Confusing answers for group-by queries with max/min aggregation

    If your group-by query requests a specific number of top or bottom entries and the measure contains some identical max/min values, the number of entries returned may not match the number requested. For example:

    Query: "What are the top two for Max(Sales) by Country?"

    Answer: "Overall, the maximum 2 entries for Max(Sales) by Country are France ($20,000), Italy ($20,000) and Germany ($20,000)."

  • Apostrophes in queries may trigger the autocomplete list

    Typing a letter immediately after an apostrophe (e.g. the s in today's) may open the autocomplete list in error. Immediately selecting from the list (e.g. Sales) produces an invalid query. To avoid this, enter a space and continue typing your query.

    arria-answers-apostrophes-error.png

 

Top

Arria for MicroStrategy 3.4.1

4 July 2022

New features and enhancements

  • Additional support for MicroStrategy documents

    Arria for MicroStrategy is now supported in documents in MicroStrategy Library Mobile for iOS.

Notable changes

  • NLG Apps: Rounding of large currency values

    To mitigate the rounding issue noted in the 3.4.0 release notes, NLG apps now display large currency values rounded to two decimal places. Occasionally, the display formatting and half-up rounding may still create the impression of a calculation error, but any apparent discrepancy is much smaller. For example:

    Arria for MicroStrategy 3.4.1

    Previous versions of Arria for MicroStrategy

    "Sales rose by $2.16M from $2.67M to $4.82M between Mar 2022 and Apr 2022."

    (Apparent discrepancy: $0.01M)

    "Sales rose by $2.2M from $2.7M to $4.8M between Mar 2022 and Apr 2022."

    (Apparent discrepancy: $0.1M)

Fixed issues

  • Blank visualization in MicroStrategy dossiers

    When used in dossiers in the following products, Arria for MicroStrategy 3.4.0 appeared blank instead of displaying the narrative text:

    • MicroStrategy Library Mobile for iOS

    • MicroStrategy Library for macOS in the Safari browser

    This release fixes the issue.

 

  • Arria Answers: Suggested queries are now displayed on MicroStrategy Workstation

    Arria Answers now generates suggested queries when using the Arria custom visualization on MicroStrategy Workstation.

Known issues

  • Blank visualization in MicroStrategy documents

    When used in documents in the following products, Arria for MicroStrategy appears blank instead of displaying the narrative text:

    • MicroStrategy Library Mobile for Android

    • MicroStrategy Workstation for macOS

 

Top

Version 3.4.0

22 May 2022

New features and enhancements

Known issues

  • NLG Apps: Rounding error

    At the data analysis level, NLG apps work with the actual values in your data. At the narrative level, however, the apps display large currency values in rounded form. This is done to improve readability, but occasionally it creates the false appearance of a calculation error.

    For example, if the March Sales value is $2,666,503 and the April Sales value is $4,821,627.50, an NLG app correctly calculates (from the raw data) a variance value of $2,155,124.50.  The app might report this insight as:

    "Sales rose by $2.2M from $2.7M to $4.8M between Mar 2022 and Apr 2022."

    This statement appears inaccurate because the difference between $2.7M and $4.8M is $2.1M, not $2.2M. The app has calculated correctly; the reported result appears inaccurate only because rounding was applied to all three values for display purposes AFTER data analysis was complete.

 

  • Arria Answers: No suggested queries on MicroStrategy Workstation

    Arria Answers does not generate suggested queries when using the Arria custom visualization on MicroStrategy Workstation.

 

Top

Version 3.3.0

March 2022

New features and enhancements

  • Custom Narratives: Support for additional Parameter Control fields

    Previously, Arria for MicroStrategy limited users to a maximum of three Parameter Control fields. This limit no longer applies.

    qlik-arria-unlimited-parameter-controls.png

  • About Arria for MicroStrategy dialog box

    You can now access an About dialog box from the Arria for MicroStrategy context menu. The dialog box displays detailed version information, which is valuable when reporting issues to our support team.

    qlik-arria-about-dialog-menu.png
    microstrategy-arria-about-dialog-ms.png
  • Arria Answers: Support for single date fields

    Arria Answers can now handle date values stored in a single column, as shown below. Spreading date components (year, quarter, month, and day) across multiple columns is no longer required.

    arria-date-columns.png
  • Arria Answers: Two-digit year values

    In addition to four-digit year values (e.g. 2022), two-digit year values (e.g. 22) are now supported.

 

  • Arria Answers: Support for additional aggregation types

    Arria Answers now supports four aggregation types: Sum, Average, Minimum, and Maximum. Previously, it supported Sum aggregation only. This improvement increases your options for querying your data — see Query types for guidance.

Fixed issues

  • Arria Answers: Aliases can now start with the name of another field in the dataset

    Arria Answers now correctly handles fields with an alias that starts with the name of another field in the dataset. For example, if your dataset includes both a Date field and a Sales field, you can give the Date field the alias SalesDate.

Known issues

  • Arria for MicroStrategy 3.3.0 must be installed before existing Arria visualizations are reconfigured

    As part of the Arria for MicroStrategy 3.3.0 update, we have made changes to both the Arria for MicroStrategy custom visualization and the live back-end services it uses.

    Due to the back-end changes, trying to reconfigure an existing narrative or Arria Answers visualization before installing Arria for MicroStrategy 3.3.0 results in the visualization freezing.

    microstrategy-arria-upgrade-issue-1.png
    microstrategy-arria-upgrade-issue-2.png

    To resolve this issue, install Arria for MicroStrategy 3.3.0, then close and reopen your dossier.

 

  • Arria Answers: Empty cells (null values) in dimension fields result in error messages and no suggested queries

    If a non-time dimension field in your dataset — e.g. Country or Product — contains empty cells (null values), Arria Answers returns this error message:

    I'm sorry, something went wrong. Please try again or ask for help.

    If a time dimension field in your dataset — e.g. Date or Year — contains empty cells (null values), no suggested queries are generated and Arria Answers returns this error message:

    I'm sorry, I can't understand your date column format. Please use an ISO-8601 format and try again.

    To avoid these issues, please ensure that your dimension fields contain no empty cells.

 

Top

Version 3.2.1

November 2021

Fixed issues

  • NLG Apps: Reordering measures in Correlations App using drag and drop

    We have fixed an issue with using drag and drop to reorder the primary and secondary measures in the Correlations app.

    Measures can now be dragged from one field to the other when the target field is empty, as shown below.

    microstrategy-arria-primary-secondary-measures.png
  • Custom narratives: Year dropped from fields containing month-year values

    Previously, Month attributes created from date fields, and other attributes containing month-year values, were incorrectly handled by Custom Narratives: only the month part of the value was passed to the Studio project. For example, Jan-2021 was passed as Jan. This has been fixed.

 

Top

Version 3.2.0

November 2021

New features and enhancements

  • New NLG Apps

    Arria for MicroStrategy 3.2.0 introduces two new out-of-the-box narrative types:

    • The Anomalies app generates a narrative that detects and contextualizes anomalies in one or more measures — at a single time point or across a time range — broken down by a number of dimensions. For example, the narrative may report unexpectedly high or low sales for a certain month when compared to all other months in the dataset.

      See Anomalies for details.

    • The Correlations app generates an analysis of correlations between measures — at a single time point or across a time range — broken down by a number of dimensions. For example, for a particular product, the narrative may report a strong positive correlation between marketing spend and an increase in profit two months later.

      See Correlations for details.

  • MicroStrategy Workstation for macOS and MicroStrategy Library Mobile for iOS are now supported

    Arria for MicroStrategy is now supported in the following products:

    • MicroStrategy Library Mobile for iOS (dossiers only)

    • MicroStrategy Workstation for macOS

Known issues

  • NLG Apps: Can't drag and drop when configuring measures for Correlations App

    During data configuration, you cannot reorder the primary and secondary measures using drag and drop.

    Instead, remove both the primary and secondary measures and re-add them in the desired order.

    microstrategy-arria-primary-secondary-measures.gif
  • NLG Apps: Arria custom visualization not refreshed when dataset is replaced

    Replacing a dataset that is currently being used by the Arria custom visualization is not supported. To generate a narrative using new data, remove and re-add the visualization before reconfiguring the narrative.

    microstrategy-arria-replace-dataset.png
  • NLG Apps: Empty rows in dataset may result in an error or empty narrative

    Empty rows may result in an empty narrative (as shown below) or an error message. To resolve these issues, check for empty rows and exclude them from your dataset.

    microstrategy-arria-null-values.png

 

Top

Version 3.1.0

August 2021

New features and enhancements

  • NLG Apps: Support for additional aggregation and entity types

    Arria for MicroStrategy 3.1 introduces NLG Apps support for measures aggregated by Average, Minimum, Maximum, and Count, and precalculated measures such as percentages, ratings, and ratios.

    See Support for additional aggregation and entity types for further information.

    Important

    Arria Answers currently supports only the Sum aggregation type and the None and Currency entity types. When switching from an NLG Apps narrative to Arria Answers, make sure the measures chosen to generate the narrative meet these requirements. If they don't, Arria Answers will return incorrect responses.

 

  • NLG Apps: Support for date fields and non-standard date field names

    Previous versions of NLG Apps supported only the following date hierarchy components: year, quarter, month, and day. Fields containing these date components were required to be named Year, Quarter, Month, or Day, respectively.

    Arria for MicroStrategy 3.1 introduces NLG Apps support for date fields and for a wider range of recognized field names.

    See the Time dimensions section of the NLG Apps Data requirements topic for details.

Fixed issues

  • NLG Apps: Increasing the Trend Analysis % may produce invalid Trend Analysis narrative

    With some datasets, increasing the Trend Change % value could result in the Trend Analysis app producing an invalid narrative: data was displayed instead of narrative text. This has been fixed.

Known issues

  • Support for non-aggregated measures

    MicroStrategy does not provide a way to add non-aggregated measures to visualizations. Therefore, at present, raw data that comprises percentages, ratings, and ratios cannot be analyzed by Arria for MicroStrategy.

 

  • NLG Apps: US date format handled incorrectly

    The mm/dd/yyyy date format is not supported.

    If your dates are in the mm/dd/yyyy format, Arria for MicroStrategy should return an error rather than generate a narrative. However, if all dates have a day value of 12 or less, the add-in misinterprets them as dates in the dd/mm/yyyy format (supported) and generates a narrative with incorrect values.

     

    Work around this issue by converting your dates to a supported format:

    1. In MicroStrategy, go to the Datasets panel.

    2. Right-click your Date attribute, go to Data Type, and select the Date option from the dropdown field.

      microstrategy-arria-data-type-date.png
    3. Click OK. A new Data attribute is created.

      microstrategy-arria-new-date-attribute.png
    4. Right-click the new Date attribute, go to Number Format, select Custom from the dropdown field, and enter dd/mm/yyyy (or another supported format) in the last, blank field.

      microstrategy-arria-custom-date-format.png
    5. Click OK. Now use the new Date attribute with the Arria for MicroStrategy visualization.

 

Top

Version 3.0.0

July 2021

Arria for MicroStrategy 3.0.0 introduces a redesigned out-of-the-box feature and an all-new natural language query feature — making it even easier to add automatically generated natural-language insights to your dossier and dashboards.

New features and enhancements

  • NLG Apps

    NLG Apps (built from a feature formerly known as Configure Narrative) introduces five new out-of-the-box narrative types. In addition to the original Descriptive Statistics, Time-based Variance, and Target-based Variance analyses, you can now analyze and narrate your charts using the Trend Analysis, Ranking Analysis, Describe a Pie Chart, Describe a Bar Chart, and Describe a Line Chart apps.

    See NLG Apps for an overview and the NLG Apps directory for details of each app.

    Note

    The Descriptive Statistics analysis now forms a discrete app, so this type of analysis can no longer be selected with Time-based Variance and Target-based Variance to produce a single narrative. Instead, each analysis type and its corresponding narrative must be added to the dashboard separately.

  • Arria Answers

    Arria Answers for MicroStrategy is a new conversational-AI platform that integrates with MicroStrategy dashboards to give users real-time access to key insights from data, using natural language-queries.

    See Arria Answers for details.

Notable changes

  • New Arria for BI subscription

    To configure Arria for MicroStrategy, you must log in to the visualization with your Arria account credentials and have an Arria for BI license.

    See Arria accounts and licenses for details.

  • Arria-Hosted Private Cloud and Customer-Hosted deployment options

    Users of the Arria-Hosted Private Cloud (a.k.a. Dedicated Cloud) and Customer-Hosted (a.k.a. On-Premises) deployment options can no longer use the publicly available Arria for MicroStrategy visualization.

    Instead, a unique instance of the add-in configured to call your exclusive Arria for MicroStrategy services, must be installed.

    Please contact us for details.

Fixed issues

  • Multiform attributes corrupt data model

    In previous releases of Arria for MicroStrategy, multiform attributes were incorrectly handled, resulting in corruption of the data model and incorrect narratives being generated. This has been fixed.

    From Arria for MicroStrategy 3.0, all values in a multiform attribute are concatenated into a single value. For example, "Napa","California", "94559" is concatenated to "Napa California 94559".

  • Changing narrative text color does not persist in published dossiers

    When a dossier was published, changes to the text color of the narrative using the Text Color setting were lost. This has been fixed.

Known issues

  • Arria for MicroStrategy not supported on Library Mobile for iOS

    The Arria custom visualization is not supported on the MicroStrategy Library Mobile for iOS product.

  • Arria for MicroStrategy not supported in documents on Workstation and Library Mobile

    The Arria custom visualization is not supported in MicroStrategy documents on the Workstation and Library Mobile product.

  • Narratives not automatically refreshed when returning to them after adding or removing fields in Arria Answers

    If you move to Arria Answers from a generated narrative, then add or remove fields in the Arria Answers wizard, the narrative is not automatically regenerated to reflect those changes when you return to it.

    To refresh the narrative so that it reflects any changes made to fields while on the Arria Answers page, regenerate it from the NLG Apps or Custom Narratives configuration page.

  • NLG Apps: Increasing the Trend Analysis % may produce invalid Trend Analysis narrative

    With some datasets increasing the Trend Change % value can result in the Trend Analysis app producing an invalid narrative; data is displayed instead of narrative text.

  • NLG Apps: Alias field setting not used in Target-Based Variance narrative

    When the Summary or Important Things narrative option is selected in the Target-Based Variance app, the Alias field setting may not be used in the narrative.

  • Arria Answers: Alias cannot start with the name of another field

    There is a known issue when you give a field an alias (e.g. SalesDate) that starts with the name of another field (e.g. Sales). In this case, Arria Answers does not correctly process queries that use the alias: it uses the other field (Sales) instead of the field to which you assigned the alias. This problem is also indicated by incorrect color markup when you type the query.

  • Custom Narratives: Field names containing brackets not supported by table-type Studio projects

    Currently, attribute and metric names containing brackets — for example, Date (Quarter) and Date (Month) — are not supported by table-type Studio projects.

    Rename such fields before adding to Arria for MicroStrategy.

 

Top