I was using PowerBI to create regular display data obtained from one popular web sourse with hundreds of thousands of visitors per month and a big number of users.

At the beginning of that visualisation development, I was using direct connection from Power BI to Adaptive Analytics powered by AtScale. Adaptive Analytics is useful for cached data, aggregates and fast data sources switching between development and stage phases. The “AtScale cubes'' connection method was used:

The Problem 

Power BI is an enormously popular business intelligence platform with rich visualization and reporting

It's time to announce the Winners for March! Please welcome our awesome Global Masters Heroes!

The storm of applause goes to these developers and their great contribution to DC in March:

🥇  @YURI MARX GOMES, Software Architect, YM Services, Braz

🥈  @Prashanth Ponugoti, Technical Architect, Optimus IT Infra Ltd, London, United Kingdom  

🥉  @Djeniffer Greffin, Soluctions Architect, Sabin Medicina Diagnóstica, Brazil

 Learn more about the competition and our awesome winners below.

MAXSTRING (longstring) is enabled.

We have a Class containing a property definition

Property SettingsJSON As %Text(MAXLEN = 3600000)

The property is used for storing a string of JSON data however in some cases we get a Cache error: %SaveData error when trying to save a string of JSON a lot less than maximum "allowed" length, any ideas anyone? 

I have a Business Service that reads a file from a folder and sends it as a string to a Business Process. In the business process, I need to add a string to the end of the file string that is coming into the Business Process. I am trying to do this in object script in studio and I am struggling to figure out how to add the string to the end of the other string. I am still new to studio and object script I have been reading up on the documentation and I am not sure what is the best way to accomplish this.

Any help would be greatly appreciated.

I have a %Persistent class with properties that are of %SerialObject. I want to add an index to a property of the %SerialObject class.

Is this possible?

Hey Developers,

We are super excited to announce the winners of the InterSystems Globals contest!

The winners of the 19th programming contest are as follows:

Hi Community,

Here is a link to a short video demonstration of a globals project called Cubes.

The source code for the project can be found here

Cubes on GitHub

Hello,

We are preparing for the MIT hackathon and noticed that when using the cloud services for FHIR, there isn't enough or any Patient data to test the FHIR APIs.  Which sample patients can we use?

Hi

How do I run a CSP page from within VS Code.

Secondly I have installed an extension called "Live Server" which will run .html pages within VS Code. Have any of you made use of this extension and if so can you specify that .csp pages are html pages?

If I press F5 in VS Code (just as you would in Cache Studio) in order to view a csp page when I press F5 in vs code it tries to open

http://localhost:57772/csp/bootstrap/

without the csp page name

If I add the csp page name in the url it works. The question is how do I link the csp page to the url passed to the browser

Nigel

Hi all,

I am looking for a best practise approach for providing an ITI-41 based webservice to allow a subsystem to send a provide and register document set transaction via webservice route the request to a registry and loop back the response from the repository to the originating service. Since we need to use Ensemb le 2017.2 I am looking for a best practise to takle that reuirement. As for health connect I could prove a webservice wich supports the named IHE transaction and route it to the registry quite simple. Anyway how would you cope with this requirement under Ensemble?

I donßt need to

Hi Guys,

I'm using a Modal Group but whenever I click outside it the Modal gets minimised, so How can I change the view so that whenever pops up the view get locked until I'm finished with my modal then click exit to endModal ?

thanks

Introduction

Hi Community,

This article is aimed at developers implementing DICOM productions, specifically for cases with third-party endpoints that cannot handle the DIMSE timeout themselves.

For DICOM applications, the DIMSE timeout is a maximum time to wait for the next DICOM request (-RQ) or a response to a request (-RSP), after an association has been established. Unlike the ARTIM (association establishment) and TXTIM (data transfer) timeouts, the DIMSE timeout lives at a higher level than individual PDUs, with the application-level request/response logic.

The DIMSE timeout is described

Hey Developers,

Let the voting week begin! It's time to cast your votes for the best applications in the Globals Contest!

🔥 You decide: VOTE HERE 🔥

 
How to vote? Details below.

Hi,

Currently I am working on HL7 Ver 2.3. Just want to know what is the best container image for this version?

Thanks

Globals are the core of the InterSystems IRIS for data persistence. It is flexible, allowing store JSON documents, relational data, object oriented data, OLAP cubes and custom data models, like Mindmaps. To see how to store, delete and get mindmap data using globals, follow these steps:

1. Clone/git pull the repo into any local directory

$ git clone https://github.com/yurimarx/global-mindmap.git

