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.
go to post Evgeny Shvarov · May 11, 2016 Mark, thank you, that's useful!I use also $T command in terminal, which shows the line with bug, like:USER> w $T(Method+7^Package.Class.1)
go to post Evgeny Shvarov · May 10, 2016 Yes, at least these cases. And what is the general approach with your type of installation to show the user:What's happened?Were there any errors during installation?
go to post Evgeny Shvarov · May 9, 2016 Great article, Nikita! What is the general approach in your case to show/save logs of what was installed? Of course, I can open Package.Installer class to see what should have happened during installation, but I think it is good to know what really happened with the target system.
go to post Evgeny Shvarov · May 9, 2016 Hi, Scott!Have you seen Activity Monitor? There was a post about it.
go to post Evgeny Shvarov · May 9, 2016 Hi, Murray!Nikita.Savchenko posted longread about Class Projection with examples of real projects using it ;)
go to post Evgeny Shvarov · May 7, 2016 To highlight the code you also can simply go into post's html source (press source button or "disable rich text") and insert your code between pre and code tags, like it is shown in the shot
