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.
go to post Evgeny Shvarov · May 31, 2016 Joe! Would you please describe how can the Listing Groups be deployed?
go to post Evgeny Shvarov · May 31, 2016 Hi, Dan!Have you seen this conversation?There is USA map in DeepSee Web which shows how you can tie any data to polygons and color it according to the data value.
go to post Evgeny Shvarov · May 31, 2016 Thank you for this great tool, Tony!One question: is it possible instead of importing into %SYS, import to OTHERNAMESPACE and map the package to %All?
go to post Evgeny Shvarov · May 30, 2016 Hi, Joe!Thanks for the article!Is it possible to use one Listing Group for several cubes?
go to post Evgeny Shvarov · May 30, 2016 Personally, I think looking at different ways of doing the same thing are a great learning lesson. Judging based on the length of the code, simply encourages bad programming.Agreed. So I think is good to provide two versions: readable and the shortest.
go to post Evgeny Shvarov · May 30, 2016 And would you please provide "readable" version too just to see the algorithm better? TIA!
