What’s New 4.1 – Web Intelligence 4.1 SP5 Pre-defined Cells

Tutorial on Creating a Pre-Defined Cell Based on Query Prompt Enhancement in Web Intelligence 4.1 SP5

We've asked our team to come up with what they think are some great additions to BusinessObjects Web Intelligence 4.1 SP5 and are happy to share our thoughts with you. If you have any questions, don't hesitate to reach out to us and ask. How to Create a Pre-Defined Cell in Webi 4.1  Compared to inserting a blank cell in a report, you can select a pre-defined blank cell as an alternate option.  A pre-defined cell includes the appropriate syntax already applied to the free standing cell instead of writing your own syntax. For this example, we will be utilizing the ‘Prompt’ pre-defined cell option which is based on a report prompt.  After a dimension object is added to the Query filters area and enabled as a prompt, the newly created prompt is a selectable option in the Pre-Defined Cell>Prompt menu.  When you insert the ‘Prompt’ predefined cell in a report, the cell displays the user prompt selections from the last refresh or Run Query action. Steps  Open Web Intelligence 4.1 Select your required dimensions and measures for your query Create a prompt in the Webi query panel by dragging an object to the query filters section. Click the object options from the down arrow menu. Select ‘Prompt’ Webi_Pre_Defined_Cell_Display_Tutorial_1 The prompt text will be auto populated in the text box. You can customize the prompt text if required. Webi_Pre_Defined_Cell_Display_Tutorial_2 Run your query Select the ‘Report Element’ tab in Webi toolbar Click ‘Pre-Defined’ option and mouse over ‘Prompt’ option Then, select the text from your prompt created in the query panel Webi_Pre_Defined_Cell_Display_Tutorial_3 Click and drop the blank Pre-Defined cell anywhere on the Webi canvas Webi_Pre_Defined_Cell_Display_Tutorial_4 The Pre-Defined cell now displays the year you selected in your query prompt You can use this function to display the value of any prompt on your Webi report Webi_Pre_Defined_Cell_Display_Tutorial_5   [gravityform id="26" name="Contact WCI - Blog"]

Get Started

Want a FREE on-site discovery session with your team?  Receive a FREE data management evaluation session with one of our veteran data architects. Reap the benefits of an expert’s outlook on taking control of your business insights and data. Stop missing out on data-driven opportunities,  and start making smarter, more profitable decisions today.