✍ Kashif M ™
☎ +91 9994883085
✉ kashif7222@gmail.com

Trends

Friday, 22 September 2017


Creating Query using Query Builder in BI Publisher


By on September 22, 2017




Select the table 'EMP' and 'DEPT' and check the required fields.

Define a join between these two tables as follows: 

Click the box beside the DEPTNO column in the DEPT table. (See the following screens.) 

Similarly click the box beside the DEPTNO column in the EMP table.

These boxes when marked for joins turn to light gray. 

Also note that a fine line joining the tables appears in the Model canvas.



This is the result for the generated SQL. 




Save the report

Kashif
mkashu: Creating Query using Query Builder in BI Publisher
Review : Kashif | Kashif
Update: September 22, 2017 | Rating: 4.5

Comment for "Creating Query using Query Builder in BI Publisher"

0 comments

Post a Comment

Blog Archive

Labels