Article Evgeny Shvarov · Aug 31, 2016 1m read DeepSee cubes building troubleshooting Hi! Sometimes you see that call to DeepSee cube building method: w ##class(%DeepSee.Utils).%BuildCube("CubeName") does nothing. Here are my 2 cents on possible reasons. 1. Run DeepSee Reset method in certain Namespace: NAMESPACE> w ##class(%DeepSee.Utils).%Reset() and try again. 2. Make sure, that all the indices in your base class for the cube are rebuilt, rebuild them and run it again: #InterSystems IRIS BI (DeepSee) #Cubes #Tips & Tricks 1 2 0 371
Article Evgeny Shvarov · Aug 16, 2016 1m read Yet another use case for $translate: date conversion Have you tried $Translate for date conversion? USER>write $Translate("Dd.Mm.WwYy","WwYy-Mm-Dd","2015-08-02") 02.08.2015 Stolen from Russian forum and Alexander Koblov. #Code Snippet #ObjectScript #Tips & Tricks #Caché 1 1 0 573
Announcement Evgeny Shvarov · Aug 1, 2016 Developer Community July 2016 Digest Hi, Community!Here is the digest of the most interesting and valuable posts on Developer Community published in July 2016.Here we go!News, events, releases2015.2.4 Maintenance ReleaseDeveloper Community email notification subscriptionsSerenji 2.6 is now available #Digest #Developer Community Official 1 0 0 299
Discussion Evgeny Shvarov · Jul 29, 2016 Tag proposal - Performance Do we need tag Performance to mark posts related to recipes of better performance for InterSystems based solutions? Vote please, if we need it! #DC Feedback 2 0 0 197
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 317
Article Evgeny Shvarov · Jul 27, 2016 1m read Tips & Tricks. Be aware of Month->Week hierarchy in DeepSee Hi, Community!You know, that when we build hierarchies in DeepSee dimension all the members of lower level should be the part of one member of the higher level.If not you'll get some empty results in MDX queries with this hierarchy.With Time dimensions the obvious valid hierarchy is Year->Month->Day, cause every Month consists of one Year and every day consists of one month. #InterSystems IRIS BI (DeepSee) #Tips & Tricks 2 3 0 396
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 145
Article Evgeny Shvarov · Jul 25, 2016 2m read Developer Community email notification subscriptions Hi, Community!Today there are two main settings for your email notification subscriptions.1. Subscribe to all new posts, all comments, all answersYou can do it in your subscription settings in the Content Types. Click on My Account, go to Subscriptions and click on Content types tab: #DC Feedback #Developer Community FAQ 1 15 1 788
Article Evgeny Shvarov · Jul 14, 2016 1m read Caché Haiku Alex Koblov posted today a #CachéHaiku: Full command names Make your code more readable Than compact versions My haiku: Caché Globals Shows you keys to the value If you $order it Your variant? ;) #Caché 8 19 1 1K
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.2K
Announcement Evgeny Shvarov · Jul 1, 2016 Developer Community June 2016 Digest Hi!Here is the digest of the most interesting and valuable posts on Developer Community published in June 2016.Here we go!News, Events, releasesUpdate to 2016.1.1 Maintenance Release2016.1.1 Maintenance Release2016.2 Field Test Kit 2016.2.0.677.0Most viewed #Digest #Developer Community Official 4 0 0 422
Announcement Evgeny Shvarov · Jun 30, 2016 June 30th DC release Hi, Community!I'm pleased to announce the new Developer Community release today. Meet the changes!New voting systemNow you can vote for the post or comment with like or dislike buttons to change the post/comment rating.Previous ratings converted to the new rating with the following rule:4,5 stars = +11,2,3 stars=0.Improved email notificationsYou should receive HTML notifications now on new posts and comments on DC.Please share your feedback with the recent release. #DC Feedback #Release 4 4 0 197
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 381
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 600
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 479
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 494
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.2K
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 162
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 464
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 322