Hi all,


I was importing im my company everything from Pentaho Pentaho 5.1.0.0.752 to Pentaho 7.1.0.0.12, including:


Pentaho BI
Pentaho PDI
Saiku Plugins
Create a clone of the DDBB
etc etc


Everything is fine but some MDX queries are not working fine.


In pentaho 7, in the manage date source section, I imported the schema "Controlling_CM.mondrian.xml", and dashboard were fine at 90% of contents.


I localize the problem, and is that this MDX query works perfectly in pentaho 5 (Done at 1.45s) and is continuosly thinking in pentaho 7




This is the MDX query:

Code:
WITH
MEMBER Measures.[O1 Turnover] AS '(Measures.[SP16 01 Turnover]) * 100'
MEMBER Measures.[   Sales] AS 'Iif([Comparative scenario].Currentmember IS [Comparative scenario].[A / SP], Measures.[Sales Final] * 100, Measures.[Sales Final] / 1000 )'
MEMBER Measures.[   Sales Portfolio] AS 'Iif([Comparative scenario].Currentmember IS [Comparative scenario].[A / SP], Measures.[Invoice portfolio Final] * 100, Measures.[Invoice portfolio Final] / 1000)'
MEMBER Measures.[O2 Profitability] AS '(Measures.[SP16 02 Profitability]) * 100'
MEMBER Measures.[   RBT] AS 'Iif([Comparative scenario].Currentmember IS [Comparative scenario].[A / SP], Measures.[Net Margin (%) Final] * 100, Measures.[Net Margin (%) Final]* 100)' 
MEMBER Measures.[   (DD+AS)/Sales] AS 'Iif([Comparative scenario].Currentmember IS [Comparative scenario].[A / SP], Measures.[(DD+AS) Sales Final] * 100, Measures.[(DD+AS) Sales Final] * 100)'
MEMBER Measures.[O3 Customer Diversification] AS 'Measures.[SP16 03 Customer Diversification] * 100'
MEMBER Measures.[   Customer Concentration] AS 'Iif([Comparative scenario].Currentmember IS [Comparative scenario].[A / SP], Measures.[Customer Concentration Final] * 100, Measures.[Customer Concentration Final])'
MEMBER Measures.[   Main Cust. Dependency] AS 'Iif([Comparative scenario].Currentmember IS [Comparative scenario].[A / SP], Measures.[Main Customer Dependency Final] * 100, Measures.[Main Customer Dependency Final] * 100)'
MEMBER Measures.[   Cust. w/ Sales > 500K EUR] AS 'Iif([Comparative scenario].Currentmember IS [Comparative scenario].[A / SP], Measures.[# Customers Sales > 500K EUR Final] * 100, Measures.[# Customers Sales > 500K EUR Final])'
MEMBER Measures.[O4 Business Diversification] AS 'Measures.[SP16 04 Business Diversification] * 100'
MEMBER Measures.[   Sales Non-traditional Business] AS 'Iif([Comparative scenario].Currentmember IS [Comparative scenario].[A / SP], Measures.[Sales Non-traditional Business Final] * 100, Measures.[Sales Non-traditional Business Final] / 1000)'
MEMBER Measures.[   Offers Non-traditional Business] AS 'Iif([Comparative scenario].Currentmember IS [Comparative scenario].[A / SP], Measures.[Offers Non-traditional Business Final] * 100, Measures.[Offers Non-traditional Business Final] / 1000)'
MEMBER Measures.[O5 Geographical Diversification] AS '(Measures.[SP16 05 Geografical Diversification]) * 100'
MEMBER Measures.[   Subsidiaries Concentration] AS 'Iif([Comparative scenario].Currentmember IS [Comparative scenario].[A / SP], Measures.[Subsidiaries Concentration Final] * 100, Measures.[Subsidiaries Concentration Final])'
MEMBER Measures.[O6 LEP Development] AS '(Measures.[SP16 06 Posicionar como integrador de Soluciones de explotacion y optimizacion]) * 100'
MEMBER Measures.[   LEP Sales / Sales] AS '(Measures.[LEP Sales (%)] * 100)'
MEMBER Measures.[O7 Increase Operational Marketing] AS '(Measures.[SP16 07 Increase Operational Marketing]) * 100'
MEMBER Measures.[   Amount Proposal] AS 'Iif([Comparative scenario].Currentmember IS [Comparative scenario].[A / SP], Measures.[Amount Proposal Final] * 100,  Measures.[Amount Proposal Final] / 1000)'
MEMBER Measures.[O8 Improve Technical Knowledge] AS '(Measures.[SP16 08 Improve Technical Knowledge]) * 100'
MEMBER Measures.[   Training Hours per Employee] AS 'Iif([Comparative scenario].Currentmember IS [Comparative scenario].[A / SP], Measures.[Personal training hours] * 100, Measures.[Personal training hours])'
MEMBER Measures.[O9 Guarantee QH&S] AS '(Measures.[SP16 09 Guarantee QH&S]) * 100'
MEMBER Measures.[   MSI / SSI] AS 'Iif([Comparative scenario].Currentmember IS [Comparative scenario].[A / SP], Measures.[MSI Final] * 100, Measures.[MSI Final])'
MEMBER Measures.[   Incidence Rate] AS 'Iif([Comparative scenario].Currentmember IS [Comparative scenario].[A / SP], Measures.[Incidence Rate Final] * 100,  Measures.[Incidence Rate Final])'
MEMBER Measures.[   MQI / SQI] AS 'Iif([Comparative scenario].Currentmember IS [Comparative scenario].[A / SP], Measures.[MQI Final] * 100,  Measures.[MQI Final])'
MEMBER Measures.[   Cust. Complaints / 20K Hrs Wkd] AS 'Iif([Comparative scenario].Currentmember IS [Comparative scenario].[A / SP], Measures.[RC NC_20kht Final] * 100,  Measures.[RC NC_20kht Final])'
MEMBER Measures.[O10 Improve Strategical Marketing] AS '(Measures.[SP16 10 Improvement Strategical Marketing]) * 100'
MEMBER Measures.[   Success Ratio] AS '(Measures.[Success Ratio]) * 100'
MEMBER Measures.[O11 HR Policies] AS '(Measures.[SP16 11 HR Policies]) * 100'
MEMBER Measures.[   Absenteeism Rt] AS '(Measures.[Absenteeism (%) Final]) * 100'
MEMBER Measures.[O12 Cost Optimization] AS '(Measures.[SP16 12 Cost Optimization]) * 100'
MEMBER Measures.[   % Gross Mg Cum.] AS 'Iif([Comparative scenario].Currentmember IS [Comparative scenario].[A / SP], Measures.[Gross Margin (%) Final] * 100, Measures.[Gross Margin (%) Final]* 100)' 
MEMBER Measures.[   Non Production Overhead] AS 'Iif([Comparative scenario].Currentmember IS [Comparative scenario].[A / SP], Measures.[Non Production Overhead Final] * 100, Measures.[Non Production Overhead Final] / 1000)'


