The variables are of two types. They are
This variable is used anywhere in the report
Navigation
Report Menu → Report → properties → variables → Add → Name: PINC
↓
Expression window:
Set the expression
*12/100
Click Ok
Go to text box → rt click expression → expression window
= fields! Partyincome.value * variables! PINC.value click ok
Note:- We cannot use in calculated or query fields
If you want to enrich your career and become a professional in MSBI, then enroll in "MSBI Training" - This course will help you to achieve excellence in this domain. |
These are used within the same group only group → group properties → variables → add → NAME (PIC) → Expression (=12/100)
Adding calculated fields:
Here the fields are created based on Calculation.
Navigation:
dataset properties → fields → Data set → rt click → Add. calculated field → Party Inc _DWH → expression → = fields! Partyincome.value *12.100 → OK
Note:
Related Article: Msbi Interview Questions |
a) Query:- 2) Name, Data source, query Type → text → Query: *Refresh fields → If the data in the sources change, to get the fresh data, this option is useful
b) parameters
c) fields
d) Options → Here options are case sensitive
e) Filter:- It filters the data of the dataset
Working with page header and footer:
Toolbox → image option → take image → Embedded → Import image → Image properties → general → name → size → In-Display → select the options fit to size
For expression → RT click → Text box properties → Expression
Explore MSBI Sample Resumes Download & Edit, Get Noticed by Top Employers! |
Name | Dates | |
---|---|---|
MSBI Training | Oct 12 to Oct 27 | View Details |
MSBI Training | Oct 15 to Oct 30 | View Details |
MSBI Training | Oct 19 to Nov 03 | View Details |
MSBI Training | Oct 22 to Nov 06 | View Details |
Ravindra Savaram is a Technical Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.