go to post Evgeny Shvarov · Jul 6, 2016 Edward, thank you for the very useful article! As addition to your article it would be great to add a demo class with direct examples of all the features. Regarding this method: ClassMethod IndexOpen(val, concurrency, sc As %Status) "val" should be in Upper case I suppose?
go to post Evgeny Shvarov · Jun 30, 2016 Thank you John, some of your points here really make sense. We'll think about it.You can be sure, that all posts in InterSystems Data Platform Blog were reviewed by InterSystems engineers team and are promoted by InterSystems product managers.Speaking about the high standard of technical and professional competence of engineers here in the community, I think votes, views and comments for the posts and answers can indicate the competence. I'm quite sure that there are a lot of engineers in InterSystems Developer Community (DC) who has high competence in InterSystems technology.We have plans to introduce some signs/badges here on DC, which will indicate competence in different parts of InterSystems technology and products upon their contribution to Developer Community.
go to post Evgeny Shvarov · Jun 28, 2016 Nice snippet, Eduard!I wonder what is the reason to calculate Package length?
go to post Evgeny Shvarov · Jun 23, 2016 You can buy MUMPS DBMS book by Evgeniy Karataev on this site if you want.Also there is another online book about Caché in Russian: "Модели и смыслы в Caché и Oracle" by Nikolay Bessarabov.And last year there were new book about InterSystems Caché on Ukranian: see the TOC by Irene Mikhailova and Vladimir Gaidarzhi
go to post Evgeny Shvarov · Jun 22, 2016 Hi, Rob! It would be better if you post the whole text of the solution here in Developer Community, instead of supplying the link only. I think this is the better approach to engage the discussion.
go to post Evgeny Shvarov · Jun 21, 2016 Copy-paste the current index from the previous post and add a new link to the previous post?
go to post Evgeny Shvarov · Jun 15, 2016 Yes. But what if Debug Target is not a Class method or Routine?In that case you can use locks or hang as Fabio suggested to catch the line and the moment and attach to the process with Studio.
go to post Evgeny Shvarov · Jun 15, 2016 I think the problem is that you use calculated measure for the measure with the same name - f.e. count.To solve this introduce the measure for Count with another name, f.e. CubeACount and use calculated measure to use this measure in the expression.Hope it helps.
go to post Evgeny Shvarov · Jun 14, 2016 I believe it should just work. Place CubeB.TotalClients in pivot based on CubeC and you'll get the CubeB.TotalClients for the facts in CubeB only.The idea of compound cubes is that you get pivot table with different measures from different fact tables sliced by same shared dimension.
go to post Evgeny Shvarov · Jun 14, 2016 It's not very clear. You want to use CubeB.TotalClients in CubeC compound cube?What this measure should show in CubeC?
go to post Evgeny Shvarov · Jun 11, 2016 The good option to share the source code of a standalone class or routine is to upload it to the Gist and share the link to the gist in your post. Post example. Gist example .
go to post Evgeny Shvarov · Jun 10, 2016 Hi, Mike!It works for me.Would you please send me your word-file to try?
go to post Evgeny Shvarov · Jun 8, 2016 Very nice Alexander!Will it work only for time dimensions with the help of %Timerange or I can use the similar approach for any type of dimensions?
go to post Evgeny Shvarov · Jun 8, 2016 It seems Alex Koblov suggested solution for this in this thread
go to post Evgeny Shvarov · Jun 8, 2016 Another option is:1.Get the MDX from pivot,2. Write the method which executes the MDX from p.1 and forms CSV file from the %DeepSee.ResultSet 3. If you want to get the CSV from the widget add Action control with call to your method from p.2 or Call to another CSP page which will call you p.2 method and download csv file.