average and dbf file

[prosoft]

I have this problem:
I am using pivot cube with dbf file.
I am sending small XML with description of measu, dimension atd.

AMeasureItem.DataType:=ftFloat

All fork fine when AMeasureItem.CalcType=ctSuma.

When i want to do CalcType:=ctAverage an error appears :

raise Exception.Create(FLNG.Values['pvCubeErr2'] + FMeasures.Item[i].AliasName);

Can you help me what can be wrong?

I am sending eurekalog as attachment.

[AlexZencovich]

As I can see exception happens just before any cube build started, so problem just in values passed to kernel before build. I may only suggest you to look which values returned by GetMeasureType(FMeasures.Item[i].CalcType)

[prosoft]

in PivodCube_SRC

try
for i := 0 to FMeasures.Count - 1 do
FCube.AddMeasure(FMeasures.Item[i].AliasName,
FMeasures.Item[i].FieldName,
Fmeasures.Item[i].DisplayName,
GetMeasureType(FMeasures.Item[i].CalcType),
TMeasureItem(FMeasures.Item[i]).FormatString);
except
raise Exception.Create(FLNG.Values['pvCubeErr2'] + FMeasures.Item[i].AliasName);
end;


FMeasures.Item[i].AliasName = 'PPP'
FMeasures.Item[i].FieldName=' POL2'
Fmeasures.Item[i].DisplayName= ''
GetMeasureType(FMeasures.Item[i].CalcType=2
TMeasureItem(FMeasures.Item[i]).FormatString='########0.00##'

and i am sending dbf file as attachament if declaration of columns is correct.

Some other idea?

Thanks Josef

[prosoft]

I have one question.
If i upgrade from my PivotCube VCL (with VCL sources) to PivotCube VCL full source than i can find out where the error directly in the source code.
What is the price of the upgrade and how can I get it?
PivotCube VCL nonDLL files means that i don't have to distribute zcube.dll with my application?

Thanks Josef.

[AlexZencovich]

I have one question.
If i upgrade from my PivotCube VCL (with VCL sources) to PivotCube VCL full source than i can find out where the error directly in the source code.
What is the price of the upgrade and how can I get it?
PivotCube VCL nonDLL files means that i don't have to distribute zcube.dll with my application?

Thanks Josef.

1. Upgrade price is 228$ as it stated on Order page.

2. I do not suggest you to order upgrade just to look where error happens. Just help me with understanding what really you do and what happens. That is better and easier way.

3. Yes. You will able to built-in zCube.dll code inside your app.

[prosoft]

Thanks for your answer.
I have application where front end client is char terminal. When i want to do any olap analyze i create on server dbf file with with data and small XML file where is description od dimension, measure ....( i sended example in previous message) and send it by ftp to client where i run OLAP form with these files. All works fine when i use ctSuma type. When i use ctAverage, ct Count ... types an error appears. That is all.
Thanks Josef:

I would like to buy upgrade to non DLL version. How can i send you order?

[prosoft]

I resolved this problem. It was mismatch of zcube.DLL version.
Thanks. Josef.