go to post Peter Steiwer · Jan 13 I tried this and it worked: Parameter TestParam = "Test"; Property TestCalc As %String [ SqlComputeCode = { Set {*} = ..#TestParam}, SqlComputed ]; [SQL]SAMPLES>>select * from DC.SQLCompute1. select * from DC.SQLCompute ID TestCalc1 Test
go to post Peter Steiwer · Jan 10 Here is a quick video about databases and namespaces that may help you get started with your plan for what is needed: https://learning.intersystems.com/course/view.php?id=1130
go to post Peter Steiwer · Oct 7, 2022 Hi Ahmad, These functions do not exist in MDX, please see the MDX function documentation here: https://docs.intersystems.com/iris20221/csp/docbook/Doc.View.cls?KEY=D2R... You likely want to use the %OR function: https://docs.intersystems.com/iris20221/csp/docbook/DocBook.UI.Page.cls?... Using %OR would allow you to reference multiple members, for example:Expression="%OR({[Demographics].[H10].[Citizenship].&[USA],[Demographics].[H10].[Citizenship].&[U.S.A],[Demographics].[H10].[Citizenship].&[US]})"
go to post Peter Steiwer · Sep 28, 2022 Hi Phillip, Specifically, Studio connects using the superserver port: https://docs.intersystems.com/iris20221/csp/docbook/Doc.View.cls?KEY=PAG... As Tom mentioned, you will need to determine which port this has been configured as
go to post Peter Steiwer · May 24, 2022 Hi Virat, Here is a good resource for getting started with InterSystems IRIS BI (DeepSee):https://learning.intersystems.com/course/view.php?id=1793 If you are interested in creating dashboards and exploring your data, IRIS BI is a good choice. If you are interested in traditional reporting, you may want to consider InterSystems Reports:https://learning.intersystems.com/course/view.php?id=1444
go to post Peter Steiwer · Mar 10, 2022 Thanks, this works. I did have to click the "+" icon and add a new namespace to the Explorer, since adding the namespace from InterSystems Server Manager did not pull it into the ObjectScript Explorer. This is kind of an unusual case since I don't necessarily have a project/workspace for the generated class I want to view. If I already had one, then I wouldn't need to use the namespace explorer.
