Question Evgeny Shvarov · Apr 5, 2017 How to get the measure for the last day in a month in DeepSee Hi, Community! How can I manage to show in MDX query months where every month shows the value of the last month? Say, in HoleFoods the query: SELECT NON EMPTY [Measures].[Amount Sold] ON 0,NON EMPTY [DateOfSale].[Actual].[MonthSold].Members ON 1 FROM [HOLEFOODS] will show me the sum of revenue per month. This query: #MDX #InterSystems IRIS BI (DeepSee) 0 11 0 2.2K
Question Evgeny Shvarov · Apr 1, 2017 Is there a way to rebuild indices for all the classes in a given namespace? I'm moving *D globals from DatabaseA to DatabalseB.After importing globals I need to rebuild indices for all the imported persistent classes.Colleagues, maybe you know one command which does it for all the classes in Namespace? #Continuous Integration #Development Environment #Object Data Model #SQL #Caché 0 2 0 814
Question Evgeny Shvarov · Apr 1, 2017 Is there an option to export globals in archive? Hi, Community! Is there an option to get an archived file of globals in one command. Say for: Do $System.OBJ.Export("Class1*D.GBL,Class2*D.GBL","data_gbl.xml") get something like: Do $System.OBJ.Export("Data*D.GBL","data_gbl.gz","gzip") And also to have the convenient one click way to import it to the namespace via terminal or Control Panel? If anyone already has this module, share please? It would be very convenient for import/export/continuous integration purposes cause globals can be really heavy. #Continuous Integration #Globals #Development Environment #Terminal #Caché 0 8 0 836
Question Evgeny Shvarov · Mar 13, 2017 How to filter two widgets in DeepSee New_Window command? Hi! There is a 'New_window' control in DeepSee Widget which opens the page in a new tab in a browser with a given URL. With the help of this control you can open another dashboard and supply some parameters in SETTINGS clause. Consider I can setup in Dash1 the URL like: #InterSystems IRIS BI (DeepSee) #Dashboards #UI Development 0 2 0 214
Question Evgeny Shvarov · Feb 26, 2017 Named filter in DeepSee Hi!There is an option to introduce Named filters in Analyser and save it with the pivot.How can I make the Named filter available in a dashboard? #InterSystems IRIS BI (DeepSee) #Dashboards 0 2 0 253
Question Evgeny Shvarov · Feb 25, 2017 How to add the case insensitive index to a class? Hi!Consider I have a class Package.Data with Property UniqueStringValue as %String.I introduced the Index for this property: Index ValueIndex on UniqueStringValue [Unique]; It works well. But if I try to check if there is an object with the certain value in code like this: if ##class(Package.Data).ValueIndexExists(value) this expression fails, if value="value", even if there is an instance with instance.UniqueStingValue="Value" How can I set the index to prevent saving case sensitive values in this class? #Indexing #Object Data Model #ObjectScript #Caché 0 6 0 514
Question Evgeny Shvarov · Feb 25, 2017 How to deploy resources and roles? Hi, Community!Consider I have ResourceA which is used by role RoleA in dev environment and want to deploy it with the solution on a target system.Would you please share the best practices to make it?Thank you in advance! #Deployment #DevOps #Security #Caché 0 8 0 481
Question Evgeny Shvarov · Feb 13, 2017 How to calculate the number of rows in DeepSee? Hi!How can I show a number of rows in a given DeepSee pivot? #InterSystems IRIS BI (DeepSee) #Analyzer #MDX 0 3 0 375
Question Evgeny Shvarov · Feb 12, 2017 Mandatory or queried filters for the dashboards Hi!There are DeepSee dashboards, which make sense only when filtered.Usually, they are used as Drill Target or New_window control with SETTINGS=Widget;FILTER=filtervalue.Is there a way to hide such dashboard from the Catalog or/and request the filter value once it is opened by User? #InterSystems IRIS BI (DeepSee) #Dashboards #Visualization 0 3 0 281
Question Evgeny Shvarov · Jan 24, 2017 How to calculate percentage of all for a member in DeepSee? Hi, All!What is the calculated measure expression for the percentage of a member?Say in Holefoods I want to see in a Cols Online sales in Revenue, All the revenue and % of Online sales for the Revenue?I have the following:With expression: #Analytics #Code Snippet #MDX #InterSystems IRIS BI (DeepSee) 0 5 0 488
Question Evgeny Shvarov · Jan 9, 2017 How to find dependencies of Dimension or Measure to the pivots? Hi!I want to optimize the cube and delete the measure. Is there any easy way to find pivots which use it?Does anyone have any snippet regarding this?Would be great to have "out of the box" dashboards which will show the dependencies of pivots vs measures and dimensions. #InterSystems IRIS BI (DeepSee) #Development Environment 0 1 0 233
Question Evgeny Shvarov · Dec 18, 2016 How to exclude substring(s) from a string Hi, community! Consider you need to exclude substring(s) from a string. I did it with the following snippet: /// excludes all the substrings from the string ClassMethod ExcludeSubstring(substr,str as %String) As %String { while ($L(str,substr)>1) { set str=$Piece(str,substr)_$Piece(str,substr,2,*) } quit str } So, for example: #Code Snippet #ObjectScript #Caché 0 2 0 410
Question Evgeny Shvarov · Dec 14, 2016 Intergity test for cbk files Hi, Community!We have our internal backup system which produces *.cbk files for Full, Incremental and Cumulative backup modes.Does anyone have an automation procedure to restore this files on some target testing system, check the integrity and mark the files as "restorable"?Please, share?Thank you in advance! #System Administration #Backup #Caché 0 2 0 397
Question Evgeny Shvarov · Nov 27, 2016 New tag for the tools for developers Hi!We want to introduce the tag for the posts which describe the tools for the developers. How about #DevTools?Your ideas? #DC Feedback 0 2 0 122
Question Evgeny Shvarov · Nov 22, 2016 Create Namespace snippet Does anyone have a snippet to create the Namespace and database with defaults in one command? Something like: do ##class(Utils.Namespace).Create(Name) Please share? Thank you in advance! #Code Snippet #Namespace #ObjectScript #Caché 1 4 0 742
Question Evgeny Shvarov · Nov 20, 2016 How to export class package in xml Hi!Is there any way to export a class package to xml file programmatically which will include all the classes of the package? #Change Management #Caché 1 12 0 1.6K
Question Evgeny Shvarov · Oct 28, 2016 Max function for the set of parameters There is an interesting discussion in the Russian forum going. What is the best solution for the function which returns the max for the set of parameters? From the listed solutions I like this one: ClassMethod max(args...) { for i=1:1:args { s max(+$g(args(i))) = i } s i="", max=$o(max(i),-1, i) Q $lb(max, i) } #ObjectScript #Caché 1 8 0 873
Question Evgeny Shvarov · Oct 18, 2016 Classes removing and renaming best practice with Atelier Hi!Suppose I have a project in Atelier with two classes: Class A and Class B and develop it in my local Caché installation. If I decide to delete Class A and delete it in Atelier project will it be deleted in Caché automatically or should I do it manually?Or what is the suggested workflow in this case?Same question is if I decide to rename Class B to Class C. #Change Management 1 4 0 562
Question Evgeny Shvarov · Sep 19, 2016 Tag for the newbies posts Hi, Community!We want to introduce tag for the posts, which are related to the newbies.What is the best tag for it?Newbie's corner?Newbie?Beginner?Your option? #DC Feedback 0 6 0 212
Question Evgeny Shvarov · Jul 28, 2016 Pivot variables deployment Hi!How do you guys deploy DeepSee pivot variables?Haven't found it in documentation.Thank you in advance! #InterSystems IRIS BI (DeepSee) 0 5 0 317