Power BI drill down feature requires hierarchy. When a visual has a hierarchy, you can drill down to reveal additional details. For example, you might have a visualization that looks at the sum of sales of the products by a hierarchy made up of Name column of cities and ModifiedDate column. By default, the visualization displays […]
Problem There are some problems with Power BI (See Business Intelligence) which include having an issue in displaying statistics in the report according to the fiscal year which I had set in the Timeline Slicer tool. Let’s review in details of the problem by going through diagrams of Power BI report. The fiscal year set in […]
In this blog, we will cover how to integrate any system with Salesforce (Salesforce CRM) using Microsoft BizTalk Server. This post includes a very simple scenario, get top 10 accounts from Salesforce. It will respond back with an XML and then you can tweak that XML as per your requirements. Steps include to accomplish that […]
In this blog, we will cover basic web calls testing with requests and responses using Salesforce. SoapUI provides capabilities to test and verify request and response messages before writing any code in c#, java or any other language. It is always recommended to test your calls with SoapUI before doing any sort of integration using […]
Here is the few guideline for anyone making new videos. What tools to use (Cam studio, Camtasia, http://srecorder.com/ etc..). Don’t mention the client name in your video. The video should not be longer than 15 to 20 mins. Be concise and to be the point. Before making the title, just search the keyword through Google keyword planner what people […]
[The article first appeared at www.usmanshaheen.wordpress.com] All Preview API Apps including BizTalk Rules V1 API App was deprecated from Azure since Jan 18th, 2017. The migration path is to redeploy the V1 API App as App Service but this is not possible for built in BizTalk Rues API App. Here are few alternatives of BizTalk […]
Recently a client asked me whether they should use tabular or multidimensional model for creating the BI (business intelligence) semantic model. I choose the tabular route due to the following reasons. Reasons to go the Tabular route If you want to use DAX (based on Excel formulas, but is often seen as having a steep […]
SQL Server is Microsoft’s flagship database product and has been in use for more than a decade. Microsoft recently announced to release SQL Server 2016 next year and has already released the preview version. The new 2016 release will have significant improvements in security features, in-memory OLTP, analytics and Stretch Database. Here is a list of […]
In the previous part of this series, I went through the lowest underlying messaging layer architecture, in detail and now, we are going to move on to another important component, pipelines. Pipelines are there in the send and receive interfaces to process messages entering and leaving the BizTalk server. Going over some of it fundamentals, their […]
In the first part of this BizTalk for beginners series, I wrote about the BizTalk model and its server Architecture. In this post, we’ll have a look at Biztalk’s messaging architecture. It is built on service architecture which helps the orchestration layer in it’s function, that runs on top of it. The messages exchanged within the […]