go to post Michael Braam · Jun 3, 2019 Great! I already used it in a project and it made my life much easier
go to post Michael Braam · Apr 25, 2018 d01b_interchange.zipHere it is. Use it at your own risk.Michael
go to post Michael Braam · Apr 25, 2018 If you still need the SEF-files, please let me kniw your e-mail address and I can send it to you too.
go to post Michael Braam · Apr 25, 2018 Please let me know your e-mail address and I can send the files.Michael
go to post Michael Braam · Feb 2, 2018 Hi Jose,I can provide a SEF file for D01B to you. But please note, I haven't used it myself and it is not an official InterSystems product. Use is at your own risk. My customer typically use D96A.I have attached it to this answer.Hope this helpsMichael
go to post Michael Braam · Jul 18, 2017 You need to wrap it into a classmethod which is exposed as a stored procedure as in the example below: Class DC.Utils [ Abstract ]{ClassMethod AESBCEncrypt(pPlainText As %String,pKey As %String) As %String [ SqlProc ]{return $system.Encryption.AESCBCEncrypt(pPlainText, pKey)}} Once you have done this, you can use something like:update sample.person (Name) values (DC.Utils_AESBCEncrypt(name,'key'))
go to post Michael Braam · Feb 27, 2017 Mmmh, I'm lazy too ;-)What I did here is use the capabilty of indices on collections. But in my class the lastname isn't really a collection. That's why you have to implement the BuildValueArray method. It should be possible to create a method generator who generates the code neccessary to do all the indexing. What do you think?
go to post Michael Braam · Feb 27, 2017 You should use Caché security features to prevent unauthorized access to the index global and the code etc. I didn't use a standard hash like SHA-1 or SHA-256 and used a "salted" hash to make it harder to use standard rainbow tables.I didn't claim that it is 100% safe. As long as you get access to the hashes and the MakeSearchField function there is a potential risk.
go to post Michael Braam · Feb 27, 2017 Dan,creating a datatype might make encryption/decryption more convenient. But what if you want to search AND want to use indices to speed up the search? What do you index, the plain-text? The encrypted values are not suitable for indexing.
go to post Michael Braam · Feb 7, 2017 Hi Marcel,I have one. I'll send it to you in a separate mail.Haven't tried it. My customer usually use 96A.Regards,Michael
go to post Michael Braam · Feb 3, 2017 There is PERFMON and the Line-By-Line Monitor which you can use to analyze your routines. With PERFMON you can identify the most busy and expensive ROUTINES and you can then analyze a specific routine in detail.Here are the links to the docs:http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...Hope this helps.-Michael
go to post Michael Braam · Jan 25, 2017 Hi Evgeny,you can add a context parameter to the MDX exression. It an be filters, rows or columns. So if I change my code to:[Measures].[Amount Sold]/%MDX("select [Measures].[Amount Sold] on 1 from holefoods","%CONTEXT","columns") it gives me the follwoing result:Does this help?Michael
go to post Michael Braam · Jan 24, 2017 Evgeny,for these purposes I use a calculated measure. The MDX-expression for the measure looks like this:[Measures].[Amount Sold]/%MDX("select [Measures].[Amount Sold] on 1 from holefoods")My complete MDX is:SELECT {[Measures].[Amount Sold],[MEASURES].[Percentage]} ON 0,NON EMPTY [Channel].[H1].[Channel Name].Members ON 1 FROM [HOLEFOODS]Hope this helps.-Michael
go to post Michael Braam · Dec 28, 2016 All you need to do is, to specify the property name/sql field name in the select-list of your query.
go to post Michael Braam · Jul 22, 2016 You have a couple of choices.Either use the built in function $zhex or %SYSTEM.Utils.HexToDecimal or %SYSTEM.Utils.DecimalToHex.See the documentation for detailsHope this helps.
