PivotCube VCL and PivotCubeX

by **jarzeg** » Tue Jul 11, 2006 11:34 am

Hello,

how to add calculated measure by Pascal code?

Best regards

Grzegorz

by **AlexZencovich** » Tue Jul 11, 2006 11:38 am

Use procedure
PivotMap.AddCalculatedMeasure(Name,Formula : string);

call PivotMap.RefreshData(True) after all.

by **jarzeg** » Tue Jul 11, 2006 11:59 am

Hello,

on

PivotMap1.AddCalculatedMeasure(MyName,MyFormula);

i have under debuger: "Project MyProject.exe raised exception class EOleException with message 'Catastrophic error' "

I'm using version 7.3.1.57

by **AlexZencovich** » Tue Jul 11, 2006 12:12 pm

Was PivotMap active when you try to add measure? It must be active.

by **jarzeg** » Tue Jul 11, 2006 1:21 pm

Thanx

it was it,

Best regards

Grzegorz

by **jarzeg** » Tue Jul 11, 2006 3:01 pm

Hello once again,

how to by Pascal code to change CalcType for calculated measure?

Best regards

Grzegorz

by **AlexZencovich** » Tue Jul 11, 2006 4:02 pm

Calc. measure does not have CalcType. It calulated by provided formula.

by **jarzeg** » Tue Jul 11, 2006 7:51 pm

Hi,

I have thought, that it is possible because in Measure manager Calculation type is available for calculated measures too.

Best regards

Grzegorz

by **AlexZencovich** » Tue Jul 11, 2006 8:00 pm

Yes, because it is common form. But actually it will did nothing for calc. measures.

PivotCube VCL and PivotCubeX

Calculated Measures

Calculated Measures

Who is online