#InterSystems IRIS BI (DeepSee)

According to the documentation (2016.1) we can use either a system defined web application (/api/deepsee) or create a custom web application for handling requests. What are some reasons to use one rather than the other?

Hello, I've completed this tutorial: https://community.intersystems.com/post/deepsee-period-date-vs-same-peri...
I've used the "year" level instead of a pivot variable.
I want to calculate something like the following variation: 100 * ([DateOfSale].[PTD] - [DateOfSale].[LYPTD]) / [DateOfSale].[LYPTD]
I create a new calculated member, under the same dimmension with the above expression.

My boss would like to change the Ensemble logo that one sees in the mangement portal, because it's part of the DeepSee Anaylzer.

I can see where it lives on the generated html.

I kow that you can set the logo for the User POrtal settings in DeepSee -- you can specifiy a URL for your logo. But we'd like to go one stee further and change the Ensemble by InterSystems to our own logo / company name.

Is it possible to change this in the code? Is there a Configuration setting to change this?

Thanks,

Laura

I have a query text that I need to execute and return results as xml.

It may be an SQL query or an MDX query. Is there some easy way to determine which one is it?

Any ideas?

Hi everybody,

I have to create a pivot that shows the result comparing the last week of the current date with the last week of the last year in the same month. I tried using the function LAG, but didn´t work. Works only if I want to compare the months between the two years. If someone has some idea, i will appreciatte a lot.

Thanks.

Jaqueline Krieger

In iknow they are mentioning that Japanese words cannot be used for iknow in CRC and in CC, If one needs to use iknow for Japanese character how does concepts and relation works for them?

What is Purpose of DeepSee and how to we mapping the Deepsee concepts with in Class file.Please give a simple program for how to we learn on Deep see.

To set up Web Application, I need to turn on the DeepSee flag using Caché ObjectScript. How can i do it?

How to setup dollar ranges to get the number of patient accounts. So, I want to capture the number of patient accounts based on the original balance of:
0 to 499
500 to 999
1000 to 2499
5000 to 9999
10000 to 24999
25000 to 49999
50000 to 74000
75000 to 99999

=100000

Hi!

There are DeepSee dashboards, which make sense only when filtered.

Usually, they are used as Drill Target or New_window control with SETTINGS=Widget;FILTER=filtervalue.

Is there a way to hide such dashboard from the Catalog or/and request the filter value once it is opened by User?

How can I create a calculated field that will give me the grand total of a column? For instance, if I have a row that has 200, 300, 500, 600, how do I get the Grand Total?

I have already used the wrench under Column Options as % of Total so, I can't use that option.

1. How can I create a calculated field to give the previous date. For example, I need to create a pivot table that shows total payments posted for the prior day.

2. How to create a calculated field to show average daily collections divided by the number of the days passed in a month. So, for today, it would be the average daily collections divided by 4days.

Thanks!

Hi!

How can I show a number of rows in a given DeepSee pivot?

My group needs to be able to monitor items / tasks, and let a non-management-portal user see the monitoring. Is it possible to run DeepSee queries on Production items? I feel like I should not be recreating the production environment or the task manager just so that I can query on the items that are running, and on their states (like "successful" or "send email").

Also, I need to log custom events for each task, and I'm running into difficulties with the task manager in this regard; hence the question about using the Production instead, but querying it.