For mr. kretzschmar only

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.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.