-1

Suppose I have 3 input parameters in my OBIEE data model: A, B, C.

Suppose the SQL query only returns results for parameter A. Thus, my XML only has results for A.

In my RTF word document, I want to display a "No Results" message for parameters B and C. How do I do this?

I am able to access ALL of the input parameters A, B, and C. But I'm not sure how to "search" for them in the XML.

I am on OBIEE 12c and Informix 11g.

ColoradoBanana
  • 1
  • 4

1 Answers1

0

BIP does have a "count" function, which takes and xpath, and returns the count of children at that node. You could check if the count returned is zero, and print and error there.

Ref here , here and here. It is not properly docuemnted, as it is a standard XSL function.

Ranjith R
  • 1,571
  • 1
  • 11
  • 11
  • Thank you. How do I loop through the parameters, they are stored like this: [A,B,C,D]? Should I ask this in a new question. – ColoradoBanana Jul 18 '18 at 18:34
  • Refer your parameter using <$PARAMETER_NAME> , note the $ sign.https://blogs.oracle.com/xmlpublisher/get-your-parameters-here,-guv. BIP has string manipulation functions. But no split function – Ranjith R Jul 19 '18 at 00:16