SET [All_Cons] AS {
Measures.[O1 Turnover],
Measures.[O2 Profitability],
//Measures.[O3 Customer Diversification],
Measures.[O4 Business Diversification],
Measures.[O5 Geographical Diversification],
Measures.[O6 LEP Development],
Measures.[O7 Increase Operational Marketing],
Measures.[O8 Improve Technical Knowledge],
Measures.[O9 Guarantee QH&S],
Measures.[O10 Improve Strategical Marketing],
Measures.[O11 HR Policies],
Measures.[O12 Cost Optimization]
} 


SET [All_NonTrad] AS {
Measures.[O1 Turnover],
Measures.[O2 Profitability],
Measures.[O3 Customer Diversification],
Measures.[O4 Business Diversification],
Measures.[O5 Geographical Diversification],
Measures.[O6 LEP Development],
Measures.[O7 Increase Operational Marketing],
Measures.[O8 Improve Technical Knowledge],
Measures.[O9 Guarantee QH&S],
Measures.[O10 Improve Strategical Marketing],
Measures.[O11 HR Policies],
Measures.[O12 Cost Optimization]
} 


SET [All] AS {
Measures.[O1 Turnover],
Measures.[O2 Profitability],
//Measures.[O3 Customer Diversification],
Measures.[O4 Business Diversification],
//Measures.[O5 Geographical Diversification],
Measures.[O6 LEP Development],
Measures.[O7 Increase Operational Marketing],
Measures.[O8 Improve Technical Knowledge],
Measures.[O9 Guarantee QH&S],
Measures.[O10 Improve Strategical Marketing],
Measures.[O11 HR Policies],
Measures.[O12 Cost Optimization]
} 


SET [O1 Turnover] AS {
Measures.[O1 Turnover],
Measures.[   Sales], 
Measures.[   Sales Portfolio]
}


SET [O2 Profitability] AS {
Measures.[O2 Profitability],
Measures.[   RBT],
Measures.[   (DD+AS)/Sales]
}


SET [O3 Customer Diversification] AS {
Measures.[O3 Customer Diversification],
Measures.[   Customer Concentration],
Measures.[   Main Cust. Dependency],
Measures.[   Cust. w/ Sales > 500K EUR]
}


SET [O4 Business Diversification] AS {
Measures.[O4 Business Diversification],
Measures.[   Sales Non-traditional Business],
Measures.[   Offers Non-traditional Business]}


SET [O5 Geographical Diversification] AS {
Measures.[O5 Geographical Diversification],
Measures.[   Subsidiaries Concentration]
}


SET [O6 LEP Development] AS {
Measures.[O6 LEP Development],
Measures.[   LEP Sales / Sales]
}


SET [O7 Increase Operational Marketing] AS {
Measures.[O7 Increase Operational Marketing],
Measures.[   Amount Proposal]}


SET [O8 Improve Technical Knowledge] AS {
Measures.[O8 Improve Technical Knowledge],
Measures.[   Training Hours per Employee]}


SET [O9 Guarantee QH&S] AS {
Measures.[O9 Guarantee QH&S],
Measures.[   MSI / SSI],
Measures.[   Incidence Rate],
Measures.[   MQI / SQI],
Measures.[   Cust. Complaints / 20K Hrs Wkd]}


SET [O10 Improve Strategical Marketing] AS {
Measures.[O10 Improve Strategical Marketing],
Measures.[   Success Ratio]}


SET [O11 HR Policies] AS {
Measures.[O11 HR Policies],
Measures.[   Absenteeism Rt]}


SET [O12 Cost Optimization] AS {
Measures.[O12 Cost Optimization],
Measures.[   % Gross Mg Cum.],
Measures.[   Non Production Overhead]
} 


SELECT [All_Cons] ON ROWS,
{[Comparative scenario].[Strategic Plan], [Comparative scenario].[Actual], [Comparative scenario].[A / SP], [Comparative scenario].[A / SP]} ON COLUMNS


FROM [Aggr - CMI]
WHERE ([Previous year].[Current Year])