Question Evgeny Shvarov · Nov 27, 2016 New tag for the tools for developers Hi!We want to introduce the tag for the posts which describe the tools for the developers. How about #DevTools?Your ideas? #DC Feedback 0 2 0 160
Question Evgeny Shvarov · Nov 22, 2016 Create Namespace snippet Does anyone have a snippet to create the Namespace and database with defaults in one command? Something like: do ##class(Utils.Namespace).Create(Name) Please share? Thank you in advance! #Code Snippet #Namespace #ObjectScript #Caché 1 4 0 822
Question Evgeny Shvarov · Nov 20, 2016 How to export class package in xml Hi!Is there any way to export a class package to xml file programmatically which will include all the classes of the package? #Change Management #Caché 2 12 1 1.9K
Question Evgeny Shvarov · Oct 28, 2016 Max function for the set of parameters There is an interesting discussion in the Russian forum going. What is the best solution for the function which returns the max for the set of parameters? From the listed solutions I like this one: ClassMethod max(args...) { for i=1:1:args { s max(+$g(args(i))) = i } s i="", max=$o(max(i),-1, i) Q $lb(max, i) } #ObjectScript #Caché 1 8 0 1K
Question Evgeny Shvarov · Oct 18, 2016 Classes removing and renaming best practice with Atelier Hi!Suppose I have a project in Atelier with two classes: Class A and Class B and develop it in my local Caché installation. If I decide to delete Class A and delete it in Atelier project will it be deleted in Caché automatically or should I do it manually?Or what is the suggested workflow in this case?Same question is if I decide to rename Class B to Class C. #Change Management 1 4 0 622
Question Evgeny Shvarov · Sep 19, 2016 Tag for the newbies posts Hi, Community!We want to introduce tag for the posts, which are related to the newbies.What is the best tag for it?Newbie's corner?Newbie?Beginner?Your option? #DC Feedback 0 6 0 242
Question Evgeny Shvarov · Jul 28, 2016 Pivot variables deployment Hi!How do you guys deploy DeepSee pivot variables?Haven't found it in documentation.Thank you in advance! #InterSystems IRIS BI (DeepSee) 0 5 0 389
Question Evgeny Shvarov · Jul 27, 2016 Add Tag Tips&Tricks discussion Hi, Community!We want to introduce tag Tips & tricks.It's not a snippet sometimes, but some small piece of best practice and useful experience. Please vote if you think it makes sense and we need this tag and we'll introduce it as the first level tag in taxonomy. #DC Feedback 4 1 0 180
Question Evgeny Shvarov · Jul 8, 2016 Top from the group SQL query in Caché Hi!There is interesting question in Stackoverflow.This query works for MS SQL: SELECT * FROM ( SELECT *, ROW_NUMBER() OVER (PARTITION BY client_id ORDER BY date_updated DESC) AS rn FROM client_address ) a WHERE a.rn = 1 There is one answer there, which solves the task: #SQL #Caché 2 5 0 2.4K
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
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
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
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
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
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
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