#InterSystems IRIS BI (DeepSee)

When creating a filter located on a dashboard that targets all, is there a way to narrow that filter down?

For example, in our data we have some dates that are well out of range due to data quality issues, but they still appear in the drop downs. Is there a way to say, only make available the below dates in the filter?

Another example, If we want to only look at Emergency data, it still provides all the wards for inpatient activity and activity in other hospitals, meaning, to get to just the Emergency wards you have to scroll through everything?

Hope that makes sense.

Is it possible to have CSV export option on dashboards in the same way as excel export.

Those of you, who work with DeepSee, might have spotted, that when working with a date hierarchy, there are several functions, allowing you to select a time function for a given level. E.g. for extracting a year from a date/time property when building date hierarchy, you simply use Year function. similarly for month number, quarter and so on. Sometimes, you may wish to see the time - namely hour numbers. For this there is a HourNumber function available with DeepSee. Unfortunately, this function converts time into 12 hours format suffixed with AM/PM to indicate day part.

The DeepSee TroubleShooting Guide helps you track down and fix problems occurring in your DeepSee project. A common problem is finding less records than expected in a DeepSee Cube or a related Subject Area. The DeepSee TroubleShooting Guide suggests starting your investigation by checking the following:

Check cube for build restrictions

Check if maxFacts is used

Check if Build Errors are occurring

Hi -

How do the various components of DeepSee (Architect, Analyzer, User Portal) map to the "Out of the Box" user Roles associated with HealthShare?

Hi All,

I need some help to create mdx for the following scenario.

My source table is like this format

Hi - If you want to embed Ensemble's Workflow Inbox, (that offers workflow task items to workflow users) inside of your application - you can access the URL directly without necessarily giving users access to the Management Portal - but more importantly, you can strip away the Titlebar, Worklists and Borders that make up the page by default.

You do this by using the same URL parameters you would use, if embedding a regular DeepSee dashboard into your application.

For example, adding &EMBED=1 at the end of the URL as depicted below:

Is there any way of DeepSee support a hierarchical structure of grouping?

Example:

A product category structure:
- Code
- Name
- Group (parent)

I'm stuck on how to show the top 15 payers and then also show the percentage of the total amount paid for each one. The total amount is what was paid by all the payers not just the top 15.

I know per documentation (pasted below) to set the DSTIME parameters for the base class of a cube. If that base class has a property that is another class, do I have to add the DSTIME parameters to that secondary class?

Documentation says the following in a section titled "Enabling Cube Synchronization:"

Before you can synchronize a cube, you must enable the cube synchronization feature for that cube. To do so:

what are the difference between Deepsee and Ensemble , and how to access the ensemple .Please Tell me

Is it possible to populate a pivot variable with a defined runtime variable from the settings page?

If so, what is the syntax?

I have a DeepSee KPI defined based on %DeepSee.KPI following the documentation http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=.... I've then enabled the KPI on a dashboard by adding a Widget where the data source is the KPI. Currently the ability to show a Detail Listing is implemented by the call back %OnGetListingSQL. This method documents the parameter

Today my customer ask me a question about how to write the MDX with a summary row however this row with different aggregate functions for each column.

We know in DeepSee analyzer has pivot table option "Summary", user can select sum, avg ... aggregate functions to get the summary row/column. However we can not specify different aggregate function for each measure column.

Here show the example to use All level and IIF function achieve that. see the example (Holefood cube in Sample namespace) below

WITH MEMBER measures.[with avg summary info] AS