go to post Andrew Barber · May 9, 2022 I should add, I'm not having much success in terms of reporting. We don't have (or I can't get) the Management Portal, and I can't seem to use SSMS to write queries against the data, and in Power BI, the IRIS connector isn't allowed for dataflows.I am missing something super obvious, I know I am!What tools do other people use to write reports against IRIS?Thanks.
go to post Andrew Barber · May 9, 2022 That's great.Right at the end it says you can use your favourite SQL client to write SQL code against IRIS. Does this include SQL Server Management Studio, only I am not being successful in getting this achieved at my work?What SQL clients are best used for IRIS?Many thanks.
go to post Andrew Barber · Mar 29, 2022 Many thanks for your reply. I'll have a read up through the above, which should hopefully answer most of my queries. Intersystems SQL seems to what I need.
go to post Andrew Barber · Mar 29, 2022 Thanks for these links. Unfortunately I can't access them at the moment as it seems my login is not sufficient, but I will look into them. What software/application do I need to create all these then? I assume I am looking for an Intersystems equivalent of SQL Server Management Studio. Thanks again.
go to post Andrew Barber · Aug 25, 2021 Many thanks for your reply. That all sounds a bit beyond me! I know I've tried making a temp table in SSRS on the IRIS database but it didn't like it at all (giving vague errors), so gave up on that idea.I don't know what a classmethod is or how to create it. It seems very strange to me that you simply can't simply reference a specific parameter whilst ignoring others. I don't doubt it, however!!Regards,
go to post Andrew Barber · Aug 25, 2021 Many thanks, this will give me some weapons in my arsenal! ANd thanks for the quick reply also. But what about if I'm trying to cascade parameters? Parameter one influences dataset one. Then I have a parameter two which is populated by the results of dataset 1. This parameter is used in dataset two, but the field relating to parameter one doesn't exist in dataset two. Does that make sense? Basically, in your example, pretend column one doesn't exist as it relates to a different dataset. So I have multiple parameters, some of which are only able to be used on certain datasets. Thanks.