Question Ahmad Bukhtiar · Oct 6, 2022 MDX Syntax Help we have this container code where we want to create more CalcMember properties <sharedCalcMember FullName="HSAAPATIENT||DEMOGRAPHICS||CITIZENSHIP.NATIONAL.sharedCalcMember" Dimension="Demographics" Name="Citizenship.National" Expression="[Demographics].[H10].[Citizenship].&[USA]" SolveOrder="0" CubeName="HSAAPATIENT" UpperCaseDimension="DEMOGRAPHICS" UpperCaseName="CITIZENSHIP.NATIONAL"></sharedCalcMember> #Analytics #Cubes #MDX #HealthShare 0 3 0 184
Question Ahmad Bukhtiar · Jun 10, 2021 HealthShare UCR User Roles Hi anyone has created the user roles for UCR pls share details like if we want to create following roles what access rights should be give to each role. UCR Admin - This user can stop/start productions, can enable/disable services, can run sql queries, can make changes in facility registries, assigning authority and other configuration. UCR Developer - This user can add new services in the production but can not make any change in the registires and other configuraiton #Access control #System Administration #Ensemble #HealthShare 0 1 2 310
Question Ahmad Bukhtiar · Feb 25, 2021 How to use lookup function ignoring first 4 chars and do the match Hi I am using below function and it works fine but i want to match the value ignoring the first 4 chars as they are only added to sort the data. ##class(Ens.Rule.FunctionSet).Lookup For example My table has following values 0001EMRNameB 0002EMRNameA #Caché 0 3 0 248
Question Ahmad Bukhtiar · Jan 26, 2021 Facility Registry in HealthShare - What is best practice? Hi we are implementing HIE and wan to get expert opinion on facility registry setup. Below are some example and which method we should adapt. 3 EMRs sending u patient data (ADT, ORU etc) for 3 facility groups Facility Group A (Has 20 branches locations, same MRN across all branches, each branch is registered with health department) Facility Group B (Has 30 branches locations, same MRN across all branches, each branch is registered with health department) #Data Model #InterSystems Business Solutions and Architectures #HealthShare 1 1 0 453
Question Ahmad Bukhtiar · Jan 19, 2021 Handling carriage return in the HL7 router We have msgs coming like below where line ending with \n then it throw error in router production but if msgs come with \r\n then router dont throw error. any help? EMR sending following msg. MSH|^~&|APP|EMR|HIE|HIE|201301011226||ADT^A01|MSG00001|P|2.5|\nEVN|A01|201301011223||\ne Business Service read it like this as on line, and error msg shows in trace. MSH|^~&|APP|EMR|HIE|HIE|201301011226||ADT^A01|MSG00001|P|2.5|\nEVN|A01|201301011223||\n #HL7 #Ensemble #HealthShare 0 2 0 763
Question Ahmad Bukhtiar · Dec 5, 2020 How to know the storage of Edge Productions? and if storage size increased by 5% as compare to previous day we want to trigger email to system admin Hi, we suddenly noticed that one of the edge storage increased by 30% and it was due to ERROR globals which was throwing repeated error for 7 days and it consumed 35GB space. Is there a way to log the storage of edge production on daily basis and compare the increase in storage with previous day and if increase is 5% more than trigger an email to system admit to look why the storage increased suddenly. #Error Handling #Globals #System Administration #InterSystems IRIS 0 3 0 257
Question Ahmad Bukhtiar · Nov 29, 2020 create join query on the same table Hi I have a table where i want to create join query like (select * from patients where facility=abc) qry1 left join (select * from patients where facility=xyz) qry2 on qry1.patientid = qry2.patientid #SQL #Other 0 3 0 211
Question Ahmad Bukhtiar · Nov 26, 2020 Validate SDA before saving to ECR We have some code written by earlier team that read flat files data and create SDAs and push them to ECR Input Service. Now for every test cycle we have to load files to SDAs, check error log, fix the error, clear the ECR, and try new fixed flat files. I’d like to know if there is a method to validate SDA msgs prior to pushing to EFR Input operations ? so everything we simple load flat files, create SDAs and validate them. If files all looks good with no SDA errros then we actually load them to ECR only once. #HealthShare 0 3 0 358
Question Ahmad Bukhtiar · Nov 25, 2020 SearchTable fields can we add MSH.3 Sending Facility field? Hi can we add one additional field in this table ? #HealthShare 0 2 0 246
Question Ahmad Bukhtiar · Nov 23, 2020 Routing msg based on the port the msg is coming from We have 3 env. using different ports schemes Is there a way to create a rule if msg comes on ports starting 22 then route it to devoperation, if it starts with 33 then route to testoperation, if its 44 route to stageoperation? #Business Operation #Business Rules #Business Service #HealthShare 0 1 0 233
Question Ahmad Bukhtiar · Nov 22, 2020 Set property dynamically If I have table of 60 fields is there a way to add values to columns dynamically ? Fields are like this Field1, Field2, Field3...Field60 and I am reading data from flat files. I tried below code but it didn’t work #ObjectScript #Caché #InterSystems IRIS 1 3 0 484
Question Ahmad Bukhtiar · Nov 19, 2020 Help with string function reading data from files I have multiple files with different columns, first 9 values are fixed, so i want to ignore the first value, and next 8 values i want to combine into one value using ^ sign Current Format |||||||||||^^||||||^^||||||||||||||||||||||||||||^^||||^^||||||||||||||||||||||||||||||||||^^|||^^|||||||| Desired Format ^^^^^^|||^^||||||^^|||||||||||||||||^^^^^^|||^^||||^^|||||||||||||||||||||||^^^^^^|||^^|||^^|||||||| Reading each line from the file use below code. #Code Snippet #Coding Guidelines #Unstructured Data #Caché #Ensemble 0 11 0 812
Question Ahmad Bukhtiar · Nov 16, 2020 where to start to generate data quality report of hl7 msgs and report data issues back to facilities we are getting number of msgs from multiple facilities into our HIE solution, now which facilities is sending bad quality data and put some process around it to improve the msg quality so where to start to generate this report, any guidance would be appreciated. #Object Data Model #Health Connect #HealthShare 0 1 0 228
Question Ahmad Bukhtiar · Nov 16, 2020 is there healthshare installation for one user for learning Hi is there healthshare insallable for one user where one can create edge production, follow exercises to customize clinical viewer, create data loading routines takeing data from flat file and push data to ECR. Community version for IRIS for health does not have options to create edges and there is no clinical viewe #HealthShare 0 2 0 410
Question Ahmad Bukhtiar · Nov 15, 2020 Sorting Charts on Clinical Viewer hi is there is way to change the order of the charts available in the clinical viewer as client asking to change the order keep more used charts at the begining and others chart move to end . Is it possible. #HealthShare 0 1 0 185
Question Ahmad Bukhtiar · Nov 12, 2020 is there a command to delete patient from Edge Production Hi We have Edge Production where we uploading flat files clinical data, and during testing we do this for several rounds load data, test them and reload them. So everytime we have to generate differnet patient data or change MRNs etc. So request is is there a command to delete patient records that will remove from the tables, and delete reference in the registery as well. Any guidance that you follow for testing backload data and delete loaded data, pls share #Databases #Data Import and Export #HealthShare 0 1 0 527
Question Ahmad Bukhtiar · Oct 19, 2020 how to create sql query across namespaces? Hi We have multiple edge production namespaces and want to run query to get errors/alerts from Ens_Util.Log table across namespaces. is it possible? #Error Handling #Namespace #SQL #Ensemble #HealthShare 0 4 1 774
Question Ahmad Bukhtiar · Sep 23, 2020 Using NOTIN and Lookup in the method Any syntax help, i want to check different msg types and then reach out to the value in that particular segment. Here is example, i want to get SSNNumber from a method. Trying to use NOTIN, and Lookup Class Training.RulesFunctionSet Extends Ens.Rule.FunctionSet { #Business Rules #Coding Guidelines #HL7 #Message Search #Caché #HealthShare 0 5 0 520
Question Ahmad Bukhtiar · Sep 1, 2020 Router Business Rule, I want to check PID:7 DOB field and if date is within 3 days then I want to send HL7 to NewBornOperation Hi I have a use case where for new born I want to send HL7 messages to different business operation. I created the business rule but in condition I am struggling to put syntax something similar to this HL7.{PID:7} >= Today Date -3 any help would be appreciated. #Business Rules #Ensemble #HealthShare 0 5 0 435
Question Ahmad Bukhtiar · Sep 1, 2020 Run All Business Rules in Router & Combine Results Hi We have several rules in router to validate HL7 messages, each rule check a particular field in HL7 message and send back response. We want to run all rules and combine the rules responses into some variable/object and at the end if variable/object is empty it means message is valid, else send the value from this variable/object. This way one message we dont run it again and again, and we can send one message and response will give us combine results from all rules. For example, Rule 1 - Check MSH.12 field, Send response "MSH.12 value not valid", and RETURN #Business Rules #HL7 #Ensemble #HealthShare 0 3 0 283