Question Evgeny Shvarov · Jun 23, 2016 How to extract the root in Caché properly Hi! Here is the question in Russian Forum regarding roots extracting. In Caché ObjectScript we use exponentiation operator (**) to raise an exponent to power. F.e. let's raise 3 to power of 3: USER> write 3**3 27 And we use the same operator to extract the root. USER> write 27**(1/3) 2.999999999999999963 And 2.999999999999999963 is not 3, obviously. How to extract roots properly in Caché ObjectScript? #Caché #ObjectScript 0 5 0 427
Article Evgeny Shvarov · Jun 13, 2016 1m read Debug: using locks for breakpoints Hi, Community! Want to share with you one debugging approach from the Russian forum. Suppose I want to debug the application and I want it to stop the execution on a particular line. I add in code this line: l +d,-d When I want to start debugging in this line I block d in terminal USER> l +d And execute the app. The app stops on this line and lets me connect to it with Studio debugger. #Best Practices #Debugging #ObjectScript #Caché 0 8 1 683
Article Evgeny Shvarov · Jun 8, 2016 1m read How to post an article from Word or Google Docs Hi, Community!If you prepare your longread for DC in Microsoft Word or Google Docs there is one very easy way how to add your formatted text and images in DC post at once.To make it do the following:1.Click Create Post on Developer Community.2. Copy all the text in Word o GDocs to the buffer.3. Click the button Paste from word (see the shot):4. Paste the text to the opened window an press OK. #DC Feedback #Developer Community FAQ 0 7 0 558
Announcement Evgeny Shvarov · Jun 1, 2016 Developer Community May Digest Hi!Here is the digest of the most interesting and valuable posts on Developer Community published in May 2016.Here we go!News and EventsCaché and Ensemble 2016.3 field test now available2016.2 Field Test Kit 2016.2.0.665.0 #Digest #Developer Community Official 1 0 0 515
Question Evgeny Shvarov · May 30, 2016 Solution for T9 Spelling Problem in Caché ObjectScript Hi, Community! Last weekend we held the Final of InterSystems Contest on Caché, DeepSee and iKnow under the aegis of IT Planet Student Championship in Ekaterinburg. BTW, this year we had more than 1,400 participants in InterSystems Contest. #Caché #ObjectScript 3 20 0 1.3K
Announcement Evgeny Shvarov · May 16, 2016 DC Statistics: 2000 comments! 1000+ posts! Hi, Community!Today we reached 2000 comments and answers on DC! The comment was made by Fabio Gonsalves!Also, a couple of weeks ago we had the 1000th post by Murray Oldfield!And we have 1,227 DC members today! #Digest #Developer Community Official 2 1 0 189
Announcement Evgeny Shvarov · May 13, 2016 Meet InterSystems Developer Community Twitter! Hi, Community!We've launched Twitter for InterSystems Developer Community!Follow us to be in touch what happens on InterSystems Developer Community. Find valuable postings, hot discussions and best practices links there. You can also retweet and like what you find significant!See how it looks:Join! #Developer Community Official 3 5 0 501
Question Evgeny Shvarov · May 12, 2016 Full series of dates in Time Dimensions in DeepSee Hi!Sometimes, especially when I work with Combined Cubes, I need to have all the dates in Date Dimension, not only members with rows in Fact table.Is there any way to switch it on? #InterSystems IRIS BI (DeepSee) 1 6 0 373
Article Evgeny Shvarov · May 11, 2016 1m read The simplest snippet to read from file in InterSystems IRIS Hi! I believe the simplest is (to work with csv delimited by ";"): set file = ##class(%File).%New( "data.csv" ) set sc = file.Open( "R" ) if $$$ISERR(sc) quit ; or do smth while 'file.AtEnd { set str=file.ReadLine() for i=1:1:$length( str, ";" ) { set id=$piece( str, ";" ,i ) write !, id // or do smth } } do file.Close() Possible options: different variants of error handling with sc code. Embrace while loop into try/catch block. And what's yours? #Code Snippet #CSV #ObjectScript #Caché #InterSystems IRIS 3 16 0 7.1K
Announcement Evgeny Shvarov · May 5, 2016 Developer Community April 2016 Digest Hi!Here is April digest of most interesting and valuable postings on Developer Community in April 2016.Here we go!News and EventsInterSystems Global Summit 2016 - Session ContentSources for InterSystems Global Summit 2016 Sessions and Expereiences2015.2.3 Maintenance Release #Digest #Object Data Model #Developer Community Official 1 0 0 378
Question Evgeny Shvarov · Apr 24, 2016 Import/export data from InterSystems IRIS Hi! Suppose I have full access to InterSystems IRIS database instance A and want to export a consistent part of the data and import it into another InterSystems IRIS instance B. Classes are equal. What are the most general and convenient options for me? TIA! #Databases #Data Import and Export #Object Data Model #HealthShare #InterSystems IRIS for Health #Health Connect #InterSystems IRIS 0 18 0 7.2K
Article Evgeny Shvarov · Apr 16, 2016 1m read Try catch block I usually use in InterSystems ObjectScript Hi! Want to share with you code snippet of try catch block I usually use in methods which should return %Status. { try { $$$TOE(sc,StatusMethod()) } catch e { set sc=e.AsStatus() do e.Log() } Quit sc } Here $$$TOE is a short form of $$$TROWONERROR macro. Inside macro StatusMethod is any method you call which will return %Status value. This value will be placed into sc variable. #Code Snippet #ObjectScript #Caché #InterSystems IRIS 6 21 2 3.4K
Question Evgeny Shvarov · Apr 16, 2016 Atelier project hidden files. What should I commit? Hi!In every Atelier project you can find following hidden files:.buildpath.version.connection.project.Should I include all of them into commit?I understand that .project is mandatory. But what about the rest? Is there any general rule?F.e. if we work in team and everybody has their own connection on locale machine .connection should not be included. Yes? 1 1 0 397
Article Evgeny Shvarov · Apr 15, 2016 2m read Sources for InterSystems Global Summit 2016 Sessions and Experiences Hi! Please find all the source code Global Summit 2016 Sessions and Experiences in following GitHub repositories: #Global Summit 2016 #ObjectScript #Summit 4 1 0 964
Question Evgeny Shvarov · Apr 5, 2016 How to avoid writing duplicate code in dtl InterSystems Ensemble Hi! There is a question for Ensemble on Stackoverflow:I have the below dtl. In the foreach loop, I am just copying the same code in another part under anif condition. How can I avoid this redundancy? Can I reuse using sub transformation?Here is the dtl class file :https://docs.google.com/document/d/1snJXElyw13hAfb8Lmg5IaySc7md_DE8J40FB79hBaXU/edit?usp=sharing #Ensemble 1 2 0 588
Announcement Evgeny Shvarov · Apr 1, 2016 Developer Community March 2016 Digest Hi, Community!Here is the digest of the most interesting and valuable articles published on Developer Community in March 2016.If we missed something interesting, please feel free to add it in comments.So, here we go!News and EventsCaché and Ensemble 2016.1 ReleaseNew Book, Caché and MUMPS – Part II #Digest #Developer Community Official 3 0 0 409
Question Evgeny Shvarov · Mar 31, 2016 Running total without %CELL Hi!There is an example in Samples which shows how to implement 'running total' measure: "Pareto Chart for Category" dashboard.To calculate running total this pivot uses calculated measure with %Cell expression:Measures.[Revenue as Percent of Total] + %CELL(0,-1) #InterSystems IRIS BI (DeepSee) #Analyzer #MDX 0 3 0 457
Question Evgeny Shvarov · Mar 23, 2016 Get coordinates against street address Hi!Does anyone have an example of subj?I know there is google service for it. Anyone uses it in production? What is the feedback?In case of positive feedback would you please post the code example?TIA! #Caché #Code Snippet 0 5 0 481
Article Evgeny Shvarov · Mar 18, 2016 1m read Developer Community MVP of March and the Winner of GLobal Summit Contest II is ... Hi, Community! The Second InterSystems Global Summit Contest finished yesterday, and we have a new winner! John Murray has won the prize and showed very impressive contribution activity with the result: #Global Summit 2016 #DC Feedback #Summit 2 4 0 331
Announcement Evgeny Shvarov · Mar 10, 2016 Global Summit Contest II - half time review! Hi, Community! The Second Global Summit Free Registration Contest is running and we have only one week to celebrate new winner! Here is current leaderboard amongst non-InterSystems DC Members after a half of the race: #Contest #Global Summit 2016 #Other 3 0 0 167