CODEWITHSUNDEEP
business-intelligencespagobicockpit
jay5yant
jay5yant

Reputation: 1

How to add Multi-value Filter in cockpit spagobi?

select count(*)As CNT,Flat_status,property_name,Building
From xxacl_pn_flat_det_dm
where property_name in ($P{Property})
group by Flat_status,property_name,Building

$P{Property} returning multiple values in Dataset but not in cockpit view

Upvotes: 0

Views: 535

Answers (1)

Adonai Seixas
Adonai Seixas

Reputation: 11

As I understood, you want to pass multi value parameters to the dataset via some analytical driver from the cockpit interface. Well, first you must set the analytical driver to multivalue, then you can use the multivalue parameter syntax from spago, which is : $P{Property(';,;')} , this will give you something like: 

select count(*)As CNT,Flat_status,property_name,Building
From xxacl_pn_flat_det_dm
where property_name in ('example1','example2')
group by Flat_status,property_name,Building

Upvotes: 1

Related Questions