go to post Evgeny Shvarov · Apr 9, 2017 Hi, Alessandro! Let me simplify the question reducing the results as possible: For this month MDX query: SELECT NON EMPTY [Measures].[Amount Sold] ON 0,NON EMPTY [DateOfSale].[Actual].[MonthSold].&[201101] ON 1 FROM [HOLEFOODS] I have: But I want to see not 11,568.43, but the revenue got in the last day sale of January, like what I have for a day query: SELECT NON EMPTY [Measures].[Amount Sold] ON 0,NON EMPTY [DateOfSale].[Actual].[DaySold].&[62122] ON 1 FROM [HOLEFOODS] So I need the last available values for days but in a scope of months. Is it clearer now? If you ask me why do I need that, it's much more evident with the example of stocks trading. Consider you have a database of transactions of stocks trading for every day and you want to show in DeepSee the history of the price for some share the months' scale. You would definitely want to use for the value of the price of the month the price of the last trading day of the month. Makes sense? How to manage this in DeepSee? So I tried to put it in the scope of HoleFoods.
go to post Evgeny Shvarov · Apr 7, 2017 Hi, Fab!Speaking about the low number: do you have any idea of how high/low is the number?I can name 100+ addons in my scope. It is low number, but I'm quite sure it's not all the available modules.
go to post Evgeny Shvarov · Apr 6, 2017 The blank scores in a widget - it's a bug, no doubts. Thanks!
go to post Evgeny Shvarov · Apr 6, 2017 Hi, John!It's a kind of manual pool of Top stories which we fill from time to time with articles valuable for us.Drupal engine rotates it via some algorithm.
go to post Evgeny Shvarov · Apr 6, 2017 Hi, Alessandro!I tried that, it shows no value in my Analyzer. Version 2016.2
go to post Evgeny Shvarov · Apr 6, 2017 Hi, Ashok!Maybe it's offtopic, but have you seen the MDX2JSON project?
go to post Evgeny Shvarov · Apr 4, 2017 Hi, Alexandr!If you mean "System" as starting with "%" you can use the following:SET NAME="" F SET NAME=$ORDER(^$GLOBAL(NAME)) QUIT:NAME="" DO:($E(Name)'="%")
go to post Evgeny Shvarov · Apr 2, 2017 Thanks, Kyle! Speaking of assumptions, should I filter the mapped classes as well?
go to post Evgeny Shvarov · Apr 1, 2017 Finally, have the following for globals export/import in gzip: // export gbl set gbl="foo*D.GBL,boo*D.GBL" set s=##class(%Stream.FileBinaryGzip).%New() do s.LinkToFile("1.xml.gz") do $System.OBJ.ExportToStream(gbl,s) do s.%Save() kill s // gbl import set s=##class(%Stream.FileBinaryGzip).%New() do s.LinkToFile("1.xml.gz") do $System.OBJ.LoadStream(s) kill s
go to post Evgeny Shvarov · Apr 1, 2017 kill ^dbg BTW, kill ^dbg is not mandatory here, cause import from XML format everytime kills the global first.
go to post Evgeny Shvarov · Apr 1, 2017 Thanks, Sean, Ed, Alexey!That works perfectly! Ed, please add a dot to s in ExportToStream?I'm using it in one line, and think would add in some "Dev.Utils" class to make it shorter.
