Sunday, October 28, 2018

Mathematical Operators in IBM Cognos Analytics

 



Following are some example using Mathematical Operators.

() Brackets are used to control the expression evaluation order.
+ For additions, and string concatenation
- For subtraction and negation
* For multiplication
/ For division
|| For concatenate


Tutorial Post: https://vlemon.com/TUTORIAL/IBM-Cognos-Analytics/operators-in-ibm-cognos-analytics
Support Us:
PayPal: https://www.paypal.me/vlemonn
Patreon: https://www.patreon.com/vlemonn

Useful URL:
Our Website: https://vlemon.com
Tutorial Post: https://vlemon.com/TUTORIAL/IBM-Cognos-Analytics/operators-in-ibm-cognos-analytics
Facebook: https://www.facebook.com/vLemonn
Twitter: https://www.facebook.com/vLemonn
Google Plus: https://plus.google.com/+MayankSanghvivlemonn
YouTube: https://www.youtube.com/c/mayanksanghvi
WhatsApp: +91-8818882120 (Only for Premium Users)
Hire Me: Charges may apply.

Friday, October 26, 2018

Operator Precedense in IBM Cognos Analytics

 

In our previous examples, we learned to create a simple Data Module for our IBM Cognos Analytics Reports.  We are learning about How to create Joins in Data Modules. When we import data, then it is not mandatory we will get all the information we required of reporting. Sometimes we need to add manual calculations to retrieve the correct information and use it in our reports. This video is dedicated for Operators in IBM Cognos Analytics and Data Modules.

Following are the Key Points which we will cover in this article.

Operators in IBM Cognos Analytics Data Modules
Create Calculated Columns with Operators

Tutorial Post:https://vlemon.com/TUTORIAL/IBM-Cognos-Analytics/operators-in-ibm-cognos-analytics
Support Us:
PayPal: https://www.paypal.me/vlemonn
Patreon: https://www.patreon.com/vlemonn

Useful URL:
Our Website: https://vlemon.com
Tutorial Post:https://vlemon.com/TUTORIAL/IBM-Cognos-Analytics/operators-in-ibm-cognos-analytics
Facebook: https://www.facebook.com/vLemonn
Twitter: https://www.facebook.com/vLemonn
Google Plus: https://plus.google.com/+MayankSanghvivlemonn
YouTube: https://www.youtube.com/c/mayanksanghvi
WhatsApp: +91-8818882120 (Only for Premium Users)
Hire Me: Charges may apply.


Wednesday, October 24, 2018

WordPress Multi Site Domain Mapping with Example





In this video, we will learn How to host WordPress Multi-Site on Google Cloud Compute Engine?

We will cover the following topics in this article
Create a new VM
Reserve a Static IP
Map a Custom Domain
Configure our Primary Domain
Add a new Web Site with Sub Domain
Add a new Web Site for another Domain
Install SSL Certificates

The video will also help you to answer the following key points.
WordPress Multisite SubDomain
WordPress MultiSite Different Domains Mapping or Website
WordPress MultiSite Examples
WordPress MultiSite Domain Mapping
WordPress MultiSite Domain

Tutorial Post: https://vlemon.com/BLOG/Google-Cloud-Platform/host-worpress-multi-site-on-google-cloud-compute-engine
Support Us:
PayPal: https://www.paypal.me/vlemonn
Patreon: https://www.patreon.com/vlemonn

Useful URL:
Our Website: https://vlemon.com
Tutorial Post: https://vlemon.com/BLOG/Google-Cloud-Platform/host-worpress-multi-site-on-google-cloud-compute-engine
Facebook: https://www.facebook.com/vLemonn
Twitter: https://www.facebook.com/vLemonn
Google Plus: https://plus.google.com/+MayankSanghvivlemonn
YouTube: https://www.youtube.com/c/mayanksanghvi
WhatsApp: +91-8818882120 (Only for Premium Users)
Hire Me: Charges may apply.

Monday, October 22, 2018

Tableau Join














In the real-world scenarios, we need to Combine data from multiple tables. To combine data from multiple tables, we need to create Joins between tables. In this video, we will first create a data source connection to an Excel file. Then we will create Joins between all the available tables in the excel file.

Tableau Types of Join
1. INNER JOIN
2. LEFT OUTER JOIN or LEFT JOIN
3. RIGHT OUTER JOIN or RIGHT JOIN
4. FULL OUTER JOIN or FULL JOIN

Tableau Join Operators
Equals To (=): Value for the joining columns must match. Example ID = ID.
Not Equals To (): Value for the joining columns must not match.
Less Than (): Value for the joining columns from the left table must be smaller than the value in the right table.
Less Than Equal To : Value for the joining columns from the left table must be smaller or equal to the value in the right table.
Greater Than (): Value for the joining columns from the left table must be greater than the value in the right table.
Greater Than Equal To (): Value for the joining columns from the left table must be greater or equal to the value in the right table.

Cross Join or Cartesian Product
How to create a Cross Join in Tableau?

Tutorial Post: https://vlemon.com/TUTORIAL/Tableau-Tutorial/joins-in-tableau-desktop
Support Us:
PayPal: https://www.paypal.me/vlemonn
Patreon: https://www.patreon.com/vlemonn

Useful URL:
Our Website: https://vlemon.com
Tutorial Post: https://vlemon.com/TUTORIAL/Tableau-Tutorial/joins-in-tableau-desktop
Facebook: https://www.facebook.com/vLemonn
Twitter: https://www.facebook.com/vLemonn
Google Plus: https://plus.google.com/+MayankSanghvivlemonn
YouTube: https://www.youtube.com/c/mayanksanghvi
WhatsApp: +91-8818882120 (Only for Premium Users)
Hire Me: Charges may apply.