Article Peter Steiwer · Mar 23, 2022 2m read InterSystems IRIS BI: Getting Started with Selective Build What is Selective Build? Selective Build is a BI feature in InterSystems IRIS (introduced in version 2020.1). Selective Build allows you to build specific elements of your cube while keeping your cube online. What is special about Selective Build? Before getting into the details of Selective Build, a brief recap of the different phases during a regular cube build is important. Here are the phases in a regular cube build:1) Delete existing data in cube2) Populate cube with full set of data3) Build all indices in the cube #InterSystems IRIS #InterSystems IRIS BI (DeepSee) 0 0 0 212
Question Peter Steiwer · Mar 10, 2022 How to show Generated classes in Visual Studio Code I want to be able to view generated items from visual studio code. In Studio there was an option in the open dialog: Specifically, I added a namespace to my workspace for editing (Using InterSystems Server Manager) and I want to be able to access the generated items in this namespace. #Development Environment #ObjectScript #InterSystems IRIS #VSCode 0 4 0 274
Announcement Peter Steiwer · Jun 14, 2021 Announcing Adaptive Analytics Sample Application! The release of InterSystems IRIS 2021.1 introduces Adaptive Analytics. To get started with a familiar InterSystems IRIS BI sample cube, we have created a HoleFoods Sample Application for Adaptive Analytics. This Sample Application is available on Open Exchange. There is also a learning services course available to learn more about Adaptive Analytics. #Analytics #InterSystems IRIS Open Exchange app 3 0 0 183
Question Peter Steiwer · Apr 9, 2021 VSCode "Go To Definition" opens in Read Only mode As the title says, when I use the "Go To Definition (F12)" option, it opens the definition in read only mode. Is there some way to either directly make the go to option editable or can i turn the read only version into an editable version? I end up needing to open the file directly and then manually going to the method definition myself. #Development Environment #VSCode #InterSystems IRIS 0 21 0 1,093
Article Peter Steiwer · Jun 26, 2020 1m read Use Third Party Charting Libraries Today In Your Analytics Dashboard! Now available on Open Exchange is a library of third party charts available to use within DeepSee/InterSystems IRIS BI dashboards. To start, simply download and install, select the new portlet as the widget type, then select the chart type that you desire. If you don't find the type of chart you are looking for, you can easily extend the portlet to implement your desired chart type. These new chart types can be used within existing dashboards or you can create new dashboards using them. #Analytics #Dashboards #JavaScript #Open Source #UI Development #Caché #InterSystems IRIS #InterSystems IRIS BI (DeepSee) Open Exchange app 4 0 0 671
Article Peter Steiwer · Mar 6, 2020 2m read InterSystems IRIS Business Intelligence: Building vs Synchronizing InterSystems IRIS Business Intelligence allows you to keep your cubes up to date in multiple ways. This article will cover building vs synchronizing. There are also ways to manually keep cubes up to date, but these are very special cases and almost always cubes are kept current by building or synchronizing. #Analytics #Best Practices #Cubes #Caché #InterSystems IRIS #InterSystems IRIS BI (DeepSee) 2 1 0 429
Discussion Peter Steiwer · Mar 5, 2020 Submitting Github Issue+Pull Request best practice What does everyone think about submitting an issue in a repository and then submitting a pull request to fix that issue. Is it an unnecessary step or does it give extra context and logging for the issue? I ask this because when I find a bug in an Open Exchange app, I always submit the Issue and then often submit a Pull Request to fix the issue. I think that if the repository owner doesn't like your suggested fix, it is helpful to have the issue around so that they can deny the pull request and potentially implement their own change for the issue. #Git #GitHub #Open Exchange #Other 0 2 0 217
Article Peter Steiwer · Mar 2, 2020 2m read SQL -99 error while viewing a listing This error is sometimes seen while viewing a listing in InterSystems IRIS Business Intelligence:ERROR #5540: SQLCODE: -99 Message: User <USERNAME> is not privileged for the operation (4) As the error suggests, this is due to a permission error. To figure out which permissions are missing/needed, we can take a look at the SQL query that is generated. We will use a query from SAMPLES as an example. #Analytics #Analyzer #Dashboards #Access control #Security #SQL #Tips & Tricks #InterSystems IRIS #InterSystems IRIS BI (DeepSee) #Worldwide Response Center (WRC) 1 0 0 454
Article Peter Steiwer · Feb 25, 2020 1m read InterSystems IRIS Business Intelligence Tips & Tricks: Preview Mode Preview Mode was added to InterSystems IRIS Business Intelligence to give designers a quick view of what their resulting Pivot Table will look like without needing to wait for the results to fully execute. This can be beneficial when designing pivot tables because if you are dragging and dropping elements to see how they look/work in your pivot table and seeing if they have the desired data. Since you are exploring and designing, you don't necessarily care about the results at the moment, but you would still like to see how your table looks with the changes you have made. #Analytics #Analyzer #MDX #Tips & Tricks #InterSystems IRIS #InterSystems IRIS BI (DeepSee) 2 0 0 325
Article Peter Steiwer · Jan 22, 2020 2m read Optimizing If-Else Statements for best performance Do you ever have the desire to optimize your code as much as possible?Do you have any cases where every nanosecond matters?Do you use If statements? This quick tip can help your code run slightly faster with no additional code. #Coding Guidelines #ObjectScript #Performance #Tips & Tricks #Caché #InterSystems IRIS 3 7 0 1,767