| |
|
support.dcube.misc
Started by webadmin@datadynamics.com at 07-25-2003 12:00 AM. Topic has 1 replies.
  
|
|
Sort Posts:
|
|
|
|
 07-25-2003, 12:00 AM
|
webadmin@datadynamics.com
Joined on 12-12-2005
Posts 0
|
Computed fields and performance
|
|
|
|
|
Originally Posted By: La civita Federico<lacivita.f@fater.it>
Hello,
I have a problem with calculated fields. When i retrieve e large amount of
data and the cube has a calculated field ( e.g. sales for the current year,
sales for the previous year and the (calculated) ratio between the current
year and the previous year ) the generation of the cube takes a very long
time (hours). If i delete the calculated field the time to generate the cube
takes less than one minute.
My feeling is that for each row retrieved from the SQL cursor, the cube
computes all the rows previsously inserted in the cube to resolve the
expression in the calulated field. I would like the cube to wait the fetch
of the last row from the dbms before starting to compute the calculated
field.
In detail:
I have an oracle 8 dbms
I develop my software with power builder 6.5
I have dynamicCube 2.5.01 version
my PC client has windows 98 operating system
the dynamicCube retrieves data from oracle by ODBC
The SQL query gets 300.000 rows
The cube has 18 dimension plus 8 data fields and 2 calculated fields
Without the calculated fields the time to generate the cube is 1 minute
With the calculated fileds the time to generate the cube is 2 hours
Best regards,
Federico La Civita
|
|
|
|
|
Report
|
|
|
|
|
07-25-2003, 12:00 AM
|
webadmin@datadynamics.com
Joined on 12-12-2005
Posts 0
|
Re: Computed fields and performance
|
|
|
|
|
|
Originally Posted By: Jennifer-DD<dynamicube.support@datadynamics.com>
Hi,
Dynamicube retrieves the information from the database, then it goes through
and does the calculations. I think if you update your Dynamicube control
you may see a big improvement in performance. Please reference the New
Hotfix Available post on 5/29/03. If you continue to have a problem please
let me know.
"La civita Federico" wrote in message
news:uoP0R0rUDHA.1356@dynaweb.datadynamics.com...
> Hello,
>
> I have a problem with calculated fields. When i retrieve e large amount
of
> data and the cube has a calculated field ( e.g. sales for the current
year,
> sales for the previous year and the (calculated) ratio between the current
> year and the previous year ) the generation of the cube takes a very long
> time (hours). If i delete the calculated field the time to generate the
cube
> takes less than one minute.
> My feeling is that for each row retrieved from the SQL cursor, the cube
> computes all the rows previsously inserted in the cube to resolve the
> expression in the calulated field. I would like the cube to wait the fetch
> of the last row from the dbms before starting to compute the calculated
> field.
>
> In detail:
>
> I have an oracle 8 dbms
> I develop my software with power builder 6.5
> I have dynamicCube 2.5.01 version
> my PC client has windows 98 operating system
> the dynamicCube retrieves data from oracle by ODBC
> The SQL query gets 300.000 rows
> The cube has 18 dimension plus 8 data fields and 2 calculated fields
> Without the calculated fields the time to generate the cube is 1 minute
> With the calculated fileds the time to generate the cube is 2 hours
>
> Best regards,
> Federico La Civita
>
>
|
|
|
|
|
Report
|
|
|
|
|
GrapeCity » Forum Archives » support.dcube.m... » Re: Computed fields and performance
|
|
|
|
|