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.
go to post Evgeny Shvarov · May 12, 2016 And since Yesterday here is new fashion way to make links to documentation ;)
go to post Evgeny Shvarov · May 12, 2016 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.
go to post Evgeny Shvarov · May 12, 2016 Agreed. Will fix it. Anyway, you are very welcome to add your version of the simplest ever file management snippet ;)
go to post Evgeny Shvarov · May 12, 2016 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?
go to post Evgeny Shvarov · May 12, 2016 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.
