I'm looking for a way to migrate our reporting van Cognos/TM1 to QV. The export from TM1 to QV is no problem, but, as we are reporting on accounts/acutal&budgetted amounts some of our KPI are calculations. In TM1 these calculations are defined, but exporting them to QV makes no sense as the Year value of (ex) our Spent Per Head is not th summary of every-months SPH. Its always Netsales/Visitors.
As we would create pivottables & straight tables to display basic numeric data it makes no sense to cerate a calculated column, the value of this kpi sould be available as the other accounts, but calculated every time depending the set-criteria.
Anubody has an idea on what approach should/could be taken.
