Before being able to run REST APIs to do specific tasks programmatically in Dynamics 365 for Finance and Operations (hereby known as D365FO), the application needs to be able...
2019-06-07
320 reads
I get asked this question all the time in my work as I am the BI consultant in Dynamics 365...
2018-09-25 (first published: 2018-09-12)
2,056 reads
If like me you thought “Hey, it’s a new feature, I can finally create reports in powerbi.com service and then...
2018-02-01
949 reads
We, BI professionals, sometimes take for granted that we can access the database of an ERP system quite easily, especially...
2017-07-29
713 reads
Management Reporter is easy to use to create Management Reports and it does not require a developer to do it....
2017-07-16
428 reads
Well, hello. It has been more than three years since my last blog, since then I have been really busy...
2017-06-30
570 reads
There are some cases when you need to use a PIVOT function in SQL but you cannot use a CTE....
2014-06-04
1,236 reads
Why are there multiple rows for each item in the Demand Forecast Table in Microsoft Dynamics AX 2012? This is...
2014-05-28
718 reads
Are you confused by how user roles in AX 2012 are integrated with Management Reporter roles? Have problems adding or...
2014-05-23
841 reads
I was just trying to gauge my BI knowledge level the other day and decided to chart it for visibility....
2014-03-26
559 reads
By Steve Jones
This is my last week of the year working (I guess I come back...
I recently read the book Agile Data Warehouse Design – Collaborative Dimensional Modeling, from...
By Steve Jones
This is my last week of the year working (I guess I come back...
I have an ADF pipeline that copies Files from source to destination. Both Source...
Comments posted to this topic are about the item Function Defaults
I have created this function in SQL Server 2022:
CREATE FUNCTION dbo.AddInt (@one INT, @two INT = 1) RETURNS INT
AS
BEGIN
RETURN @one + @two
END
How can I call this and invoke the default value for @two? See possible answers