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 526
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 486
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 384
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 284
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 503
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 234
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 413
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 403
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 128
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 748
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.7K
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 897
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 568
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 213
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 323
Question Evgeny Shvarov · Jul 27, 2016 Add Tag Tips&Tricks discussion Hi, Community!We want to introduce tag Tips & tricks.It's not a snippet sometimes, but some small piece of best practice and useful experience. Please vote if you think it makes sense and we need this tag and we'll introduce it as the first level tag in taxonomy. #DC Feedback 4 1 0 148
Question Evgeny Shvarov · Jul 8, 2016 Top from the group SQL query in Caché Hi!There is interesting question in Stackoverflow.This query works for MS SQL: SELECT * FROM ( SELECT *, ROW_NUMBER() OVER (PARTITION BY client_id ORDER BY date_updated DESC) AS rn FROM client_address ) a WHERE a.rn = 1 There is one answer there, which solves the task: #SQL #Caché 2 5 0 2.2K
Question Evgeny Shvarov · Jun 23, 2016 How to extract the root in Caché properly Hi! Here is the question in Russian Forum regarding roots extracting. In Caché ObjectScript we use exponentiation operator (**) to raise an exponent to power. F.e. let's raise 3 to power of 3: USER> write 3**3 27 And we use the same operator to extract the root. USER> write 27**(1/3) 2.999999999999999963 And 2.999999999999999963 is not 3, obviously. How to extract roots properly in Caché ObjectScript? #Caché #ObjectScript 0 5 0 388
Question Evgeny Shvarov · May 30, 2016 Solution for T9 Spelling Problem in Caché ObjectScript Hi, Community! Last weekend we held the Final of InterSystems Contest on Caché, DeepSee and iKnow under the aegis of IT Planet Student Championship in Ekaterinburg. BTW, this year we had more than 1,400 participants in InterSystems Contest. #Caché #ObjectScript 3 20 0 1.2K
Question Evgeny Shvarov · May 12, 2016 Full series of dates in Time Dimensions in DeepSee Hi!Sometimes, especially when I work with Combined Cubes, I need to have all the dates in Date Dimension, not only members with rows in Fact table.Is there any way to switch it on? #InterSystems IRIS BI (DeepSee) 1 6 0 322