Aside from updating compatibility to recent Excel versions, a couple of add-ins have been designed for Excel to be used as a template designer and as a grapher, with direct connections to OBIEEs datasources. The Column properties entry now allows you to anchor a column (or more) at any edge of a dashboard layout.Ī lof of effort has been put in improving Excel integration in OBIEE.
Be aware that after this change null rows and columns will be hidden by default, so you need to explicitly ask for them (slight change of logic).įigure 3.2: Null Row/Columns suppression at analysis level The feature of multi-selecting constraints is especially useful for viewing values defined by cascade dimensions.įigure 4.2: Prompt constraints by cascade dimensionsĮither at analysis or at viewer level (which overrides the previous one), null suppression options can now be indicated, affecting views such as: (pivot) table, (advanced) trellis, graph, gauge and funnel views, when an entire row or column contains null values. The value shown is limited by multiple constraints, but we still have the option to view other unrelated date prompts. In the following example, month is limited by year, and week by month and year. This function allows related prompts to be filtered according to others in cascade. &psa#= -> Identifies a primary subject area for a prompt.ĭetailed documentation on params: Oracle websiteĤth: Prompt constraints can now be set to be limited by more than one columnįigure 4.1: Prompts constraints limited by more than one column.&cov#= -> Sets the variable of a column prompt that also sets a variable.&dimid#= -> Identifies the dimension ID.&hierid#= -> Identifies the hierarchy ID.Required for prompts that use hierarchical columns If you do not use this parameter, it is assumed that the value is a display value.
EXCEL ORACLE BI PUBLISHER ADD COLUMNS CODE
&formulause#= -> Identifies whether a prompt value is a code value or a display value (in a repository that is configured for the double column feature).&val#= -> Sets the value of a prompt to a custom.&var#= -> Identifies the variable used in a variable prompt or that is set by a column prompt.$Action= -> New actions to take by prompted link.This release includes a bunch of new parameters to customize prompted links on dashboards such as:įigure 5: New parameters for dashboard prompted links Following we present our top 5 new features with a short explanation and some screenshots.ĥth: New parameters for dashboard prompted links
At Clearpeaks we found some new features really worth-noting, especially when casually most of those are actually not caught at first sight. Some of the new features have been long-time awaited before finally coming into light. OBIEE’s 11.1.1.7 release has enhanced the server’s experience.
0 kommentar(er)
