Xtract - Data Cube - Optimized version

[swapan]

Xcellent Rathi for Xtract!!!

2 b honest I've never gone to see what actually is pivot. In my previous organisation also it was used for data testing and in the development - pivot report was integerated in the grid (all the reports were based upon 3rd party grid tool - ComponentOne).

U've excellently described it..... do u give or use to give "private tutions"?! You are so nice in explaining things..... thanks a lot.

Your this creativity can become a powerful feature in our applications. Just consider the suggestions/feedbacks your are getting from us.

Its great that you've so much passion for HMG. Keep going!

Rgds,

Swapan

[Rathinagiri]

Thanks a lot friends.

I will again work on a new pre-release version of the utility with the suggestions and improvements presented by our members.

Swapan,

Yes. I take classes for Information Technology paper for CA students.

[swapan]

Yes. I take classes for Information Technology paper for CA students.

2 Good!

Start taking classes for HMG also!!
(I'm willing 2 join as a student// )

Eagerly awaiting for your this tool's next release....................................

Rgds,

Swapan

[dhaine_adp]

Hi Rathi,

Though you say it's premature but rather you have already code a very good Data Plotting Utility. For me I would suggest "HMGDataPlot" due to the following statistical reasons:

1. The end result is a valuable input to the decision makers.
2. The output can be used to run further analysis such as forecasting, linear regression,
Markov Chain (Monte Carlo Method), Deltas (like the one we used to see in stocks market)
and other host of statistical functions that is useful in analyzing trends to gain
competitive advantage (I mean business wise), fast moving items and seasonal product
movement, thereby empowering the end users by putting the best business tools on their
finger tips. Finally every users of this tools would let them maximize their assets
most especially cash in managing their business most especially in the period of
global recession.
3. The output can tap the power of HMG Graph facility.
4. I call it HMGDataPlot because using HB Class the code can be called as
Case 1
HMGDataPlot():New()
HMGDataPlot():Query(Area+ProductCode+Salesman) // or
HMGDataPlot():Query() ---> null parameters displays your query engine
HMGDataPlot():GridView() // display the query

Case 2
HMGDataPlot():Compare( Year1Month12, Year2Month12, Year3Month12 ) --> DBF or SQL Tables
HMGDataPlot():Query(Area+ProductCode+Salesman)
HMGDataPlot():Graph("BAR")

5. As you have said premature but it's already on the tip of data mining technology, we can borrow more from MATHLAB and in Neural Theory and Fractals, however as of the moment we don't have enough graphic facility to display them using HMG.


Congrats,


Danny

[sudip]

Hello Danny,
Thank you very much for this discussion! I found that everyday I am learning something from this forum
Thank you Rathi for this tool and for the knowledge we shall acquire from this tool
Regards.
Sudip

[Rathinagiri]

OLAP and data mining are very much required Business Intelligence Logics, which have to ported to HMG.

However, this is JUST a starting. I hope to join with more hands in this project to be more useful.

[Rathinagiri]

Here comes the optimized version of Xtract - HMGData Cube

For the past few weeks, I always had in my mind about this project, how to optimize it. I came to know that, it is the asort and ascan functions which took so much time. So, I had decided to write separate functions to search using b-tree logic etc.,

Then, one fine day, it stroke my mind that, I need not re-invent the wheel. In the mean time, there was a huge discussion about SQLite in HMG. I read about SQLite temporary database also.

I just tried to use SQLite temporary database in this project. By executing two simple SQL queries, I could create the Data Cube as desired. To my surprise, it solved the problem of optimization.

In this version I had added total/grand total also. Please check up and give your valuable suggestions as always.

xtract0.50.zip

(10.57 KiB) Downloaded 720 times

Some of improvements in my mind for version 1.0:

1. Live Data Cube (No requirement of pressing a button. As and when row/col/data are changed, we can see the change in the cube immediately.)
2. Ability to see the Data Cube in graphs.
3. Printing the cube.
4. Adding as a component in HFCL for any grid/browse control.

[fchirico]

Here comes the optimized version of Xtract - HMGData Cube


In this version I had added total/grand total also. Please check up and give your valuable suggestions as always.

rathinagiri:

The speed is amazing!. I have tried it with over 120,000 records and only took seconds. And the GRAND TOTAL is very useful.

Before running the button "Xtract" would be interesting to filter the desired records.

Excelete your work, but above all helpful.

Regards, Fernando Chirico.

[Rathinagiri]

Thanks for your comment and suggestion Fernando Chirico.

I am working on the next version.

[mol]

Nice!