@dpvalues and @dpend

building reports desktopintelligence
1

Hi Folks,
I am currently working on Migration from BOXI to Cognos…I came across @dpvalues and @dpend in sql where condition.


where (
@dpvalues('dbo.master.itnumber',268435457,43)@dpend 
)

What exactly it does in BOXI report…can someone help please

Regards
KKP

[Moderator Edit: Added code formatting - Andreas]

cognos.kkp@gmail.com (BOB member since 2016-06-10)

2

They might refer to the values generated by another data provider in the same report.

joeoc :ireland: (BOB member since 2002-11-18)

3

Correct. It’s when you use the results of another query.