Question José Pereira · Sep 3, 2024 Autocommit pandas dataframe rows into IRIS Hi, I'm getting an unexpected behavior when using pandas function to_sql(), which uses sqlalchemy-iris. After the first execution, a transaction seems to be opened and all rows inserted are lost after closing the connection: #Python #InterSystems IRIS 0 2 0 89
Question José Pereira · Dec 11, 2022 Can't get a valid access token in FHIR Server with OAuth2 Hi! I'm playing with OAuth2 with FHIR Server, but returned tokens cause 401 or 403 errors when trying to get FHIR resources. I tried using fhir-client.js and Postman. Access tokens returned have been failing for both, with a 401 when trying through fhir-client.js and a 403 using Postman. Here are my settings: #FHIR #OAuth2 #InterSystems IRIS for Health 0 0 0 351
Question José Pereira · Apr 7, 2022 Inserting an index without reconstruction Hi! I'd like to know if there are any issues if an index is inserted into a table without running the %BuildIndices() method. It's important to note that data inserted before the index is not important for retrieval, so it's not a problem data inserted before the index don't show up in queries. The reason why I'm asking this is that I'd like to avoid index reconstruction on big tables which I need to inser such index. I'm using Cache 2018.1. Thanks, José #Databases #Indexing #SQL #Caché 0 8 0 322
Question José Pereira · Aug 4, 2021 Cross Validation in IntegratedML Hi! I'd like to know if the VALIDATE MODEL statement in IntegratedML performs a cross validation (CV) procedure internally. If it doesn't, is there a ready to use method for CV? Thanks! #IntegratedML #InterSystems IRIS 0 2 0 198
Question José Pereira · Jun 24, 2021 How to get feature importance in IntegratedML models? Hi! I'd like to know how to get feature importance after creating and training a model, using IntegratedML with AutoML provider? Thanks! #IntegratedML #Machine Learning (ML) #InterSystems IRIS 1 2 0 222
Question José Pereira · Oct 2, 2020 Combinatorial optimization implementation Hi! I need to solve a combinatorial optimization problem, like the Knapsack Problem. I found some implementations, but they're memory inneficient. I also found libraries like this one from Google. #Other 0 1 0 228
Question José Pereira · Jul 6, 2018 Question about /Info/FilterMembers Hi everyone.I have a cube with two dimensions, DimA and DimB, with the following structure:DimA/H1/LevelADimA/H1/LevelCDimB/H1/LevelBDimB/H1/LevelCLevelC is modeled in such way because its bound property (C) is group by properties A and B in transactional database, but A and B haven't relation.I can use DeepSee REST API service /Info/FilterMembers/:datasource/:filterSpec specifying each dimension one filterSpec parameter and handle the results.But, I would like to have the results for both dimension in only on service call. #InterSystems IRIS BI (DeepSee) 0 4 1 264
Question José Pereira · Jun 29, 2018 Question regarding DeepSee DSTIME Hi.I would like to know if DeepSee has some feature regarding synchronization which could help me with this:I have two tables, TableA and TableB in a 1:n relationship, and one cube for each table, CubeA and CubeB.CubeA have a list dimension based on records from TableB.Both tables has DSTIME parameter set to "AUTO".Some application proccess updates data only on TableB, leading an entry on ^OBJ.DSTIME global for synchronization of CubeB.However, as the TableA wasn't updated, there isn't such entry for CubeA. #InterSystems IRIS BI (DeepSee) 0 2 1 237
Question José Pereira · Oct 10, 2017 Single Sign-on for DeepSee REST API Hi everyone! My company has a Zen ERP application with CSP delegated authentication. Now, we're developing a separated BI application, using Angular, which consumes DeepSee REST API services. Both applications access the same Caché database.How to implement single sign-on strategy in order to allow an already authenticated ERP user to access DeepSee REST services? Has anyone already implemented something like that?Thanks in advanced. #InterSystems IRIS BI (DeepSee) #Angular #REST API #Authentication #CSP #ZEN 0 3 0 562