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
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.
Copy-paste the current index from the previous post and add a new link to the previous post?
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.
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.
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.
It's not very clear. You want to use CubeB.TotalClients in CubeC compound cube?
What this measure should show in CubeC?
Hi, Mike!
It works for me.
Would you please send me your word-file to try?
What is the browser?
Try Chrome, Firefox or Safari?
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?
Another option is:
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.
Yes, but it is very smart and interesting though
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)
}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!
Luca, thank you! And thanks for the following and retweeting!
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.
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.
Joe! Would you please describe how can the Listing Groups be deployed?
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.
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?
Hi, Joe!
Thanks for the article!
Is it possible to use one Listing Group for several cubes?
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.
And would you please provide "readable" version too just to see the algorithm better? TIA!
Proof in gist?
Or, let's open and share proofs tomorrow!
Alexander Koblov, thank you for such interesting problem for the Contest Final. Your variant? ;)
Hi, Rob! What are the benefits of using ewd-document-store abstraction?
Added Healthshare tag. Thank you John.
I've added couple updates to the dashboard - so it now supports click filter for the counties too. Click on the county to see it's data in the indicator widget on the right.