[Webinar] Streamline your web hosting managementRegister Today


For mr. kretzschmar only

Posted on 2000-01-18
Medium Priority
Last Modified: 2010-04-06
Dear Mr. Meikl,
   Thanks for your suggestion, please give me detail explanation, how to use TDecision cube to solve my problem in Q.10259734.

Thanks from apin.
Question by:pc_melsa
1 Comment
LVL 27

Accepted Solution

kretzschmar earned 300 total points
ID: 2364086
hi pc_melsa,

? seemed to be a misunderstanding

a tdecisioncube is for querying data from a database and for calculating values like average or sum or max from the queried data. normally its used to visualize a compressed view of the queried data with the capability of drill down to base data.

its not used for storing data into a database, only retrieveing data, compressing in a given manner (aggregat-function) and grouping for visualizing the data on a form.

we've an orderdatabase with customers and orders.
the user will now see the sum of orders from the customers about one year.

we do now query orders between a date and sorting it by customerid, maybe we join the query with the customer-table to get the name into the query-result.

in the decisioncube we define to show first, the sum-value of orders for each customer. with a bit adjustments we can allow that the user can show by doubleclicking on a customer the monthly ordervalue of that customer and by doubleclicking of a month he could get the order of this month of this customer.

therefore a decisioncube is visualizing-tool for much detaildata, with the capability to show the amount in a compact manner and  to drill down to the detaillevel in defined steps.

hope this will clarify the use of tdecisioncube,
otherwise rephrase the question


Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Get the source code for a fully functional Access application shell with several popular security features that Access VBA application developers desire, but find difficult or impossible to figure out how to code. You get the source code for managi…
Suggested Courses

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question