Skip to Content
Author's profile photo Koen Hesters

WebI – PromptBox

A report needs a visualization of the used fiters, certainly when it is exported.

In webi you can use some nice formula’s to show the filters used via prompting.

1 UserResponse

Example: Userresponse(“Ledger”), Ledger is the promptname defined in BEX query or via Edit query panel

Capture.PNGCapture.PNG

This handy formula retrieves indeed the used filter on one specific prompt, however it has is disadvantages when you chase the promptname, you have to change the userresponsevariabels in every webi-document as well.  Or when your report is Language dependent, the promptname “Ledger” will change as well.

In new SAP BusinessObjects versions ‘(4.1 SPX) this formula is easily useable via >> ReportElement >> Cell >> Predefined Elements

2 PromptSummary

Example: Promptsummary()

Capture.PNG

This handy formula retrieves all the used filters, however when you use a bex query as datasource, you will see a lot of redundant info.  The queryname, when multiple queries are included this can lead to unwanted complexity.

3 Optimalized PromptSummary

This formula, removes the redundant info form the promptsummary.

Create a variable: Promptbox define it via the formula underneath and apply it in your report.

Capture.PNG

=Replace(Replace(If Pos (Right(Right(PromptSummary();Length(PromptSummary())-3);Length(PromptSummary())-3-Pos((Right(PromptSummary();Length(PromptSummary())-3));”*”)-2-4);”*”) = 0 Then (Right(Right(PromptSummary();Length(PromptSummary())-3);Length(PromptSummary())-3-Pos((Right(PromptSummary();Length(PromptSummary())-3));”*”)-2-4)) Else Left((Right(Right(PromptSummary();Length(PromptSummary())-3);Length(PromptSummary())-3-Pos((Right(PromptSummary();Length(PromptSummary())-3));”*”)-2-4));Pos((Right(Right(PromptSummary();Length(PromptSummary())-3);Length(PromptSummary())-3-Pos((Right(PromptSummary();Length(PromptSummary())-3));”*”)-2-8));”*”));”(Optioneel)”;””);”(Optional)”;””)

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.