Article Stephen Canzano · Jun 28 3m read Analytics Cube Definitions and References Maybe this is well known but wanted to help share. Consider that you have the following persistent class defintions An Invoice Class with a property reference to Provider #Analytics #Cubes #Data Model #MDX #SQL #Tips & Tricks #InterSystems IRIS BI (DeepSee) 0 0 0 20
Discussion Stephen Canzano · Jul 19, 2021 System Explorer->SQL->Show Plan When I'm asked questions about SQL, I like Intersystems staff at the WRC, generally ask about the Query Plan. My feeling is that even before you run a query you should examine the results of Show Plan to confirm that the code is going to give me the results in the manner I would expect. If I expect it to leverage an index and I see that it is not then I go back and look at what I might have done incorrectly and try to re-write the query to get the index behavior I'm looking for. To that end, there's a poll below to ask you if think moving the Show Plan button as the first button would be #SQL #Caché #HealthShare #InterSystems IRIS 0 0 0 178
Question Stephen Canzano · Jul 14, 2016 More than 1 Listing for a KPI I have a DeepSee KPI defined based on %DeepSee.KPI following the documentation http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=.... I've then enabled the KPI on a dashboard by adding a Widget where the data source is the KPI. Currently the ability to show a Detail Listing is implemented by the call back %OnGetListingSQL. This method documents the parameter #Dashboards #InterSystems IRIS BI (DeepSee) 1 2 0 363
Question Stephen Canzano · Apr 13, 2016 XMLExport and Validation I interested on how others feel on this subject. In general terms when you have a class that extends from %XML.Adaptor and you call XMLExport no validation is automatically done as part of the XMLExport process. As an example if you do the following #XML #Caché 1 3 0 755