G
GdeB
Hi,
When using the OLAP cube through PWA (Analyze portfolio in portfolio
analyzer), you can create calculated fields. You can export reports to Excel
and any calculated fields remain. Calculated fields in Excel are correctly
updated when you later reuse the spreadsheet and update it from the OLAP
cube.
Completely creating the same report using Excel and VBA connected to the
OLAP cube, I have not been able to create calculated fields. The
documentation explicitly states that you can't do that using VBA.
What should I use to programmatically create weekly reports from scratch,
and still introduce calculated fields (% between 2 numbers on each detail
line)? If it is possible, would someone have an example?
Best regards,
Gilles.
When using the OLAP cube through PWA (Analyze portfolio in portfolio
analyzer), you can create calculated fields. You can export reports to Excel
and any calculated fields remain. Calculated fields in Excel are correctly
updated when you later reuse the spreadsheet and update it from the OLAP
cube.
Completely creating the same report using Excel and VBA connected to the
OLAP cube, I have not been able to create calculated fields. The
documentation explicitly states that you can't do that using VBA.
What should I use to programmatically create weekly reports from scratch,
and still introduce calculated fields (% between 2 numbers on each detail
line)? If it is possible, would someone have an example?
Best regards,
Gilles.