Topic outline

• InterSystems IRIS Business Intelligence: Architect

  InterSystems IRIS Business Intelligence: Architect

  Content Type
  Video

  Duration
  20m

  Level
  Intermediate

  Get a basic overview of using InterSystems IRIS® Business Intelligence to create cubes. See how to add essential features of cubes—such as measures and dimensions—and complex features such as hierarchies. You will also learn how to modify classes using compatible code editing software.

  The first video provides an overview of using InterSystems IRIS® Business Intelligence to create cubes. See how to add essential features of cubes—such as measures and dimensions—and complex features such as hierarchies. You will also learn how to modify classes using compatible code editing software.

  The second video shows how to create advanced cubes using hierarchies and collection properties. It also demonstrates how to add time levels and access other classes using Visual Studio Code.

  Note:

  These videos are a companion to the five-day Using InterSystems Embedded Analytics classroom course and serve as a review of concepts presented in the course.
• Architect Basics

  Architect Basics

  Review essential Architect tools for creating and editing cubes. See how to add dimensions, measures, and lists to cubes, and get a quick look at the Analyzer tool for verifying the data in a model.

  
  

  • Code Used in the "Architect Basics" Video

    Reference	Timestamp	Code
    Format string for AVG Age to include two decimals	2:31	#.##
    Display doctor name from source	4:41	%source.PrimaryCarePhysician.LastName_", "_%source.PrimaryCarePhysician.FirstName
    Add zero to all values less than 10 and allow sorting in the age dimension	6:28	$CASE($LENGTH(%source.Age),:%source.Age,:"0"_%source.Age)
    Join patient data with care provider names	8:20	select patientid, age,testscore,homecity->name as "City", primarycarephysician->lastname as "Doctor" from BI_Study.Patient

• Architect Advanced

  Architect Advanced

  Learn the steps for creating advanced cubes using hierarchies and collection properties. Then, see how to add time levels and access other classes using Visual Studio Code.

  • Code Used in The "Architect Advanced" Video

    Reference	Timestamp	Code
    Create allergy dimension from the cube class	4:15	##class(Mycube.Cube).GetAllergies(%source.%ID)
    Add GetAllergies class method	4:33	Begin code: Class Method GetAllergies(ID As %Numeric) As %List { Set allergies=##class(BI.Study.Patient).%OpenID(ID,0).Allergies If (allergies.Count()=0) {Quit $LISTFROMSTRING("")} Set list="" For I=1:1:allergies.Count() { Set $LI(lists)=allergies.GetAt(i).Allergen.Description } Quit list } End code
    Add AllergyCount measure	5:12	##class(Tutorial.Cube).GetAllergyCount(%source.%ID)
    Add AllergyCount class method	5:23	Begin code: ClassMethod GetAllergyCount(ID As %Numeric) As %Numeric { Set allergies=##class(BI.Study.Patient).%OpenId(ID,0).Allergies Quit allergies.Count() } End code
    Open IRIS session in the Terminal	5:44	irissession iris
    Change to Samples namespace	5:47	zn "Samples"
    Build cube	5:52	Do ##class(%Deepsee.Utils).BuildCube(YourCubeName)
    Modify GetAllergyCount() method to add a zero for nil known allergies	7:03	Begin code: ClassMethod GetAllergyCount(ID As %Numeric) As %Numeric { Set allergies=##class(BI.Study.Patient).%OpenId(ID,0).Allergies If allergies.Count()=0 { Set allcount="" } Elseif ((allergies.Count()=10) && (allergies.GetAt(1).Allergen.Code="000")) { Set allcount=0 } Else { Set allcount=allergies.Count() } Quit allergies.Count() } End code
    Create Age Bucket level	8:35	##class(BI.Model.PatientsCube).GetAgeBucket(%source.Age)
    Add AgeBucket class method that takes all ages from the cube and returns the name of the range	8:40	Begin code: ClassMethod GetAgeBucket(age As %Numeric) As %String { If (age="") {Set return=""} Elseif (age<10) {Set return="0 to 9"} Elseif (age<20) {Set return="10 to 19"} Elseif (age<30) {Set return="20 to 29"} Elseif (age<40) {Set return="30 to 39"} Elseif (age<50) {Set return="40 to 49"} Elseif (age<60) {Set return="50 to 59"} Elseif (age<70) {Set return="60 to 69"} Elseif (age<80) {Set return="70 to 79"} Elseif (age>=80) {Set return="80+"} Else {Set return=""} Quit return } End code
    Find favorite color of a specific patient	9:40	SELECT FavoriteColor FROM BI_Study.PatientDetails WHERE PatientID='SUBJ_100301'
    Add GetFavoriteColor class method	9:53	Begin code: ClassMethod GetFavoriteColor(patientID As %String) As %String { &sql(SELECT FavoriteColor INTO :ReturnValue FROM BI_Study.PatientDetails WHERE PatientID=:patientID) If (SQLCODE'=0) { Set ReturnValue="" } Quit ReturnValue } End code
    Add Favorite Color dimension	10:10	##class(MyCube.Cube).GetFavoriteColor(%source.PatientID)

• Share Your Feedback!

  Share Your Feedback!