Question Virat Sharma · Jun 18 Queries on Listing fields and its filter Hi Community, I seek your assistance for below scenario. Scenario-1: How to add filter or where clause while displaying data with listing fields ( I have not used Custom SQL listing to display this data). For below table, I have created a Cube Student and I have created listing fields of the columns mentioned in the table. Also I have created the pivot and I am able to create the same table as shown below. #Cubes #Dashboards #Listings #MDX #InterSystems Reports (DeepSee, BI) 0 0 0 66
Question Virat Sharma · May 29 How to Remove Search Text Box in Filter Dropdown Hi All, I am working on SQL based KPI in IRIS BI. I want to remove below highlighted search text box in "auto" filter type. We cannot use other type like only dropdown etc. Is there a way we can do this ? One way I can see is writing own control instead of using default control but I am not aware how to do this. I didn't find any sample code for this. Is there any sample code available for writing custom control which I can refer. Please assist #Dashboards #Caché #InterSystems IRIS #InterSystems Reports (DeepSee, BI) 0 1 0 62
Question Virat Sharma · Apr 29 IRIS Dashboard/Deepsee Queries Hi Everyone, We are using SQL based KPI's to display reports in IRIS dashboards. We have applied the filter functionality in these SQL based KPI reports. I need your help for below scenario. Below is my full report. Filter is applied on Name and Subject Name in this report. Now I have used filter on Name and selected values 'Virat' and 'Big Show' #Analytics #InterSystems Reports #Caché #InterSystems IRIS #InterSystems Reports (DeepSee, BI) 0 1 0 86
Question Virat Sharma · Feb 17 BI Dashboard debugging possible in IRIS? Hi Community, I have below scenario We have IRIS BI Reports in my application. I want to create a automated backend utility (similar to background cache system task) which run these bi reports and export them to PDF at a specific path. In dashboard we have defined <property name="print">1</property> which allows report export to PDF. Now I want to debug the code (line by line) from dashboard to %DeepSee.UI.MDXPDF.cls but I am not sure is this possible or not. Please suggest. Thanks in advance! #InterSystems IRIS #InterSystems Reports (DeepSee, BI) 0 1 0 114
Question Virat Sharma · Feb 15 How to open a dasboard url in browser in a automated cache batch job Hi Community, I have below scenario We have IRIS BI Reports in my application. Now these reports currently being acessed by users through dashboard url's. I want to create a automated utility (background cache system task) which run these bi reports and export them to a specific path. I am looking for a system method through which we can open these dashboard url's through code and export the excel report to a speciific path. Thanks in advance. #InterSystems IRIS #InterSystems Reports (DeepSee, BI) 0 1 0 103
Question Virat Sharma · Jan 11 DeepSee PDF reports viewing methods Hello everyone, I am new to Deepsee (BI intelligence) concepts in IRIS. I am looking for a solution of below question Question: We have a server where we are currently storing archive PDF reports of our application. We want to add and view these archive reports (PDF format only) in dashboards. Is there any way we can do this? Or any article which can help us performing this task. Thanks in advance!! #InterSystems IRIS #InterSystems Reports (DeepSee, BI) 0 1 0 130
Question Virat Sharma · Jan 30, 2023 SQL Query Help in $ListGet Hi All, I want to run an SQL like below Select ID,Rollno,Marks,Name,Section,Teacher from Marks left outer join Student on Marks.StudentID=Student.ID Now, the Student.ID is having the encrypted value which is not matching with Marks.StudentID (as this is clear value). I can get the clear value using encrypted value as follow ^StoreValue("EncryptStudentID",Student.ID)=$LB("123"). That 123 is the clear Student.ID which I need to match in SQL query (ON clause). #SQL #Caché 0 2 0 175
Question Virat Sharma · Jan 30, 2023 SQLComputed Code issue Hi All, I have a below query for which I need help. I have a persistent class User.Cars.cls. The properties of this class is mapped through Global mapping with global (^CAR(Date,CarSerialno,Seq)). Property CarNumber as %String (TRUNCATE=1) [SqlFieldName= CAR_Number]; Mapping of 5th Piece of ^CAR global to CarNumber property. For e.g.^CAR(Date,CarSerialno,Seq)=1^2^3^4^BMW 4567^6^7 #SQL #Caché 0 1 0 176
Question Virat Sharma · Jan 24, 2023 SQL Query needs optimization Hi All, I am having an SQL query (mentioned below). When I am running this query it is taking 90 min to retrieve all records (approx 1 million records). Fetching data from 5 tables using inner join in cache. Relative cost displaying 10 million I wan to confirm How this query can be optimized #SQL #InterSystems IRIS 0 12 0 289
Question Virat Sharma · Jan 23, 2023 SQL Query getting timeout in management portal Hi All, I am a beginner in cache. I need to extract data from multiple tables (4-5) tables based on an SQL query . The data is more than 9 lakhs of records (i checked using count). The total number columns is 16. When I am running this SQL query through management portal, I am getting time out exception. Could you please suggest how I can retrieve those records. Which way will be good (Dynamic query using %SQL.Statement or Embedded SQL (not known to me) or Writing to a global will help or not). #Databases #SQL #Caché #InterSystems IRIS 1 4 0 300
Question Virat Sharma · Jan 21, 2023 How to configure/run SQL Queries of cache namespaces in MS Access Hi All, I am currently using D $SYSTEM.SQL.Shell() command or management portal to retrieve the data from database. I just learned we can also run cache table sql queries in MS access. MS access already installed on my machine. I need to ask how I can connect my database of USER or sample namespace in MS access to run these SQL queries. Thanks in advance!! #SQL #Caché #InterSystems IRIS 0 4 0 235
Question Virat Sharma · Jan 16, 2023 CACHE DBA Role Hi All, I want to move into CACHE/IRIS DBA role. Can anyone suggest what all learning must be done in order to move in this role. It would be great if you can provide the learning path as well for the topics. (links from I can learn the provided topics) Thanks in advance!! #Databases #System Administration #Caché #InterSystems IRIS 0 3 0 367
Question Virat Sharma · Jan 11, 2023 Error while running the SQL Query- Incorrect list format: 0 >= 0_SQLSTATE: S1000 Hello Team, I need a help in the following error I am getting while running the SQL Query. I am running the SQL Query from different table using inner join. I run this everyday for last 90 days but for few days while extracting the data through this query I am getting this error. Please assist. SQLException was thrown: Incorrect list format: 0 >= 0_SQLSTATE: S1000 SQLException was thrown: Incorrect list format: 0 >= 0_SQLSTATE: S1000 Error getting attributeColumn: Name Error getting attributeColumn: Amount #SQL #Caché #InterSystems IRIS 0 2 0 368
Question Virat Sharma · Oct 20, 2022 Compilation information for classes Hi All, Is there any cache command which can give who all has compiled a classes from the day it has been created. Specifically I want the 2 information username and time of compilation of class. I tried with $$DATE^%R("TEST.1.INT"), but it only gives the last compilation time. Thanks in advance !! #Caché 0 3 0 270
Discussion Virat Sharma · Jun 24, 2022 IRIS Core Solutions Developer Specialist Certification DUMPS Hi All, I am preparing for InterSystems IRIS Core Solutions Developer Specialist Certification. I have completed the desired syllabus. Does anyone have any questions dumps. I have already completed the practice paper on Intersystems website. #InterSystems IRIS 0 1 0 251
Question Virat Sharma · May 24, 2022 need reporting tool idea used for cache database Hi All, I am looking for a reporting tool (Analytics purpose) which can be built using cache object script/MUMPS. Basically my requirement is to find a tool where I can implement cache code to report data for my application. I am unaware of DeepSee and how it works. Please assist for the same. #Analytics #InterSystems Reports #Caché #InterSystems IRIS #InterSystems Reports (DeepSee, BI) 0 3 0 324
Question Virat Sharma · Sep 5, 2021 Databases Tuning Hello everyone I am new to cache. I want to know how we can perform database tuning. Thanks in advance!! #Beginner #Caché #InterSystems IRIS 0 6 0 281
Question Virat Sharma · Sep 5, 2021 how to optimize a SQL query using Query plan Hello everyone I am new to cache. In an interview i was asked how to optimize a sql query. I just said I will create index on conditions which are present in where clause. But as per interviewer I should check How query plan is getting executed. This will help in optimizing Sql queries. I want to know what will be the answer for how to optimize SQL query in cache. Thanks in advance!! #SQL #Caché #InterSystems IRIS 0 2 0 213
Question Virat Sharma · Sep 5, 2021 Global Access command query Hello everyone, I am new to cache. I want to know is there any direct command to know how to find maximum number of subscripts in global A through direct command. I mean the answer is 9 but how to check it using a direct command on terminal. Thanks in advance!! ^A(1)="A" ^A(1,2)="B" ^A(2,1)="CVB" ^A(3,2,7)="'DFGH" ^A(4,1,8,9)="ASDASD" ^A(5,1,2,4,5,6,7,8,9)="ASDASDASD" #Caché #InterSystems IRIS 0 3 0 265
Question Virat Sharma · Sep 5, 2021 When to Use which kind of Method Hello Everyone I am new to cache. I know there are 2 types of methods in cache. One is Instance method (Which can be call through object creation of particular class) and other is Class methods (which can be call through ##Class(MyPackage.Car).CarModels()). I want to know the difference when to create a instance method vs when to create a class methods. Thanks in advance!!. #ObjectScript #Caché #InterSystems IRIS 0 3 0 213