SAP Knowledge Base Article - Preview

3737637 - Is it possible to use @prompt to pass dynamic parameters to database function in derived table for web intelligence reports?

Symptom

  • A database function with two input parameters (city and month) works in a derived table 
  • Attempting to use @prompt in the derived table so users can choose city and month at runtime for Web Intelligence and XML export.
  • Is it possible to use @prompt to pass dynamic parameters to database function in derived table for web intelligence reports?


Read more...

Environment

  • SAP BusinessObjects Business Intelligence platform
  • Data Foundation Layer
  • Information Design Tool 

Product

SAP BusinessObjects Business Intelligence platform all versions

Keywords

web intelligence, derived table, @prompt, unx, idt, universe, stored procedure, database function, parameters, dynamic parameters, dynamic result set, prompt, information design tool, postgres, runtime prompts , KBA , BI-BIP-IDT-DFX , Data Foundation Layer , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.