See how cubes are constructed for use in business intelligence, and learn about SQL and MDX query languages. Physical and virtual cubes are used in InterSystems IRIS® Business Intelligence and Adaptive Analytics:
https://www.youtube.com/embed/l6XFj1JQ5Fw [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]
Can anyone share some good sample custom CCR Utility classes that would be called by ImplementCCR routines / CCR event hooks to help bootstrap a HealthShare (2020.1) environment or specific change?
I've the below query that selects the existing processes with dates & times and it working fine, but in case of records with the same processedDate I would like to only get the latest based on processedTime field?
The current version of SAM creates Prometheus metric endpoints which appear to be handled correctly by the current prometheus scraper, however the metrics do not confirm to the current prometheus standard. The standard states:
Hello everyone, I'm trying to run a cache terminal script from cmd/ batch. I run it like this C:\MyCache\bin#cterm.exe C:\Users\Me\Desktop\cache_scrip.scr The command opens a terminal, but nothing happens, no title present, no log file written, no output, it's just stucked. Here is my script:
I have created a package to export a Global into JSON object file and to re-create it by reloading from this file embeddedPython refers to the new available technologies. It should be understood as a learning exercise of how to handle the language interfaces. Only Global nodes containing data are presented in the generated JSON file. Differently from the previous example, this one is using embedded Python only, no ObjectScript. Therefore PURE
I have created a package to export a Global into JSON object file and to re-create it by reloading from this file embeddedPython refers to the new available technologies. It should be understood as a learning exercise of how to handle the language interfaces. Only Global nodes containing data are presented in the generated JSON file.
We need to export last 5 days Ens.MessageHeader data for a specific messages into file. I have written custom code to execute SQL query in object script.
Could somebody help me to iterate resultSet and write the data to text file.
I have created SOAP service and WSDL generated. While accessing WSDL URLs, it is redirecting to login page and giving access with production credentials.
I have tried to invoke form webservice clinet (soapui /postman), endup with authentication failed error.
Same service I am able to access from Terminal.
Could you please help me to access Production exposed SOAP service with out authentication.
I'm using %XML.Writer to write XML files from a database source, and I see that it is not encoding carriage return or line feed as 
 and 
 respectively, and is instead leaving them unencode.
I've checked the syntax with some public tools with adjusted Tablename "Fehlermeldung" -> `Fehlermeldung`. It seems to be valid, but cache does not accept it.
If anybody could give me some insight on creating the %All Namespace programmatically I would appreciate it. There are quite a few posts I found that reference its creation using the UI, but I cant seem to get passed some validations with any form of the below:
We have recently received the two following errors as part of a PDF extraction process and I am trying to figure what the difference is between the two errors?
Thank you so much for being with InterSystems Developer Community for yet another year!
Day by day our team is trying to make it better and more useful for InterSystems developers. More than 10K+ members are already registered in our Community!
We'd like to know how helpful the Developer Community is for you today. Please take a few questions to let us know what do you think and what could be improved.
InterSystems Certification is developing a certification exam for CCR and, if you match the exam candidate description given below, we would like you to beta test the exam. We anticipate the exam being available for beta testing on February 7, 2022, but interested beta testers should sign up now by emailing certification@intersystems.com. The beta testing must be completed by March 31, 2022.
You will receive a string of comma-separated integers whose elements have both a negative and a positive value, except for one integer that is either only negative or only positive, our challenge will be to find that integer.
As usual shortest solution wins.
The MONITOR process (also called the Caché Monitor) scans the messages in your cconsole.log file and sends you emails based on the severity of those messages. The MONITOR is configured using the ^MONMGR utility in terminal.
The MONITOR should not be confused with the similarly named System Monitor, which checks a variety of system health and performance metrics and can log messages regarding them to the cconsole.log, where they can then be scanned by the MONITOR.
This concept may be known to some, but I just found it very useful and I would like to share as it may help someone else.
If you are working with CSP or Zen you sometimes come across the need to use embedded JavaScript. Suppose you are working with some loops, which use < or > as shown in example below:
By update
