Let's assume that we have already connected a data source to Adaptive Analytics, created a project and added tables there.

Now we will prepare Adaptive Analytics for work. First, we need to select data from tables, to make it available for the future report. To do this, we need to create dimensions from the columns of the tables. Dimensions are usually created to break down our data into categories, such as what city the user lives in, or what month a purchase was made in.

Hi Community,

We are pleased to invite all the developers to the upcoming InterSystems Globals Contest Kick-off Webinar! The topic of this webinar is dedicated to the Globals contest.

In this webinar, we’ll show you how to deal with Globals to implement different data models and sophisticated indexes. As always, our experts will answer the questions on how to develop, build, and deploy Globals solutions using InterSystems IRIS.

Date & Time: Monday, March 21 – 11:00 AM EDT

Speakers:  
🗣 ​​​@Daniel Kutac, Senior Sales Engineer
🗣 @Joel Solon, Senior Technical Trainer
🗣 @Timothy Leavitt, Development Manager 
🗣 @Evgeny Shvarov, InterSystems Developer Ecosystem Manager

IMPORTANT NOTE InterSystems no longer provides a separate InterSystems Reports Server container. To run containerized InterSystems Reports Server, use Logi Reports Server container and your InterSystems Reports Server license. Documentation.

InterSystems Reports is powered by Logi Report (formerly named JReport), a product of Logi Analytics. InterSystems Reports is supported by InterSystems IRIS and InterSystems IRIS for Health. It provides a robust modern reporting solution that includes:

• Embedded operational reporting which can be customized by both report developers and end users.
• Pixel-perfect formatting that lets you develop highly specific form grids or other special layout elements for invoices, documents, and forms.
• Banded layouts that provide structure for aggregated and detailed data.
• Exact positioning of headers, footers, aggregations, detailed data, images, and sub-reports.
• A variety of page report types.
• Large-scale dynamic report scheduling and distribution including export to PDF, XLS, HTML, XML, and other file formats, printing, and archiving for regulatory compliance.

InterSystems Reports consists of:

• A report designer, which provides Design and Preview Tabs that enable report developers to create and preview reports with live data.
• A report server which provides end users browser-based access to run, schedule, filter, and modify reports.

From InterSystems documentation.

This article focuses on the Server part of InterSystems Reports and provides a guide on running Report Server in containers while persisting all the data.

Trying to figure out inline cache expressions in TrakCare and having little to no success, if anyone can help I'd be very appreciative :)

I'm pleased to announce the release of version 1.4.4 of the VS Code extension, which contains the following enhancements and bug fixes. Links will take you to the GitHub issue being addressed. As always, if you already have the extension installed, VS Code should automatically update your extension. If you're a new user, use these instructions to get started. 

Change Log