2. Open a Docker terminal in this directory and run:

$ docker-compose build

3. Run the IRIS container:

$ docker-compose up -d

4.

Hi Community,

This post is a introduction of my openexchange iris-globals-graphDB application.
In this article I will demonstrate how to save and retrieve Graph Data into InterSystems Globals with the help of Python Flask Web Framework and PYVIS Interactive network visualizations Library

Recommendation

• Read related documentations Using Globals
• Introduction to the Native SDK
• PYVIS Interactive network visualizations Liabrary

Step1 : Establish Connection with IRIS Globals by using python native SDK

 #create and establish connection
  if not self.iris_connection:
         self.iris_connection

Hello, 
I'm currently working on a custom version control implementation. 
I'd like to show differences between a copy of a previously saved routine as a merge of the ^ROUTINE Global and the current version of that same routine. 

I've found legacy Documentation for %RCMP which does the trick in the terminal but I'd like a similar result stored inside a variable. 
I also want to show differences, not only see if they are the same or not. 

The management portal has that exact feature, so maybe someone can direct me to the function that is being used there. 

I've seen solutions with files, and one way

I am new to Intersystems, in our project we are directly connecting to the server (environment) using  Intersystems VSCode extensions and publishing our changes from local machine. This is not the way we usually do as development process.

Is it possible to implement continuous integration ? So that developers can check-in their code in GIT Hub and can integrate Jenkins and automate the deployment?

Could you please help me on this ?

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. Compact refers to the structure created.
Globals nodes are included with data for a fast data load.   
But also the related code is quite compact.

I will devote the third article to a story about the additional features of the project.

znamespace

Very often you need to find out if there is a specific package in the current instance, for example, so as not to duplicate. To do this, I implemented a modification of the namespace command of the package manager, on the option tab, you need to press the FIND button.

You can filter by package name. You can filter by package name. As a result, we get a list in which namespaces, which versions of packages are.

package

After installing the package, sometimes there is a need to collect all the files

I wanted to join the InterSystems Globals contest. I have worked with InterSystems globals more than twenty years and I consider myself an expert. I developed another money app for globals contest because I needed it. What I had created previously was not really that useful for me. 

I still miss the features of Microsoft Money. I wanted to be able to get a report of transactions based on some criteria like how much did I spend on Groceries in March. 

I still use Excel spreadsheets to keep track of my financial transactions.

Hi contestants!

Here are the results of the bonus collections the applications of the Globals Contest accomplished.

Here are the projects that scored it:

Hi Team,

When I restored the database or import the data from source system to target system at that time how to Preserve source system identity value in target system.

Thanks,

Ankur Shah

Hi Guys,

I've the below tablePane and for some reason when it's populated always the last row is selected by default, I've many tablePanes defined the same way but none of them has the last row selected when populate, so not sure why this grid is doing this? 

<tablePane
    width="1200px"
    id="ItemsTable" 
    OnCreateResultSet="GetLog"
    maxRows="20000" 
    pageSize="20" 
    showRowNumbers="false"
    showRowSelector="false"
    showZebra="false"
    valueColumn="ID" 
    nowrap="false"
    showValueInTooltip="true"
    showFilters="true"
    autoExecute="true"
    initialExecute="false"

Hi!

I'd like to know if there are any issues if an index is inserted into a table without running the %BuildIndices() method.

It's important to note that data inserted before the index is not important for retrieval, so it's not a problem data inserted before the index don't show up in queries.

The reason why I'm asking this is that I'd like to avoid index reconstruction on big tables which I need to inser such index.

I'm using Cache 2018.1.

Thanks,

José

Hi Community,

This article describes the small ZPM module global-archiver.
The goal is to move a part of a global from a database to another database.

Why this package?

A typical use case is read-only data sequentially added to your database that you can never delete.
For example:

• User log access to patient medical data.
• Medical documents versioning.

Depending on the intensive usage of your application, these data could highly increase your database size.
To reduce the backup time, it could be interesting to move these data to a database dedicated to the archive and make a backup of this

Is there a way, given a %CSP.SessionEvents subclass, to simply return an HTTP 403 error status from OnStartRequest?

If I return an error %Status from the method, it'll go to the error page; if I don't, it's always a 200 OK and the page continues to render.

Register for our free NLP webinar to learn how to accelerate your data interpretation workflow. 

Key learnings from the webinar:

✔️How we connect OMICs layers and text in your research,

✔️How to link your data to multiple knowledge domains using a single simple notebook,

✔️How our API Functions and digital notebooks can support your NLP and OMICs data interpretation to extend your workflows,