average and dbf file

Discussion forum for PivotCube VCL users. Common questions. Bug and problem reports

Moderator: Alex Zencovich

average and dbf file

Postby prosoft » Mon Nov 02, 2009 8:40 pm

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.
prosoft
User
 
Posts: 14
Joined: Tue Nov 27, 2007 3:35 pm

Re: average and dbf file

Postby AlexZencovich » Tue Nov 03, 2009 6:01 am

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)
Best regards,

Alex Zencovich
-------------------------------------------------------------------------------------------------------------------------------------------
www.pivotcube.com - OLAP solution for Delphi, C++ Builder and ActiveX environment
AlexZencovich
Site Admin
 
Posts: 580
Joined: Sun Jun 18, 2006 10:09 am

Re: average and dbf file

Postby prosoft » Thu Nov 05, 2009 7:15 am

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
User
 
Posts: 14
Joined: Tue Nov 27, 2007 3:35 pm

Re: average and dbf file

Postby prosoft » Thu Nov 05, 2009 12:13 pm

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.
prosoft
User
 
Posts: 14
Joined: Tue Nov 27, 2007 3:35 pm

Re: average and dbf file

Postby AlexZencovich » Thu Nov 05, 2009 7:30 pm

prosoft wrote: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.
Best regards,

Alex Zencovich
-------------------------------------------------------------------------------------------------------------------------------------------
www.pivotcube.com - OLAP solution for Delphi, C++ Builder and ActiveX environment
AlexZencovich
Site Admin
 
Posts: 580
Joined: Sun Jun 18, 2006 10:09 am

Re: average and dbf file

Postby prosoft » Fri Nov 06, 2009 10:03 am

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
User
 
Posts: 14
Joined: Tue Nov 27, 2007 3:35 pm

Re: average and dbf file

Postby prosoft » Fri Nov 06, 2009 12:32 pm

I resolved this problem. It was mismatch of zcube.DLL version.
Thanks. Josef.
prosoft
User
 
Posts: 14
Joined: Tue Nov 27, 2007 3:35 pm


Return to PivotCube VCL

Who is online

Users browsing this forum: No registered users and 5 guests

cron