| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "TabularAliases"
| Line 4: | Line 4: | ||
* Member translations | * Member translations | ||
** This allows multilingual display of a report based on the user. | ** This allows multilingual display of a report based on the user. | ||
| − | ** e.g. An English speaker would see "Bikes" and a French speaker wouuld see "Vélo" | + | ** e.g. An English speaker would see "Bikes" and a French speaker wouuld see "Vélo". |
* Member Keys, separate from the member Caption | * Member Keys, separate from the member Caption | ||
| − | ** This allows reports to be built with member selections maintained when a Caption changes | + | ** This allows reports to be built with member selections maintained when a Caption changes. |
** If you update a Caption in tabular mode and have a report filter containing that member, then the selection will no longer work. | ** If you update a Caption in tabular mode and have a report filter containing that member, then the selection will no longer work. | ||
| − | *** In Power BI the old caption will be used, and the report will contain no data | + | *** In Power BI the old caption will be used, and the report will contain no data. |
*** In an Excel PivotTable the selection will be lost when the data is refreshed, and the default (All) member will be displayed instead. | *** In an Excel PivotTable the selection will be lost when the data is refreshed, and the default (All) member will be displayed instead. | ||
| + | |||
| + | The Tabular Translations feature in XLCubed aims to address both of these issues allowing you to build a single multi-ligual report that will work correctly when member captions are updated. | ||
| + | |||
| + | =Translations= | ||
Revision as of 16:34, 15 November 2021
The Analysis Services OLAP engine in Tabular mode has some missing features compared to the Multidimensional mode. The Tabular engine is used in Analysis Services on-premises, Analysis Services Azure and Power BI (desktop + cloud)
Among the features that Tbaular mode does not replicate are
- Member translations
- This allows multilingual display of a report based on the user.
- e.g. An English speaker would see "Bikes" and a French speaker wouuld see "Vélo".
- Member Keys, separate from the member Caption
- This allows reports to be built with member selections maintained when a Caption changes.
- If you update a Caption in tabular mode and have a report filter containing that member, then the selection will no longer work.
- In Power BI the old caption will be used, and the report will contain no data.
- In an Excel PivotTable the selection will be lost when the data is refreshed, and the default (All) member will be displayed instead.
The Tabular Translations feature in XLCubed aims to address both of these issues allowing you to build a single multi-ligual report that will work correctly when member captions are updated.
