All time
InterSystems Developer Community is a community of 25,513 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more

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.

0 3
0 438
Announcement
· Mar 16, 2017
Articles' Views Analytics

Hi, Community!

I hope you know the option to use DeepSee analytics portal for Developer Community stats. You can find it in Community-Analytics menu.

Let me introduce the beta of new analytical dashboard 'Articles' Views', which is available in Authors folder.

It consists of two dashboards, first shows the running total of the views for the articles (to see the impressive growing curve).

2 5
0 341
Article
· Sep 26, 2023 1m read
Create JSON Objects and Arrays by SQL

The related package avoids adding %JSONAdaptor to each class but uses instead
SQL functions JSON_OBJECT() to create my JSON objects. With this approach, you can
add JSON to any class - even deployed ones - without any need for change or recompiling.

The trigger was the Export of M:N relationships as JSON objects or arrays.

Open Exchange app
11 0
0 440
Discussion
· Mar 2, 2023
Code Golf: Isogram

It's time for a Code Golf round!

Isogram

A word or phrase that has no repeating letters, consecutive or non-consecutive.


Implement a method that checks if the received string is an isogram or not.
Assume the empty string is an isogram.
Ignore the letter case.

Allowed inputs: A-Z, a-z.

As usual, the shortest solution wins!

4 11
0 429
Article
· Nov 28, 2022 1m read
Use IntegratedML to 'predit' diseases

Hi Developers,

IntegratedML is a feature helps us and our teams easily implement machine learning (ML) without dedicated ML experts and data scientists. If you do not need particularly complex ML function, integratedML is a good choice and convenient that only requires executing 3 SQL queries to build predictive models directly from InterSystems IRIS to ML engine.

Open Exchange app
5 2
1 400

Hi All,

Is there any cache command which can give who all has compiled a classes from the day it has been created. Specifically I want the 2 information username and time of compilation of class.

I tried with $$DATE^%R("TEST.1.INT"), but it only gives the last compilation time.

Thanks in advance !!

0 3
0 437

Hi Community,

We're pleased to invite all the developers to the upcoming InterSystems AI Contest Kick-Off Webinar! The topic of this webinar is dedicated to the InterSystems AI programming contest.

During the webinar, we will demo how to load data into IRIS, how to deal with it using ODBC/JDBC and REST, and how to use special AI/ML features of IRIS: IntegratedML, DataRobot, R Gateway, Embedded Python, PMML.

Date & Time: Monday, June 28 — 11:00 AM EDT

Speakers:
🗣 @Aleksandar Kovacevic, InterSystems Sales Engineer
🗣 @Théophile.Thierry, InterSystems Intern
🗣 @Bob Kuszewski, Product Manager - Developer Experience, InterSystems
🗣 @Evgeny Shvarov, InterSystems Developer Ecosystem Manager

https://www.youtube.com/embed/4vC1gp1PeUw
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

4 1
0 420

I am looking for an experienced IRIS for Health engineer to join the CVS Health family.

This position can be contractor, contractor for hire or direct hire.

We are doing our first implementation of the product and can use someone with experience.

The contractor role can be fully remote.

For a hire we are currently fully remote due to COVID, however, post CVID, we should be in a hybrid model (some remote and some onsite) in the Chicago area.

4 0
1 440

Hey everyone.

