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.
go to post Evgeny Shvarov · Jun 6, 2016 One more solution from Russian forum: ClassMethod gluconatV2(x) As %String [ ProcedureBlock = 1 ] { s y="" f i=1:1:$l(x){s c=$e(x,i),a=$a(c)-97-(c]"r")-(c]"y"),z=c]" ",d=a\3+2*z s:d=$e(y,*) y=y_" " f j=0:1:a#3+("sz"[c)*z s y=y_d} q y } And one "extremum" version: ClassMethod ToPhone( t, a = "(t){s s="" f i=1:1:$l(t) {f N=0:1:3 s n=$f(""adgjmptw "",$c($a($e(t,i))-N)) s:n n=n#10,s=s_$e("" "",s_-1[(n_-1))_$e(n_n_n_n,1,N+1),N=9} q s}") As %String [ CodeMode = expression ] { $xecute(a,t) }
go to post Evgeny Shvarov · Jun 3, 2016 Hi, Asaf!Yes, you are right - Compound Cubes!In any case, I believe that giving the option (in Architect and Studio), to mark a date dimension to include all dates (or a range of years), would be a good enhancement to DeepSee.That would be great!
go to post Evgeny Shvarov · Jun 2, 2016 Luca, thank you! And thanks for the following and retweeting!
go to post Evgeny Shvarov · Jun 2, 2016 Good news, thanks!My question was because importing smth to %SYS needs temporary write permission to CACHELIB database to be turned on and everything installed in %SYS will be erased with the next Caché update.
go to post Evgeny Shvarov · May 31, 2016 One more variant from Russian forum: p(t) { s R="" f %=1:1:$l(t) f N=0:1:3 s n=$f("adgjmptw ",$c($a($e(t,%))-N)) s:n n=n#10,R=R_$e(" ",$e(R,*)=n)_$e(n*1111,1,N+1),N=9 } 132 symbols.
