go to post Evgeny Shvarov · May 30, 2016 Alexander Koblov, thank you for such interesting problem for the Contest Final. Your variant? ;)
go to post Evgeny Shvarov · May 29, 2016 Hi, Rob! What are the benefits of using ewd-document-store abstraction?
go to post Evgeny Shvarov · May 25, 2016 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.
go to post Evgeny Shvarov · May 25, 2016 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.
go to post Evgeny Shvarov · May 24, 2016 Hi, Amir!Have you looked at the recent article from Alexander Koblov related to collations? I hope it has some answers on this topic.
go to post Evgeny Shvarov · May 24, 2016 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. Download Installer.cls.xml (from MDX2JSON folder in repository or releases page) and import it into any namespace)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()
go to post Evgeny Shvarov · May 23, 2016 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.
go to post Evgeny Shvarov · May 23, 2016 Hi, Rich!Please have a look at this example, which shows US States polygons on DeepSee Google map.
go to post Evgeny Shvarov · May 23, 2016 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 ReferenceAnd you can buy any book about InterSystems Caché, or just ask Mike - he is the author of two books about InterSystems Caché.
go to post Evgeny Shvarov · May 22, 2016 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.
go to post Evgeny Shvarov · May 17, 2016 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?
go to post Evgeny Shvarov · May 16, 2016 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?
go to post Evgeny Shvarov · May 16, 2016 Thank you Alex! That is exactly I'm looking for!What Caché version starts supporting this?
go to post Evgeny Shvarov · May 16, 2016 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.
go to post Evgeny Shvarov · May 15, 2016 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
go to post Evgeny Shvarov · May 13, 2016 Hi! You can make it with ParallelPeriod keyword. F.e. let's take sales in Samples for the Holefoods cube. To show YearToYear monthly growth in percent add in the pivot calculated measure "YTY growth" with expression: (DateOfSale.CurrentMember-ParallelPeriod(DateofSale.YearSold,1,DateOfSale.CurrentMember))/ParallelPeriod(DateofSale.YearSold,1,DateOfSale.CurrentMember) And format: ##.##% How to use it. Place months in a pivot in Rows. Add YTY Calculated Measure to Cols. And add any Measure you want to compare into Measures, f.e. Revenue. You'll get following MDX: WITH MEMBER [DateOfSale].[SelectedYear] AS '[DateOfSale].[Actual].[YearSold].$VARIABLE.Year' MEMBER [MEASURES].[YTY growth] AS '(DateOfSale.CurrentMember-ParallelPeriod(DateofSale.YearSold,1,DateOfSale.CurrentMember))/ParallelPeriod(DateofSale.YearSold,1,DateOfSale.CurrentMember)',FORMAT_STRING='###.##%' SELECT NON EMPTY {[Measures].[%COUNT],[MEASURES].[YTY GROWTH]} ON 0,NON EMPTY [DateOfSale].[Actual].[MonthSold].Members ON 1 FROM [HoleFoods] See the result: And here are 2011 and 2010 together to prove the measure above works properly: Hope that helps.
go to post Evgeny Shvarov · May 13, 2016 Hi!You can make it with ParallelPeriod keyword.F.e. let's take sales in Samples for the Holefoods cube.To show YearToYear monthly growth in percent add in the pivot calculated measure "YTY growth" with expression:(DateOfSale.CurrentMember-ParallelPeriod(DateofSale.YearSold,1,DateOfSale.CurrentMember))/ParallelPeriod(DateofSale.YearSold,1,DateOfSale.CurrentMember)And format: ##.##%How to use it. Place months in a pivot in Rows. Add YTY Calculated Measure to Cols. And add any Measure you want to compare into Measures, f.e. Revenue. You'll get following MDX: WITH MEMBER [DateOfSale].[SelectedYear] AS '[DateOfSale].[Actual].[YearSold].$VARIABLE.Year' MEMBER [MEASURES].[YTY growth] AS '(DateOfSale.CurrentMember-ParallelPeriod(DateofSale.YearSold,1,DateOfSale.CurrentMember))/ParallelPeriod(DateofSale.YearSold,1,DateOfSale.CurrentMember)',FORMAT_STRING='###.##%' SELECT NON EMPTY {[Measures].[%COUNT],[MEASURES].[YTY GROWTH]} ON 0,NON EMPTY [DateOfSale].[Actual].[MonthSold].Members ON 1 FROM [HoleFoods]See the result:And here are 2011 and 2010 together to prove the measure above works properly:Hope it helps.
