Hi Community,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ InterSystems IRIS Scalability: New & Next Plus Ultra @ Global Summit 2023

https://www.youtube.com/embed/EF5y23NCau4
[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]

Deltanji 7.1 is now available.

Key updates include: 

* Interoperability Production component driver included, for customers who have purchased the add-on. You can watch a short demo of it here.
* Implement multi-select delete of objects and components
* Add setting to give a passable Beyond Compare launch command line
* Support simplified Locations & Routes diagram 

For more information, read the release notes here >> https://bit.ly/3mHyJHc

Please get in touch with support@georgejames.com for your release kit. 

The update is also available for Serenji debugger users on VS Code, which has the Deltanji solo edition embedded. Simply update the Serenji extension to version 3.2.3 or later and load the server-side code. 

See the latest news from Learning Services, including:

Is there a way to add/substract from a pivot variable?

I have this MDX:

SELECT
  NON EMPTY [DateOfSale].[Actual].[YearSold].&[$variable.Year] ON 0,
  NON EMPTY [Product].[P1].[Product Name].Members ON 1
FROM [HOLEFOODS]

And with pivot variable Year equal to, say, 2016 it works:

Now I want to add previous year first with one pivot variable and one explicit reference. It also works:

Hi,

I seem to be able to execute sqlproc using the convention defined here https://docs.intersystems.com/latest/csp/docbook/Doc.View.cls?KEY=GSQL_q... provided the package/folder is a single level. As, soon I have a nested folder structure I get an error while trying to execute this.

For instance,

select id, Utils.Users_getRole(id) roles from users.users

works fine while,

I'm new to Cache and trying to follow the Using Cache Studio PDF. In section 2.4.3(Adding a Zen form) it tells you insert the following code;

<button caption="Save" o select="zenPage.saveRecord();" />

Unfortunately that code fails compilation. If you try and use the tools there is no o select option nor a select or onselect option. I was wondering if anyone has used this PDF before and knows what the correct attribute should be?

Hello all,

I'm trying to build a cube based on a linked table but seems that IRIS is not able to do it :O

Long story short, I have a linked table in IRIS that sources a Microsoft SQL table (using standard linked feature from the portal). It works fine, I can access it using SQL as many other times. On top of that, I've created in DeepSee (ok, Analytics) a cube that uses this class as source. It compiles correctly, no errors given. When I build it with 100 records, all goes well and using Analyzer I can see results.

We connect to MS SQL Databases using the Microsoft JDBC Driver 12.2 using the following URL

jdbc:sqlserver://<server>:<port>;database=<database name>;trustServerCertificate=true;integratedSecurity=true;authenticationScheme=NTLM;domain=osumc;authentication=NotSpecified

They want to migrate the databases to the Azure Cloud and in doing so we need the Authentication to change to go through Microsoft Entra. I was given the following URL

i am trying to embed a dynamic SQL into Objectscript code , but the %NEXT() will return 0 , however when i copy the same query and run it in the SQL bit it will give me the result i want
the code :

Hello Community!

A new challenge has arrived for you: The Third InterSystems Technical Article writing contest in Spanish is here!

🏆 3rd Technical Articles Contest in Spanish 🏆

Description of the contest: Write an article in Spanish in the Developer Community, on any topic related to InterSystems technology.

Duration: from May 6 to June 2, 2024.

Prizes for all participants: Everyone who publishes an article in Spanish (In the Spanish Community) during the contest period will receive a prize.

Main prize: LEGO Ferrari Daytona SP3 / Magic Gringotts™ Bank - Collector's Edition.

Hi Community

I am using a standard DTL for Allergy Intolerance but it shows codes for Category and Severity Columns on cliinical viewer.

I have copied the standard DTL to my custom folder and I want to modify it to show descriptions for these two columns but I don't know how to do it.

Please see the below DTLs for Category and severity and advise how I can change them to get descriptions.

Category DTL section

The Customer Churn Predictor application is a tool that demonstrates how to use IntegratedML to helps companies identify which customers are likely to leave in the near future and develop customer retention strategies. Benefits of the similar application include:

Hi Community,

We are pleased to invite you to the upcoming webinar in Spanish:

➡️ Developing a chatbot with Google Dialogflow, Telegram and InterSystems IRIS

Date & Time: February 2, 4:00 PM (CET)

During the webinar: