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.
Here is the case, when you probably will need at least two web apps for DeepSee REST API.
Consider you want some data to be accessed with authorisation and you provide this access with /webapp1 which is set up with authorisation by password.
And maybe you want some data to be accessible for everyone - you can do it with /webapp2 with option for UnknownUser.
Hi, Amir!
Have you looked at the recent article from Alexander Koblov related to collations? I hope it has some answers on this topic.
No, you don't need gulp to use it. Gulp is used to make releases.
To use it on your server do following:
Install MDX2JSON first.
Run in terminal (import namespace) under user with %All role:
Do ##class(MDX2JSON.Installer).setup()It will create MDX2JSON Namespace, will create /MDX2JSON webapp, make MDX2JSON package mapping to %All.
Check server:port/MDX2JSON/Test that installation was successful.
Then download the recent DSWeb release and install it.
How to install: download installer. Import it to any Namespace (f.e. User).
Run:
d ##class(DSW.Installer).setup()It will create webapp, folder and will install the client.
To update DSW, run:
d ##class(DSW.Installer).update()Another option is DeepSeeWeb with MDX2JSON tool.
Here is the online demo of USMap built with DeepSee and DeepSeeWeb viewer, via MDX2JSON REST API.
Here is the screenshot from the demo.
Hi, Petr!
I can advise you to pass through InterSystems Getting Started online courses.
Also Caché Programming Orientation guide can be useful.
A lot of people also find useful Caché ObjectScript Quick Reference
And you can buy any book about InterSystems Caché, or just ask Mike - he is the author of two books about InterSystems Caché.
Cannot make an answer on my own question.
Anyway, here are some answers from Russian forum:
DbVisualizer and Caché Monitor can export/import InterSystems Caché data partially via SQL queries.
There is also %Global class wrapper for %GI, %GIF,..etc routines which can help to export/import global nodes partially. Documentation.
Oh. I wanted to use this for Combined Cubes to have shared Date dimension with all the dates. It seems it will not help me, though maybe helpful thing in a lot of other cases. Is there any kind of setting in Architect to introduce all the dates in Dimension>
Unless I should create entries in fact table for all the days even there were no facts in this days for both cubes. Right?
If you want just 2012, exclude 2011 from the filter - it will still show the percentage for 2012 related to 2011.
Or maybe I didn't get what pivot do you want?
Thank you Alex! That is exactly I'm looking for!
What Caché version starts supporting this?
Thank you, Mark, good to know.