Ole Dyring
Activity overview
Latest activity by Ole Dyring-
Ole Dyring commented, Hi Beata, Assume you have a calculation like this: sum(d1, 0, m1) / sum(d1, 0, m2) This will result in a "Math error" when the latter part is zero. To prevent the "Math error", you can change the s...
-
Ole Dyring commented, Hi Thomas, We are currently investigating options with regard to BIA / Custom SSIS tasks for SQL Server 2022. In the meantime, it should be possible to move an existing BIA data warehouse to an SQL...
-
Ole Dyring commented, Hi Michael, I have tried simulating your issue on the latest 2022 version (build 22.11.29002), but I cannot make it crash. It may be because I have much less data than you, but it can also be some...
-
Ole Dyring commented, Hi Thomas, Currently we have no short term plans for developing BIA / Custom SSIS tasks for SQL Server 2022. BR / Ole
-
Ole Dyring commented, Next planned on-prem feature release: June 2023
-
Ole Dyring commented, Ok Michael, Got it. :-) It is just a crosstab coming from a 2017 version to a 2019 version. What is the exact TARGIT 2019 version (build number - you should be able to find it in the 'About')? I've...
-
Ole Dyring commented, Hi Michael, I am not sure why you get these extra, empty columns in your crosstab. Notice that you will probably need to convert your reports to the new layout anyway - at some point. The last vers...
-
Ole Dyring commented, Hi Ole, You can use a cross join to create a new period table from the existing period table and e.g., an hours table. See this article: https://community.targit.com/hc/en-us/articles/8705593922461...
-
Ole Dyring created an article, Expand Period table with Hours
The Period Table task that comes with the ETL Studio creates Years, Months, Dates etc. It does not, however, create hours, minutes, seconds. In this example I will show you how you can create a new...
-
Ole Dyring commented, Hi Thomas, I have created a color agent (color background) that works like this on my single measure, No of Sales: BR / Ole