Element Details: OLAP+Table
 Back


Available in: Logi Info Source code name: OlapTable

OlapTable provides basic functionality to display information from an Analysis Services OLAP data source or XOLAP Cube. It is best used to display a static view of OLAP data. Unlike the OlapGrid element, OlapTable does not provide UI functionality for selecting dimensions, drilling down, etc.

Connection is Analysis Services is not available in the Java version.

Element Group:Dimensions and Cubes



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
AltRowClass
UserDefined
A style sheet class that will be used for every other row of the table. When using in an Analysis Grid define the class as follows in your stylesheet file: TR.[Classname] TD This ensures that your class is not overriden by an AnalysisGrid class. The themes class ThemeAlternatingRow takes care of this for you.
Caption
UserDefined
The Caption attribute identifies the text to be displayed. For Image elements, Caption specifies the image filename.
CaptionClass
UserDefined
For Input elements, this is style sheet class that will be applied to the input element's caption. Leave this value blank unless you want the Caption to have a different class than the input element. For tables, Caption Class sets the class for the table's caption, which appears as a header above the table.
CellSpacing
UserDefined
The width, in pixels, of the space between table cells.
Class
UserDefined
Sets the Cascading Style Sheet class used by the element. When set, this class will also be used by all child elements that don't have their own class. The class should be defined in the report's style sheet file.
ColumnHeaderClass
UserDefined
Sets the class for the table's column headers.
HideWhenZeroRows
True
False
Removes the DataTable when the DataLayer returns zero rows. The default value is False.
ID
UserDefined
(Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.
Layout
Fixed
Auto
Determines if the table layout is automatic or fixed. The default is automatic. With fixed, the column layout is determined with the first row, instead of adjusting column widths by examining every row. This can help with formatting issues, and can also significantly improve large table performance.
LevelIndent
UserDefined
LevelIndent sets the amount of indentation, in pixels, used to show levels of a hierarchy.
OlapCellColors
True
False
Set OlapCellColors to True to get and display foreground and background colors for Calculated Members. The colors are defined in Analysis Services. OlapCellColors does not apply to XOLAP Cubes. The default value is False.
SecurityRightID
UserDefined
When entered, access to this element can be controlled with Logi security. Supply the ID of a right defined in the applications settings’ Security element. Only users that have a right in the SecurityRightID will be able to see the element. Note that when rights come from RightFromRole elements under Security/UserRights, and this element's SecurityRightID does NOT match any of the Right IDs defined in the Settings definition, then the user DOES have access. But when Right IDs are instead derived from RightsFromDataLayer or RightsFromRoles elements, and the user DOES NOT have a matching Right, then the user DOES NOT have access. You can enter multiple right IDs, separated by commas. In this case, the user sees the element if he has any one of the Rights.
TableBorder
UserDefined
Draws a border around the table. Set this value to the number of pixels of the border width. A value of 1 draws a thin border.
Width
UserDefined
UserDefined
The width of the element.
WidthScale
px
%
The width scale of the element. Value can be "px" for pixels, or "%" for percentage of the available width.



PARENT ELEMENTS

Click element to drill down for more information.

Body
Column Cell
Division
Fieldset Box
HTML Tag
Panel Content
Popup Panel
Responsive Column
Tab Panel


CHILD ELEMENTS

Click element to drill down for more information.

DataLayer.MDX
DataLayer.XOLAP Query
Generated Element Plugin Call XOLAP Cube


 Back to top


 Chart Debug