• Enhancements
  • Compile asynchronously to avoid timing out (#890)
  • Add objectscript.explorer.

I have created a package that offers a utility to load a Global into JSON object and reverse     
to create a Global from this type of JSON object. Efficient refers to the structure created.
Only Globals nodes containing data are presented in the generated JSON object.

We are trying to track down the source of Orphaned messages and noticed that we are unable to query EnsLib.HL7.Message with any kind of WHERE or ORDER BY clauses in our SQL statement.

I know EnsLib.HL7.Message is a system table, but is there a way we can add additional Indexes to the table to make the query run better/faster without affecting the system?

If one of your packages on OEX receives a review you get notified by OEX only own YOUR package.   
The rating reflects the experience of the reviewer with the status found at the time of review.   
It is kind of a snapshot and might have changed meanwhile.   
So if you did a major change and expect a changed review just let me know. 
Reviews by other members of the community are marked by * in the last column

This example demonstrates the difference you may experience when you write to
Gllobals directly from Embedded Python compared to native ObjectScript.

To make this demo useful I start 2 background jobs that simply write sequentially
to a dedicated global. A common control method signals for a synchronous start.
Similar a common stop & view interrupts data feeding.

That's the principle process:

As 2 jobs run in parallel the probability of just using sequential blocks is reduced.
During the development of this demo, I detected that the JOB command has problems
with ClassMethods in Embedded Python.

Next big healthcare hackathon is approaching! 

MIT Hacking Medicine will take place on April 15-17 in Boston, and it is back in person this year! 
InterSystems will be a Gold Sponsor with "Best Use of InterSystems FHIR Services" challenge and great prizes.
Learn more about the challenge here.  

Registration is now open - don't hesitate to register!

InterSystems has corrected a defect that causes incorrect ObjectScript routine compilation.

This defect exists only in the recently released 2021.1.1 version of:

            InterSystems IRIS Data Platform

            InterSystems IRIS for Health

            HealthShare Health Connect

InterSystems recommends that 2021.1.1 not be used. Incorrect routine compilation occurs silently and can cause unpredictable logic execution. 2021.1.1 versions have been removed from distribution channels.

I created the iris-fhir-portal as part of the current contest InterSystems IRIS for Health FHIR, and I'm writing this quick overview to introduce the features that my application offers.

The goal of iris-fhir-portal is to show how easy we can create a Patient Chart using FHIR capabilities in IRIS for Health and empower the user with their own data.

Hi Developers!

This is a release of how we improve the Developer Community in June 2021. The key features are:

• Improved monthly digest
• Completely new design of Direct Messages (new features included)

See the details below.

Hi everyone,

Does anyone have any experience / examples of converting an .rtf file into an HL7 message (ORU^R01). My example is a histology report which is placed on a server to pick up and then convert if possible for downstream systems who receive HL7.

Struggling to find any sort of examples or even whether its feasible at this stage - there are certainly better knowledged people on here than me so thought id ask.

With thanks

Warren

Hey Developers, 

New video is already on InterSystems Developers YouTube channel: 

⏯ What is the InterSystems IRIS FHIR Server

It is becoming more and more common to see beautiful badges in the README.MD file with useful information about the current project in the repositories of GitHub, GitLab and others. For instance:

The project is being developed The quality of the code, which also provides its own badge, which immediately shows the status of code validation of the project. If you insert a line into the README.MD file

 [![Quality Gate Status](https://community.objectscriptquality.com/api/project_badges/measure?project=intersystems_iris_community%2Fappmsw-zpm-shields&metric=alert_status)](https://community.

Hi Community,

We're pleased to invite you to the upcoming webinar in Spanish called "Exploring the new Embedded Python feature of InterSystems IRIS"

Date & Time: March 30, 4:00 PM CEST

Speaker: @Eduardo Anglada, Sales Engineer, InterSystems Iberia

Please, I am having trouble connecting to one of several Health Share servers using ISC's Visual Studio Code add-on.

Installation seemed to go smoothly.  I have InterSystems's Studio and was able to automatically pull in my existing connections.  However when I try to make a connection it fails.  

Here is a configuration of one connection slightly edited for security:

        "xxxx-hsiecommon-base": {

            "description": "This has been created by the CCR system export.",

            "username": "therock",

            "webServer": {

                "host": "mongo.il.intersystems.

It sounds strange though it's embarrassing.

I have a class with ClassMethods written in ISOS and Embedded Python.

The ClassMethods written in ISOS start in the Background as usual. No problems

But my 

ClassMethod setPy() [ Language = python ]
{
import iris, datetime, time
- - -

Just fails the JOB command with (even 15 sec) timeout and $ZC=0
This is not funny
My actual workaround:
I created a ClassMethod in ISOS, that does an elegant JobStart
and this ClassMethod only runs the Embedded Python ClassMethod.

SET ^||fruit(1)="apple",^||fruit(4)="banana",^||fruit(8)="cherry"
SET ^||fruit(1,1)="Macintosh",^||fruit(1,2)="Delicious",^||fruit(1,3)="Granny Smith"
SET ^||fruit(1,2,1)="Red Delicious",^||fruit(1,2,2)="Golden Delicious"
SET ^||fruit="Fruits"
ZWRITE ^||fruit

^||fruit="Fruits"
^||fruit(1)="apple"
^||fruit(1,1)="Macintosh"
^||fruit(1,2)="Delicious"
^||fruit(1,2,1)="Red Delicious"
^||fruit(1,2,2)="Golden Delicious"
^||fruit(1,3)="Granny Smith"
^||fruit(4)="banana"
^||fruit(8)="cherry"

How I do send the output of zwrite to $$$TRACE()?

In addition to the previously advertised Cache/Ensemble developer role we also have a requirement for a Cache/Ensemble Support Analyst at SystemC in the UK.

SystemC are looking for a talented and experienced Support Consultant to join our CarePlus team where you will have a pivotal role within the team, providing technical support to our customers.

Could anyone please explain why Caché has a %STARTSWITH function while it supports ANSI SQL "LIKE"?

thank you very much.

Hi Community,

I DTL I am assigning value to %TimeStamp type praport named BirthDate.

18001225  converted to 1800-12-25T00:00:00  but giving below error

ERROR #7208: Datatype value '1800-12-25T00:00:00' is not a valid timestamp format
> ERROR #5802: Datatype validation failed on property 'xxx.xxx.xxxx.xxxxx:BirthDate', with value equal to "1800-12-25T00:00:00"

20000612   converted to 2000-06-12T00:00:00  is not giving any error

Please help me to resolve this. 

* We did not define the variable type as %TimeStamp   , this persistence class created based on XSD.

Thanks 

Prashanth

I started to get the following error when trying to save HTML and js files after editing in VSCode. This used to work fine, csp still works too.

ERROR #16006: Document 'xxx.html' name is invalid
Is there now a setting that I am missing? I did check but saw nothing that was obviously wrong.

Hello,

Our team is looking for a way to export all of our Cache SQL tables into Microsoft SQL Server.  I have only found a method to export one table at a time into an ASCII file.  We have over 170 tables so this would be very tedious and time consuming.  Is there a way to directly export from Cache to SQL Server.  Alternatively is it possible to export the entire database in a single shot or even multiple tables to text files?

Thanks!

Job Title:             Support Engineer / Developer

Location:             Sydney, Australia

Salary:                 Salary negotiable depending on skills and experience

Job Type:            Permanent, Full time following 3 months probation

Integrated Software Solutions (ISS) is a software development company providing mainly laboratory health solutions for over 30 years to some of the most well respected hospitals/organisations around the world. Clients include laboratories in United Kingdom, United Arab Emirates, Canada and Australia.

The GA release is now published for the 1.5 version of the InterSystems API Manager (IAM).

The container for IAM, including all relevant artifacts to upgrade from earlier versions of IAM can be downloaded from the WRC Software Distribution site in the Components area.

The build number for this release is IAM 1.5.0.9-4.

InterSystems API Manager 1.5 makes it easier to manage your API traffic, integrate with your environment and onboard users of your APIs. It has many new capabilities, including:

• Improved User Experience
• Introducing new Developer Portal tools
• Support for Kafka connectivity

I had heard that sample classes are available somewhere.

Hi Team,

I got a 404 status code(fhirResponse.Status) in the below code while inserting patient resources. Other resources data are successfully inserted.

Class HS.FHIRServer.Interop.Operation Extends (Ens.BusinessOperation, HS.HC.Util.Trace.Helper)
{Parameter SETTINGS As %String;XData MessageMap
{
<MapItems>
<MapItem MessageType="HS.FHIRServer.Interop.Request">
<Method>DispatchRequest</Method>
</MapItem>
</MapItems>
}Method DispatchRequest(pInteropRequest As HS.FHIRServer.Interop.Request, Output pInteropResponse As HS.FHIRServer.Interop.