| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Tabular Designer"
(→Measure filters) |
|||
| Line 43: | Line 43: | ||
[[Image:TabularDesignerMeasures.png|thumb|center|500px]] | [[Image:TabularDesignerMeasures.png|thumb|center|500px]] | ||
| + | |||
| + | === Dynamic Measures === | ||
| + | As of [[Version 8.1]] you can create a measure from any column in the database. | ||
| + | |||
| + | To do this simply right click on the column and choose how to aggregate the values. | ||
| + | |||
| + | For numeric columns you can choose from Sum/Average/Min/Max, for other types you can do a Count of the values. | ||
| + | |||
| + | [[Image:TabularDesignerDynamicMeasures.png|thumb|center|500px]] | ||
==See Also== | ==See Also== | ||
Revision as of 13:11, 7 May 2015
Contents
[hide]Introduction
The tabular designer allows you to automatically create table reports against Analysis Services cubes in the DAX language.
These are simpler to create than a Grid, and can run against In-Memory or DirectQuery cubes. (Grids can not query DirectQuery Cubes)
Report layout
The tabular report designer is split into three parts.
First is the database browser, which allow you to see the Tables, Columns and Measures which exist.
Next is the report layout section, where you can specify the columns and measures on filters (above the table) and in the table.
Finally is the criteria area. Here you can select the members retrieved, and filter the rows based on measure values.
By dragging columns or measures into the "Filters" and "Selected Columns" areas you can specify the table layout.
Member filters
When selecting a column you can chose only to return rows for specific members.
To select a member, drag it from the left to the right panel. You can also add selections based on Excel cells and XLCubed Slicers.
If you have a lot of values in the columns, you can use the search box to find members you are interested in.
Advanced filters
As of Version 8.1 you can add more complex filers to member selections. Using the drop down you can select comparison options such as >, <, <> etc.
For text columns you also get options for Begins with, contains and others.
Additionally using the drop down in the toolbar you can choose whether conditions are combined using Or or And logic. "And" is useful for creating a between selection, e.g. Year > 2010 And Year < 2015
Measure filters
If you select a measure you can add a filter to include only values that fit the criteria you want. These can come from an Excel cell if required.
Dynamic Measures
As of Version 8.1 you can create a measure from any column in the database.
To do this simply right click on the column and choose how to aggregate the values.
For numeric columns you can choose from Sum/Average/Min/Max, for other types you can do a Count of the values.
