Hello I have created a CUBE with a toolbar with buttons, but they do not show in designer and when you execute the document.
<?xml version="1.0" encoding="UTF-8"?>
<olap>
<cube reference="schema_1_pentaho_PSD2"/>
<TOOLBAR>
<BUTTON_DRILL_THROUGH clicked="false" visible="false"/>
<BUTTON_MDX clicked="false" visible="false"/>
<BUTTON_EDIT_MDX clicked="false" visible="false"/>
<BUTTON_FATHER_MEMBERS clicked="false" visible="false"/>
<BUTTON_HIDE_SPANS clicked="false" visible="true"/>
<BUTTON_SORTING_SETTINGS clicked="false" visible="true"/>
<BUTTON_SORTING clicked="false" visible="true"/>
<BUTTON_SHOW_PROPERTIES clicked="false" visible="false"/>
<BUTTON_HIDE_EMPTY clicked="false" visible="true"/>
<BUTTON_SAVE_NEW clicked="false" visible="true"/>
<BUTTON_UNDO clicked="false" visible="true"/>
<BUTTON_EXPORT_OUTPUT clicked="false" visible="true"/>
<BUTTON_EDITABLE_EXCEL_EXPORT clicked="false" visible="true"/>
<BUTTON_FLUSH_CACHE clicked="false" visible="true"/>
</TOOLBAR>
<MDXMondrianQuery>SELECT CrossJoin({[geographic_distribution_dim].[All geographic_distribution_dims], [geographic_distribution_dim].[Вътрешни], [geographic_distribution_dim].[Презгранични в рамките на ЕИП], [geographic_distribution_dim].[Презгранични извън ЕИП]}, {[Measures].[FRAUD_TRANSACTIONS_CT], [Measures].[FRAUD_TRANSACTIONS_VOL], [Measures].[TOTAL_TRANSACTIONS_CT], [Measures].[TOTAL_TRANSACTIONS_VOL]}) ON COLUMNS, {([route_dim].[All route_dims], [distance_dim].[All distance_dims], [Card_Type_Dim ].[All Card_Type_Dim s], [sca_check_dim].[All sca_check_dims], [sca_exemption_dim].[All sca_exemption_dims], [fraud_type_dim].[All fraud_type_dims])} ON ROWS FROM [PSD2 CUBE]</MDXMondrianQuery>
<MDXQUERY>SELECT CrossJoin({[geographic_distribution_dim].[All geographic_distribution_dims], [geographic_distribution_dim].[Вътрешни], [geographic_distribution_dim].[Презгранични в рамките на ЕИП], [geographic_distribution_dim].[Презгранични извън ЕИП]}, {[Measures].[FRAUD_TRANSACTIONS_CT], [Measures].[FRAUD_TRANSACTIONS_VOL], [Measures].[TOTAL_TRANSACTIONS_CT], [Measures].[TOTAL_TRANSACTIONS_VOL]}) ON COLUMNS, {([route_dim].[All route_dims], [distance_dim].[All distance_dims], [Card_Type_Dim ].[All Card_Type_Dim s], [sca_check_dim].[All sca_check_dims], [sca_exemption_dim].[All sca_exemption_dims], [fraud_type_dim].[All fraud_type_dims])} ON ROWS FROM [PSD2 CUBE]</MDXQUERY>
<JSONTEMPLATE>{"olap":{"cube":{"reference":"schema_1_pentaho_PSD2"},"MDXMondrianQuery":{"XML_TAG_TEXT_CONTENT":"SELECT CrossJoin({[geographic_distribution_dim].[All geographic_distribution_dims], [geographic_distribution_dim].[Вътрешни], [geographic_distribution_dim].[Презгранични в рамките на ЕИП], [geographic_distribution_dim].[Презгранични извън ЕИП]}, {[Measures].[FRAUD_TRANSACTIONS_CT], [Measures].[FRAUD_TRANSACTIONS_VOL], [Measures].[TOTAL_TRANSACTIONS_CT], [Measures].[TOTAL_TRANSACTIONS_VOL]}) ON COLUMNS, {([route_dim].[All route_dims], [distance_dim].[All distance_dims], [Card_Type_Dim ].[All Card_Type_Dim s], [sca_check_dim].[All sca_check_dims], [sca_exemption_dim].[All sca_exemption_dims], [fraud_type_dim].[All fraud_type_dims])} ON ROWS FROM [PSD2 CUBE]"},"MDXQUERY":{"XML_TAG_TEXT_CONTENT":"SELECT CrossJoin({[geographic_distribution_dim].[All geographic_distribution_dims], [geographic_distribution_dim].[Вътрешни], [geographic_distribution_dim].[Презгранични в рамките на ЕИП], [geographic_distribution_dim].[Презгранични извън ЕИП]}, {[Measures].[FRAUD_TRANSACTIONS_CT], [Measures].[FRAUD_TRANSACTIONS_VOL], [Measures].[TOTAL_TRANSACTIONS_CT], [Measures].[TOTAL_TRANSACTIONS_VOL]}) ON COLUMNS, {([route_dim].[All route_dims], [distance_dim].[All distance_dims], [Card_Type_Dim ].[All Card_Type_Dim s], [sca_check_dim].[All sca_check_dims], [sca_exemption_dim].[All sca_exemption_dims], [fraud_type_dim].[All fraud_type_dims])} ON ROWS FROM [PSD2 CUBE]","parameter":[]}}}</JSONTEMPLATE>
<calculated_fields/>
</olap>
I really need the export to excel button from what if.