Data Analysis Expressions (DAX) in Power BI
Data Analysis Expressions (DAX) is a powerful formula and query language used in Microsoft Power BI, Excel Power Pivot, and Analysis Services to perform calculations and manipulate data. It allows users to create custom metrics, measures, and calculated columns, enabling
MySql Multi-table Join Query using Cakephp 3
Below is a mysql query joining three tables. SELECT c.course_path, t.sf_name FROM courses c JOIN modules m ON c.id = m.course_id JOIN topics t ON m.id = t.module_id WHERE t.topic_name = ‘test_topic’. This Query will return Course_path and Sf_name from
How to create Subscriptions in cybersource Payment Gateway
Basically subscription in Cybersource is the customer profile that holds its details like customer details, billing and shipping details, customer payment information like card type, expiration date, account number etc. We have to pass all these details to Cybersource with
How to change wordpress multisite Subdomain to subdirectory
In a project I was working on WordPress multisites run on subdomains and we wanted to change multisite subdomains to subdirectory path like this: www.test.domain.com to www.domain.com/test. Following steps are needed to follow for converting the subdomain to subdirectory URL
SSL certificate problem: unable to get local issuer certificate
Problem : Error comes when trying to use https with url on xampp server, error “SSL certificate problem: unable to get local issuer certificate”. Solutions: you need to follow below mentioned steps: 1. Stop apache service from xampp control panel.
Upgrading Liquid files from 2.x.x to 3.x.x (on new machine)
Below are the steps to migrate liquid files from 2.x (old machine) to 3.x (new machine) Command on old machine : # ft migrate 1. Migrate to this system 2. Migrate from this system 3. Cancel ? 2 This will
Jquery | $ is not defined – Solving JQuery Conflict
Piwik analytics is a open source analytic platform. Piwik provides APIs to manipulate and fetch analytics data and one can also create their custom APIs for same purpose. There are many APIs available in PIWIK but here I will explain
Jquery | $ is not defined – Solving JQuery Conflict
Due to some project requirements sometimes we need to load multiple versions of jquery (not recommended). As most of the jquery library uses $ as an alias name for jQuery, therefore only $ of last library loaded into page works
Zoho | How to configure territories in zoho
What is Territory? Territories in Zoho can be used to create groups of customers/accounts on the basis of region, product etc and then a staff member of organization can be permitted to have visibility into accounts of a particular Territory
SQL Transaction in Cakephp 3
SQL transaction in Cakephp 3 is a series of statements working in a logical order to handle database errors and ensure data integrity. There are four main methods being used in Sql transaction in Cakephp 3. 1. Initialize the statement
