SP14 Create Birt report and pass parameter in dataset define in SpagoBI server

Lets create a BIRT report using spagobi studio and main task is for me to pass parameter that is define in SpagoBI server

Follow the below steps to follow up:

• Start spagoBi server and Studio
• Create or define parameter using "Profile Attribute management"
• I added "deptname" see below image for ur reference

• Open spagoBi studio using spagoBI perspective only
• create "New Birt report"

• Switch your spagoBi studio to Report design perspective. You can see this option on very right top hand side of window.

• Create JDBC datasource connection. I created the connection with oracle server with scott user.

• Create parameter which needs to pass into query. Right click on "report parameter" and create new parameter. see below image.

• Create new data-set which contains the query pull data from database . In below image i have written simple query without any parameter pass.
• but you can replace the 'SALES' with "?", so that you can pass your parameter in query.
• After replace it with ?, 
• assign value to parameter 

• go to "parameter" on left hand side (see below image)

• Design the BIRT report layout, drop your dimension and measure from left hand side onto LAYOUT.

• Test your report on studio side by clicking on "preview" tab. after it will ask for enter parameter value popup. Enter value and press ok.

• Switch spagoBI studio to "SpagoBi" perspective.
• Deploy your report 

• Create LOV for deptname

• Test your LOV and check radio button and checkbox. (see below image)

• Create "Analytical driver" for LOV "deptname"

• Move to Folder to execute your report, that u had deployed recently.
• First we have to define "DOCUMENT ANALYTICAL DRIVER DETAILS" for your document.
• Click on properties icon on your document

• Save and Execute report.
• Quite easy SpagoBi, Nothing difficult . ENJOY