Decision Cube Capacity Problems.

Posted on 2005-05-16
Last Modified: 2012-05-05
Hi, i'm having problems creating a decision Cube in Delphi 7.  I use to have a DecisionQuery with 3 dimensions and 2 sumatories and the cube works fine- The problem is when i aggregated a fourth dimension. My DecisionQuery is somethiong like :

Select zone_no, sales_no, sku_id, period, sum(qty) qty, sum(total) value
from <table> where <Condition>
Group by zone_no, sales_no, sku_id, period
Order By zone_no, sales_no, sku_id, period

The DecisionQuery1 that was working fine was something like this :

Select  sales_no, sku_id, period, sum(qty) qty, sum(total) value
from <table> where <Condition>
Group by  sales_no, sku_id, period
Order By  sales_no, sku_id, period

        So, the only change is the first selected field in the query. The problem is that at runtime, when the programs executes the line "DecisionQuery1.Open" the program generates the cube with incomplete information it only appears the first 2 zones. I don't know if I need to have an index on the table or something like that.

    Other problem is, when the data in the result of the query is too much, the program sends an error message "DecicionCube Dimensions are exceeded. Change Dataset".

   Do you have a solution for this problem.
Question by:jpmonja
    LVL 6

    Accepted Solution

    Just a note: If you "group by" then you don't need to "order by" the same fields -irt is implicit in the group by- so you can take off the las line in both SQLs. I don't know if it will make any improvement, but give it a try, sometimes small changes like this make the SQL plan to change to better.

    Have you tried the EXACT SQL in a sql monitor to see if it returns information on more than 2 zones? Sometimes the simplier explanation is the one, and in your select may be only 2 zones are involved!

    Author Comment

    I've already done that and it doesn't work. i don't know if the table structure has something to do because the sales_no, sku_id and period are at the beginning of the table and the field zone_no is at the end of it.

       The EXACT SQL returns all the information.


    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    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…
    The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    730 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now