All
Accepted answers
Evgeny Shvarov · May 12, 2016 go to post

Yes) Timur already answered. This snippet is not very general "read from file" snippet - but snippet to parse "russian-like" csvs) But every time when I work with text files line by line I use it. 

Evgeny Shvarov · May 12, 2016 go to post

Didn't get it. You mean I should change the description for the snippet?

Or to change the snippet to make it less "csv" specific?

Evgeny Shvarov · May 12, 2016 go to post

Agreed. Will fix it. Anyway, you are very welcome to add your version of the simplest ever file management snippet ;)

Evgeny Shvarov · May 12, 2016 go to post

Oh, thanks for this! I think it worth to make a separate snippet posting how to use the record mapper. Haven't found it in the documentation.

Evgeny Shvarov · May 15, 2016 go to post

One more optimisation. This:

Set list = $ListFromString(string,",") 
Set pointer = 0 
While $ListNext(list,pointer,piece) 
 { //Do something with piece... 
 }

Can be changed to:

Set list = $ListFromString(string,",") 
Set pointer = 0 
For   { 
 quit:'$ListNext(list,pointer,piece) 
 //Do something with piece... 
 }

Which is faster, as 'for' is generally faster than 'while'.

Took from Russian Caché forum

Evgeny Shvarov · May 16, 2016 go to post

Mike, if you don't like it - you don't use it. 

You'll not miss any DC content if you just subscribe for every post and comment in subscription settings.

DC Twitter is intended to increase the audience for DC highlights. 

Write valuable topic and it will be tweeted on DC Twitter.

Evgeny Shvarov · May 16, 2016 go to post

Thank you Alex! That is exactly I'm looking for!

What Caché version starts supporting this?

Evgeny Shvarov · May 16, 2016 go to post

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?

Evgeny Shvarov · May 17, 2016 go to post

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?

Evgeny Shvarov · May 24, 2016 go to post

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.

  1. Download Installer.cls.xml (from MDX2JSON folder in repository or releases page) and import it into any namespace)

  2. 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()
Evgeny Shvarov · May 25, 2016 go to post

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.

Evgeny Shvarov · May 30, 2016 go to post

Alexander Koblov, thank you for such interesting problem for the Contest Final. Your variant? ;)

Evgeny Shvarov · May 30, 2016 go to post

And would you please provide "readable" version too just to see the algorithm better? TIA!

Evgeny Shvarov · May 30, 2016 go to post

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.

Evgeny Shvarov · May 30, 2016 go to post

Hi, Joe!

Thanks for the article!

Is it possible to use one Listing Group for several cubes?

Evgeny Shvarov · May 31, 2016 go to post

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?

Evgeny Shvarov · May 31, 2016 go to post

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.

Evgeny Shvarov · Jun 2, 2016 go to post

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.

Evgeny Shvarov · Jun 3, 2016 go to post

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!