I have a process where I create a new %Stream.FileCharacter object, specify the filename (including it's path), write data to the stream, and then save. However for some reason, if the user account does not have write access to the directory, the %Save method is still returning true even though it was unable to actually write the file to the folder.

The location is a UNC path, and I'm wondering if this is tripping me up?

0 3
0 437

Hi,

I have a PV1 repeating field that can contain multiple or a single value. I'd like to always pull the last value in the field but am not sure how to configure this in my DTL.

The repeating field is in PV1:50().1

Could somebody shed some light on this?

Examples:

|15081942~15081951~15108961~15280550|

|15081947|

|15081939~15081940|

Thanks

0 5
0 435

I'm looking for the best strategy for extracting data from a Cache table that houses 86 Million lines of data and around 190 columns. I'm currently using DBeaver and the Invoice Service dates go back to 1996. Optimistically I'm looking to pull to a pipe delimited flat file, but even a year's worth of data takes many hours to get query results.

Any suggestions for the best practice/strategy?

Thanks,

John

0 2
0 438
Question
· Jan 14, 2020
%CSP.Rest custom headers

I would like a REST client to be able to send a custom header with the http request, for example "APPLICATION-ID".

This can be seen in the CSP gateway trace but I have tried using %request.GetCgiEnv("HTTP_APPLICATION-ID") in various formats and parts of the classes but cannot work out where I can get this. Documentation says this should work but is for normal CSP pages.

Any ideas?

0 6
0 434

For IRIS 2019.1 and later, the documentation has a new look and feel. Check it out:

https://docs.intersystems.com/irislatest/csp/docbook/Doc.View.cls

The underlying changes include a new style sheet and a complete rewrite of the code we use to generate HTML. (There is now an underlying API for retrieving content as JSON, as well as a large set of unit tests -- for those of you who like that kind of thing!)

6 2
1 400
Question
· Jun 28, 2019
Internal Web Service

Hello everyone,

Anyone can help me please. We use SOAP web service with public methods and have many instances of these classes, all work fine. We would like to create a new SOAP web service but for internal usage only, meaning not available to the public. The purpose of this is for communication between different servers internally.

We thought of having the methods to be Internal, WebMethod instead of just WebMethod.

Any suggestions?

Regards

Ben

0 1
1 439

It is possible to update Cache object property from Python using the following Python code, with import of intersys.pythonbind3:

my_object.set("my_property",["A","B","C"])

However, I am unable to save 2D %List with 2D Python array like the following:

my_object.set("my_property",[["A","B","C"],["1","2","3"]])

I am not sure whether this is Python-Cache bind flaw or design issue. Is there any alternative/ workaround to do the same for above?

0 3
0 437

Hello. New to the forum and was hoping I could get some expert help here. I have one data set that is using CHD Logic to combine Procedure and Diagnosis codes to define Sensitive data and flag the record for additional protected filtering. The files coming in define what is flagged and the Clinical Info Rule and Clinical Info Type are tied to the flag in the file which identifies it as a additional protected record.

0 1
0 439
Article
· Aug 26, 2016 2m read
NewBie's Corner Session 18 Caché or Cache

NewBie's Corner Session 18 Caché or Cache

Welcome to NewBie's Corner, a weekly or biweekly post covering basic Caché Material.

Caché and Cache

Caché and Cache are not the same. Caché is a product offered by InterSystems. Whereas Cache refers to memory storage.
In computing, a cache /ˈkæʃ/ KASH, is a hardware or software component that stores data so future requests for that data can be served faster; the data stored in a cache might be the result of an earlier computation, or the duplicate of data stored elsewhere.

0 0
0 440

I need to pass multiple values to a FILTER to a DeepSee DASHBOARD via the URL. The documentation seems to indicate this can be done, i.e.: "Where each filterspec is filter_name.filter_values" but there are no examples I can find that indicates what is used to separate multiple values. Say I want to pass the three values 5, 6, and 1395 to a filter. To pass just the 5 I know this works:

&SETTINGS=FILTER:LEAD.MYUSERID.H1.MYUSERID.5

but how do I include 6 and 1395. None of the following seem to work:

&SETTINGS=FILTER:LEAD.MYUSERID.H1.MYUSERID.5.6.1395

1 2
0 438
Question
· Jan 5, 2024
SFTP connection problem

Hello,

I have been facing a problem for several months, I have several flows that work in SFTP with the iris class EnsLib.FTP.PassthroughService

The problem is that from time to time I get an error message that says:

"A connection could not be established because the target computer expressly refused it"

I had the case for a server at our house and we solved the problem by extending the call interval parameter to 60 seconds,

1 3
0 436