According to Create a table from MDX
we can make use of tm1-dimension-attribute to display e.g. Description of the element on canvas.
However, it does not work out.
Let’s take the Account dimension as example
I found that when the “Use Aliases” in Subset Editor is turned off, no matter which options, e.g. “Description”, “Full Description” is chosen, it just returns the Account number.
Only if I turn on the “Use Aliases” in Subset Editor, the “Description” and “Full Description” will take effect.
So, in Canvas, how to display the Account Description rather than original number using something like:
tm1-dimension-attribute=“{Month:‘Description’, Account:‘Name’}”
Can you give further information as to what are your sources (mdx, named mdx, views?) and what kind of output where you looking for?
Alternatively, you should be able to set it up with the Cube Viewer (tm1-ui-cube-viewer) instead, and hide the functionalities that you do not need for the user.
Thanks Paul,
The id in mdx_named.json is
{
“id”:“GLRptOpex”,
“mdx”: [
“SELECT NON EMPTY {[Month].[M12], [Month].[M12 YTD], [Month].[All Months]} * {[Scenario].[ACT], [Scenario].[BUD], [Scenario].[ACT vs BUD]} ON COLUMNS,”,
“NON EMPTY {[Account].[Expenses],[Account].[Expenses].children} ON ROWS”,
“FROM [Cube]”,
“WHERE ([Example].&[example])”
],
“description”:“”
}
in html:
<tm1-ui-table-mdx
tm1-instance=“company”
tm1-cube=“Cube”
tm1-mdx-id=“GLRptOpex”
tm1-dimension-attribute=“{Month:‘Description’, Account:‘Description’}”
< /tm1-ui-table-mdx>
The table displays on canvas is still the original name, but not Description:
